Man page of OCULAR
Section: Users manual (1)
Updated: NOVEMBER 2006
Return to Main Contents
ocular - a python spreadsheet
is the brand new linux spreadsheet written in
100% pure python. Every cell is first checked for any
standard spreadsheet coordinates, and then evaluated by
python. Future roadmap is readable from the file 'todo'.
Coordinates work just as in most spreadsheets. Use [letter][number] for
coordinates relative to the containing cell; prefix them with $ to fix it.
These coordinates are internally parsed to an expression python understands.
1/(2*sqrt(pi)) * exp(-D0**2)
in cell E0 will become
1/(2*sqrt(pi)) * exp(-data.eval([[0,4]]))
If you then select cells E0 to E30 and press <e>, E19 will
contain the expression:
1/(2*sqrt(pi)) * exp(-D19**2)
and so on. If you then select columns D and E and press <P>
the values found by python (clearly visible on your display)
will be send to Gnuplot, and a nice Gaussian might appear.
Sorting rows will destroy any logic in relative coordinates.
If you sort any thing with vertical structure, make sure
you first 'literalise' the content. To illustrate the dynamics of
here's an example of how to do this.
The prompt will change to
Then do something like:
for i in data[2:20]: i.expression = i.value
To 'literalise' the third column in rows #2 to 19.
This shows very well how this spreadsheet works. Maybe
this will be put into a shorthand function some day :)
give python command (coordinates are NOT parsed!)
edit current cell
read-in from file
write-out to file
sort selected rows
equate contents of current cel with rest of selection (TIY!)
move some selection to other location
clear all cells (new)
- <cursors> h l j k
move the selector
- H L J K
select a range of cells (the rxvt and xterm keycodes for S-<cursors> are different, and terminfo does not have entries for these)
or any thing in python (also import)
The line editor is pretty obvious. Cursor keys, <C-a> <C-k> <C-e> <BS> <del> and <CR> do things you expect them to.
still plenty. Known bugs are listed in the
file, which can be read using
, then type
Johan Hidding <hidding at astro dot rug dot nl>
- LINE EDITOR
- SEE ALSO
This document was created by
using the manual pages.
Time: 21:39:56 GMT, November 16, 2006