The
Xspread Reference Manual
gives complete documentation for the program. The LaTeX source copy
for this manual is called xspread.tex, and the DVI translation is
named xspread.dvi. Both are found in the directory /usr/local/doc/xspread.
Xspread supports many standard spreadsheet features.
Among these are:
* Cell entry and editing.
* Worksheet size: 702 columns by unlimited rows.
* File reading and writing.
* File encryption.
* Absolute and relative cell references.
* Numeric and label (i.e.character string) data in
cells.
* Left or right justification for labels.
* Row and column insertion and deletion.
* Hiding and unhiding of rows and columns.
* Range names.
* Manual or automatic recalculation.
* Numeric operators (+, -, *, /, ^(exponentiation),
%(remaindering))
* Relational operators (<, <=, >, >=, =, !=(not equal))
* Logical (or, Boolean) operators (&(and), |(or),
~(not))
* Function references.
* Graphs (XY, Bar, Stack Bar, Pie and Line graphs)
* Matrix Operations (Transpose, Multiply, Add, Subtract
and Inversion)
* Cursor positioning with mouse
* Menu item selection with mouse
* References to external programs. These are called
external functions.
The structure and operation of the spreadsheet is similar to but not
identical with popular spreadsheets such as Lotus 1-2-3 and its clones. Like
other spreadsheets, the workspace is arranged into rows and columns of cells.
Each cell can contain a number, a label (i.e. character string), or a formula
which evaluates to a number or label.
You can start the program with or without specifying a file to be read in.
This file must be a saved worksheet. If a file is specified on the command
line, xspread attempts to locate and read in the file. If it is successful,
xspread starts with the file's contents in the workspace. If it is
unsuccessful or no file is specified on the command line, xspread starts with
the workspace empty.
For a tutorial of the spreadsheet program, run one of the demo
files: demo, demo_math, demo_matrix, see the file Sample_Run in the
doc directory.
Default: Row order recalculation.
Default: Automatic recalculation.
* If the first character is a numeral, a "+" sign, or a "-" sign, the cell contains a number.
* If the first character is a greater than sign (>), less than sign (<), or double quote ("), the cell contains a label.
* If it is anything else, the character is a command to xspread.
With standard entry mode, you must use the first character to tell xspread whether the cell is a number or a label.
* If the cell is to be a number, the first character must be an "=" sign.
* If the cell is to be a label, the first character must be a double quote ("), less than sign (<), or greater than sign (>).
Default: Standard data entry mode.
Default: Row order recalculation.
Default: Do not use encryption.