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.