Table of Contentssc - spreadsheet calculator sc [ -c ] [ -m ] [ -n ] [ -r ] [ -x ] [ file ] The spreadsheet calculator sc is based on rectangular tables much like a financial spreadsheet. When invoked it presents you with a table organized as rows and columns of cells. If invoked without a file argument, the table is initially empty. Otherwise file is read in (see the Get command below). Each cell may have associated with it a numeric value, a label string, and/or an expression (formula) which evaluates to a numeric value or label string, often based on other cell values. For a on-line tutorial, type the command:
- sc #LIBDIR#/tutorial.sc
To print a quick reference card, type the command:
- scqref | [your_printer_commmand]
- -c
- Start the program with the recalculation being done in column order.
- -m
- Start the program with automatic recalculation disabled. The spreadsheet will be recalculated only when the ``@'' command is used.
- -n
- Start the program in quick numeric entry mode (see below).
- -r
- Start the program with the recalculation being done in row order (default option).
- -x
- Cause the Get and Put commands (see below) to encrypt and decrypt data files.
- -R
- Start the program with automatic newline action set to increment the row (see below).
- -C
- Start the program with automatic newline action set to increment the column (see below).
All of these options can be changed with the ^T and S commands (see below) while sc is running. Options specified when sc is invoked override options saved in the data file.
The screen is divided into four regions. The top line is for entering commands and displaying cell values. The second line is for messages from sc. The third line and the first four columns show the column and row numbers, from which are derived cell addresses, e.g. A0 for the cell in column A, row 0. Note that column names are case-insensitive: you can enter A0 or a0. The rest of the screen forms a window looking at a portion of the table. The total number of display rows and columns available, hence the number of table rows and columns displayed, is set by curses(3) and may be overridden by setting the LINES and COLUMNS environment variables, respectively.
The screen has two cursors: a cell cursor, indicated by a highlighted cell and a ``<'' on the screen, and a character cursor, indicated by the terminal's hardware cursor. The cell and character cursors are often the same. They differ when you type a command on the top line.
If a cell's numeric value is wider than the column width (see the f command), the cell is filled with asterisks. If a cell's label string is wider than the column width, it is truncated at the start of the next non-blank cell in the row, if any.
Cursor control commands and row and column commands can be prefixed by a numeric argument which indicates how many times the command is to be executed. You can type ^U before a repeat count if qui
www.fiveanddime.net