4.5.1 Opening a spreadsheet
You can open a spreadsheet (or a matrix editor) with the
Spreadsheet▸New Spreadsheet menu item or
with the key Alt+T.
When you open a new spreadsheet, you will be given a configuration
screen with the following options:
-
Variable
This has a input field where you can type in a variable name; the
spreadsheet will be saved as a matrix in this variable.
- Rows and Columns
These have input fields where you can type in positive integers
specifying the number of rows and columns in the spreadsheet.
- Eval
This has a checkbox. If the box is checked, then the
spreadsheet will be re-evaluated every time you make a change to it.
If it is not checked, it won’t be re-evaluated when changes are
made, but you can still re-evaluate the spreadsheet
with the eval button on the spreadsheet menu bar.
- Distribute
This has a checkbox. If it is checked, then entering a matrix
will distribute the contents across an appropriate array of cells.
If it is not checked, then the matrix will be put in one cell.
- Landscape
This has a checkbox. If it is checked, then
the graphical representation of the spreadsheet will be displayed
below the spreadsheet. If it is not checked, then it will be
displayed to the right of the spreadsheet.
- Move right
This has a checkbox. If it is checked, then the cursor will move
to the cell to the right of the current cell
when data is entered. If this is not checked, the cursor will be moved to
the cell below the current cell.
- Spreadsheet
This has a checkbox. If it is checked, the spreadsheet will be
formatted as a spreadsheet. If it is not checked, it will be
formatted as a matrix.
- Graph
This has a checkbox. If it is checked, the graphical representation of the
spreadsheet will be displayed. If it is not checked, the graphical
representation will not be displayed.
- Undo history
This has an input field where you can type in a postive integer,
specifying how many undo’s can be performed at a time.
The configuration screen can be reopened with the
Edit▸Configuration▸Cfg
window menu attached to the spreadsheet.