rsalz@bbn.com (Rich Salz) (09/05/90)
Submitted-by: Jeff Buhrt <sawmill!buhrt> Posting-number: Volume 23, Issue 21 Archive-name: sc6.8/part01 This is a much modified version of the public domain spread sheet sc, posted several years ago by Mark Weiser as vc, originally by James Gosling. Starting 4/4/90: (I will be maintaining Sc for a while at least, Robert Bond has been very busy lately) Sc is not a product of Grauel Enterprises, Inc. It is supplied as is with no warranty, express or implied, as a service to Usenet readers. It is not copyrighted, either. Have at it. Jeff Buhrt Grauel Enterprises, Inc. {pur-phy (aka: newton.physics.purdue.edu), sequent}!sawmill!buhrt #! /bin/sh # This is a shell archive. Remove anything before this line, then feed it # into a shell via "sh file" or similar. To overwrite existing files, # type "sh file -c". # The tool that generated this appeared in the comp.sources.unix newsgroup; # send mail to comp-sources-unix@uunet.uu.net if you want that tool. # Contents: README MANIFEST sc.doc # Wrapped by rsalz@litchi.bbn.com on Fri Jul 13 15:24:17 1990 PATH=/bin:/usr/bin:/usr/ucb ; export PATH echo If this archive is complete, you will see the following message: echo ' "shar: End of archive 1 (of 6)."' if test -f 'README' -a "${1}" != "-c" ; then echo shar: Will not clobber existing file \"'README'\" else echo shar: Extracting \"'README'\" \(3004 characters\) sed "s/^X//" >'README' <<'END_OF_FILE' XThis is a much modified version of the public domain spread sheet sc, Xposted several years ago by Mark Weiser as vc, originally by James Gosling. X XChanges since my last version (5.1) are detailed at great length :-) Xin CHANGES (sequent!rgb (Robert Bond)). X XWhen you get it built, try "sc tutorial.sc" for a simple introduction Xto the basic commands. X XA new input parser program (psc) has been included. This program Xformats ascii files for use in the spread sheet. If you don't have Xgetopts, there is a public domain version by Henry Spencer hidden away Xin the VMS_NOTES file. X XI have modified the makefile to make it easy for you to call the Xprogram what you want (I saw at least five different names in Xcorrespondence and on the net). Just change "name=sc" and "NAME=SC" to X"name=myfavoritename" and "NAME=MYFAVORITENAME" and try "make Xmyfavoritename". X XSimilarly, you can make the documentation with "make myfavoritename.man". X"make install" will make and install the code in EXDIR. The Xinstallation steps and documentation all key off of the name. The Xmakefile even changes the name in the nroffable man page. If you don't Xhave nroff, you will have to change sc.man yourself. X XThis release has been tested against a Sequent S81 running DYNIX 3.0.14 X(BSD 4.2) and an ICM-3216 with system V.3. The ICM has a National Semi X32016. Just check the makefile for the system flags. I have heard Xreports of lots of other machines that work. If you have problems with Xlex.c, and don't care about arrow keys, define SIMPLE (-DSIMPLE in the Xmakefile). SIMPLE causes the arrow keys to not be used. X XGuidelines for Hackers: X XIf you want to send changes you have made to SC, please feel free to do Xso. If they work :-) and seem worthwhile, I'll put them in. Please Xrefrain from wholesale "style" or "cleanup" changes. It is easy to add Xyour changes but it makes it hard to merge in the next guy's stuff if Xhe used the release as a base. Leave my $Revision: identifiers alone- Xthey help me track what you used as a base. If you check the code into Xrcs, delete the "$"s on the Revison lines before you do. X XYou may not like 4 space indenting and curly braces on the "if" line, Xbut your code will look like that before it leaves my hands so you may Xas well abide by the style in the code when you make your changes. I Xhave also been known to break things trying to make them look "right". XIf you do string functions, please, PLEASE pay attention to null Xpointers, use xmalloc and xfree, and xfree those arguments. And Xdon't forget to document your changes in both help.c and sc.doc. X XDisclaimer: X XStarting 4/4/90: (I will be maintaining Sc for a while at least, X Robert Bond has been very busy lately) XSc is not a product of Grauel Enterprises, Inc. It is supplied as Xis with no warranty, express or implied, as a service to Usenet readers. XIt is not copyrighted, either. Have at it. X X Jeff Buhrt X Grauel Enterprises, Inc. X {pur-phy (aka: newton.physics.purdue.edu), sequent}!sawmill!buhrt END_OF_FILE if test 3004 -ne `wc -c <'README'`; then echo shar: \"'README'\" unpacked with wrong size! fi # end of 'README' fi if test -f 'MANIFEST' -a "${1}" != "-c" ; then echo shar: Will not clobber existing file \"'MANIFEST'\" else echo shar: Extracting \"'MANIFEST'\" \(983 characters\) sed "s/^X//" >'MANIFEST' <<'END_OF_FILE' X File Name Archive # Description X---------------------------------------------------------- XREADME 1 XMANIFEST 1 This shipping list XCHANGES 5 XMakefile 6 XTODO 6 XVMS_NOTES 6 Xcmds.c 4 Xcrypt.c 6 Xeres.sed 5 Xgram.y 5 Xhelp.c 3 Xinterp.c 2 Xlex.c 4 Xpsc.c 4 Xpsc.doc 5 Xrange.c 5 Xsc.c 3 Xsc.doc 1 Xsc.h 5 Xsc6.8p1.hdr 2 Xsc6.8p2.hdr 6 Xsc6.8p3.hdr 6 Xsc6.8p4.hdr 6 Xsres.sed 2 Xtutorial.sc 6 Xversion.c 5 Xvi.c 5 Xvmtbl.c 5 Xxmalloc.c 4 END_OF_FILE if test 983 -ne `wc -c <'MANIFEST'`; then echo shar: \"'MANIFEST'\" unpacked with wrong size! fi # end of 'MANIFEST' fi if test -f 'sc.doc' -a "${1}" != "-c" ; then echo shar: Will not clobber existing file \"'sc.doc'\" else echo shar: Extracting \"'sc.doc'\" \(45229 characters\) sed "s/^X//" >'sc.doc' <<'END_OF_FILE' X.\" Warning: The string "pname" is converted to the true program name X.\" by the makefile, throughout this document. X.\" X.\" Warning: The order of presentation of commands largely matches the X.\" help screen built into the program. X.\" X.\" Conventions: X.\" - pname italicized and never uppercased (it's a proper name). X.\" - Refer to lists of commands in the same order as introduced. X.\" - Command and function names bold when introduced, italicized in all X.\" other places if possible, or in `` '' if not. X.\" - Cell names italicized except when used in expressions; row numbers X.\" and column names not italicized. X.\" - Use `` '' rather than " " except referring to literal input or output. X.\" - TPs use default indent except for function names, then 18. X.\" - Smallify uppercase strings. X.\" - Avoid passive voice and third person. X.\" $Revision: 6.8 $ X.\" X.TH PNAME 1 X.SH NAME Xpname \- spreadsheet calculator X.SH SYNOPSIS X.B pname X[ X.B -c X] X[ X.B -m X] X[ X.B -n X] X[ X.B -r X] X[ X.B -x X] X[ X.I file X] X.\" ========== X.SH DESCRIPTION XThe spreadsheet calculator X.I pname Xis based on rectangular tables much like a financial spreadsheet. XWhen invoked it presents you with a table Xorganized as rows and columns of cells. XIf invoked without a X.I file Xargument, the table is initially empty. XOtherwise X.I file Xis read in (see the X.I Get Xcommand below). XEach cell may have associated with it Xa numeric value, Xa label string, Xand/or an expression (formula) Xwhich evaluates to a numeric value or label string, Xoften based on other cell values. X.\" ---------- X.PP XOptions are: X.\" ---------- X.TP X.B \-c XStart the program with the recalculation being done in column order. X.\" ---------- X.TP X.B \-m XStart the program with automatic recalculation disabled. XThe spreadsheet will be recalculated only when the ``@'' command is used. X.\" ---------- X.TP X.B \-n XStart the program in quick numeric entry mode (see below). X.\" ---------- X.TP X.B \-r XStart the program with the recalculation being done in row Xorder (default option). X.\" ---------- X.TP X.B \-x XCause the X.I Get Xand X.I Put Xcommands (see below) to encrypt and decrypt data files. X.\" ---------- X.PP XAll of these options can be changed with the X.I ^T Xand X.I S Xcommands (see below) while X.I pname Xis running. Options specified when X.I pname Xis invoked Xoverride options saved in the data file. X.\" ========== X.SS "General Information" X.\" ---------- XThe screen is divided into four regions. XThe top line is for entering commands and displaying cell values. XThe second line is for messages from X.IR pname . XThe third line and the first four columns show the column and row numbers, Xfrom which are derived cell addresses, e.g. X.I A0 Xfor the cell in column A, row 0. XNote that column names are case-insensitive: you can enter X.I A0 Xor X.IR a0 . X.\" ---------- X.PP XThe rest of the screen forms a window looking at a portion of the table. XThe total number of display rows and columns available, Xhence the number of table rows and columns displayed, Xis set by X.IR curses (3) Xand may be overridden by setting the X.SM LINES Xand X.SM COLUMNS Xenvironment variables, respectively. X.\" ---------- X.PP XThe screen has two cursors: Xa cell cursor, indicated by a highlighted cell and a ``<'' on the screen, Xand a character cursor, indicated by the terminal's hardware cursor. XThe cell and character cursors are often the same. XThey differ when you type a command on the top line. X.\" ---------- X.PP XIf a cell's numeric value is wider than the column width (see the X.I f Xcommand), the cell is filled with asterisks. XIf a cell's label string is wider than the column width, Xit is truncated at the start of the next non-blank cell in the row, if any. X.\" ---------- X.PP XCursor control commands and row and column commands Xcan be prefixed by a numeric argument Xwhich indicates how many times the command is to be executed. XYou can type X.I ^U Xbefore a repeat count if quick numeric entry mode is enabled Xor if the number is to be entered Xwhile the character cursor is on the top line. X.\" ---------- X.PP XCommands which use the terminal's control key, such as X.IR ^N , Xwork both when a command is being typed and when in normal mode. X.\" ========== X.SS "Changing Options" X.\" ---------- X\0 \" exactly one blank line (hard to get) X.PD 0 X.TP X.BI ^T o XToggle options. XThis command allows you to switch the state of one option selected by X.IR o . XA small menu lists the choices for X.I o Xwhen you type X.IR ^T . XThe options selected are saved when the data and formulas are saved Xso that you will have the same setup next time you enter the Xspreadsheet. X.PD X.RS X.\" ---------- X.TP X.B a XAutomatic Recalculation. XWhen set, each change in the spreadsheet causes the entire spreadsheet Xbe recalculated. Normally this is not noticeable, but for very large Xspreadsheets, it may be faster to clear automatic recalculation mode and Xupdate the spreadsheet via explicit ``@'' commands. Default is Xautomatic recalculation on. X.\" ---------- X.TP X.B c XCurrent cell highlighting. XIf enabled, the current cell is highlighted X(using the terminal's standout mode, if available) Xin addition to being marked by the cell cursor. X.\" ---------- X.TP X.B e XExternal function execution. XWhen disabled, external functions (see X.IR @ext () Xbelow) are not called. XThis saves a lot of time at each screen update. XExternal functions are disabled by default. XIf disabled, and external functions are used anywhere, Xa warning is printed each time the screen is updated, Xand the result of X.IR @ext () Xis the value from the previous call, if any, or a null string. X.\" ---------- X.TP X.B n XQuick numeric entry. XIf enabled, Xa typed digit is assumed to be Xthe start of a numeric value for the current cell, Xnot a repeat count, unless preceded by X.IR ^U . X.\" ---------- X.TP X.B t XTop line display. XIf enabled, Xthe name and value of the current cell is displayed on the top line. XIf there is an associated label string, Xthe first character of the string value Xis ``<'' for a leftstring or ``>'' for a rightstring (see below), Xfollowed by "\fIstring\fP" for a constant string Xor X.RI { expr } Xfor a string expression. XIf the cell has a numeric value, Xit follows as X.RI [ value ], Xwhich may be a constant or expression. X.\" ---------- X.TP X.B x XEncryption. XSee the X.B \-x Xoption. X.\" ---------- X.TP X.B $ XDollar prescale. XIf enabled, all numeric X.B constants X(not expressions) which you enter are multipled by 0.01 Xso you don't have to keep typing the decimal point Xif you enter lots of dollar figures. X.RE X.\" ---------- X\0 \" exactly one blank line (hard to get) X.PD 0 X.TP X.B S XSet options. This command allows you to set various options. XA small menu lists the options that cannot be changed through X.I ^T Xabove. X.PD X.RS X.TP X.BR byrows / bycols XSpecify the order cell evaluation when updating. These options also affect Xthe order in which cells are filled (see X.IR /f ) Xand whether a row or column is cleared by an X.I x Xcommand. X.TP X.BI iterations =n XSet the maximum number of recalculations before Xthe screen is displayed again. X.I Iterations Xis set to 10 by default. X.TP X.BI tblstyle =s XControl the output of the X.I T Xcommand. X.I s Xcan be: X.B 0 X(default) to give colon delimited fields, with no X.I tbl Xcontrol lines; X.B tbl Xto give colon delimited fields, with X.IR tbl (1) Xcontrol lines; X.B latex Xto give a X.I LaTeX Xtabular environment; and X.B tex Xto give a X.I TeX Xsimple tabbed alignment with ampersands as delimiters. X.PP XOther X.I Set Xoptions are normally used only in X.I pname Xdata files since they are available through X.IR ^T . XYou can also use them interactively X.TP X.BR autocalc / !autocalc XSet/clear auto recalculation mode. X.TP X.BR numeric / !numeric XSet/clear numeric mode. X.TP X.BR prescale / !prescale XSet/clear numeric prescale mode. X.TP X.BR extfun / !extfun XEnable/disable external functions. X.TP X.BR cellcur / !cellcur XSet/clear current cell highlighting mode. X.TP X.BR toprow / !toprow XSet/clear top row display mode. X.RE X.\" ========== X.SS "Cursor Control Commands" X.\" ---------- X\0 \" exactly one blank line (hard to get) X.PD 0 X.TP X.B ^P XMove the cell cursor up to the previous row. X.PD X.\" ---------- X.TP X.B ^N XMove the cell cursor down to the next row. X.\" ---------- X.TP X.B ^B XMove the cell cursor backward one column. X.\" ---------- X.TP X.B ^F XMove the cell cursor forward one column. X.\" ---------- X.TP X.B "h, j, k, l" XIf the character cursor is not on the top line, these are alternate, X.IR vi -compatible Xcell cursor controls (left, down, up, right). X.\" ---------- X.TP X.B ^H XIf the character cursor is not on the top line, X.I ^H Xis the same as X.IR ^B . X.\" ---------- X.TP X.B SPACE XIf the character cursor is not on the top line, Xthe space bar is the same as X.IR ^F . X.\" ---------- X.TP X.B TAB XIf the character cursor is on the top line, X.SM TAB Xstarts a range (see below). XOtherwise, it is the same as X.IR ^F . X.\" ---------- X.TP X.B "Arrow Keys" XThe terminal's arrow keys provide another alternate set of cell cursor controls Xif they exist and are supported in the appropriate X.I termcap Xentry. XSome terminals have arrow keys which conflict with other control key codes. XFor example, a terminal might send X.I ^H Xwhen the back arrow key is pressed. XIn these cases, the conflicting arrow key performs the same function Xas the key combination it mimics. X.\" ---------- X.TP X.B ^ XMove the cell cursor up to row 0 of the current column. X.\" ---------- X.TP X.B # XMove the cell cursor down to the last valid row of the current column. X.\" ---------- X.TP X.B 0 XMove the cell cursor backward to column A of the current row. XThis command must be prefixed with X.I ^U Xif quick numeric entry mode is enabled. X.\" ---------- X.TP X.B $ XMove the cell cursor forward to the last valid column of the current row. X.\" ---------- X.TP X.B b XScan the cursor backward (left and up) to the previous valid cell. X.\" ---------- X.TP X.B w XScan the cursor forward (right and down) to the next valid cell. X.\" ---------- X.TP X.BI ^E d XGo to end of range. XFollow X.I ^E Xby a direction indicator such as X.I ^P Xor X.IR j . XIf the cell cursor starts on a non-blank cell, Xit goes in the indicated direction until the last non-blank adjacent cell. XIf the cell cursor starts on a blank cell, Xit goes in the indicated direction until the first non-blank cell. XThis command is useful when specifying ranges of adjacent cells (see below), Xespecially when the range is bigger than the visible window. X.\" ---------- X.TP X.B g XGo to a cell. X.I pname Xprompts for a cell's name, a regular expression surrounded by Xquotes, or a number. XIf a cell's name such as X.I ae122 Xor a the name of a defined range is given, the cell cursor goes Xdirectly to that cell. XIf a quoted regular expression such as " X.I Tax Table X" or " X.I ^Jan [0-9]*$ X" is given, X.I pname Xsearches for a cell containing a string matching the regular Xexpression. XSee X.I regex(3) Xor X.I ed(1) Xfor more details on the form of regular Xexpressions. XIf a number is given, X.I pname Xwill search for a cell containing that number. XSearches for either strings or numbers proceed forward from the Xcurrent cell, wrapping back to a0 at the end of the table, and Xterminate at the current cell if the string or number is not found. XThe last X.I g Xcommand is saved, and can be re-issued by entering X.IR g<return> . X.\" ========== X.SS "Cell Entry and Editing Commands" X.\" ---------- XCells can contain both a numeric value and a string value. XEither value can be the result of an expression, Xbut not both at once, Xi.e. each cell can have only one expression associated with it. XEntering a valid numeric expression Xalters the cell's previous numeric value, if any, Xand replaces the cell's previous string expression, if any, Xleaving only the previously computed constant label string. XLikewise, entering a valid string expression Xalters the cell's the previous label string, if any, Xand replaces the cell's previous numeric expression, if any, Xleaving only the previously computed constant numeric value. X.TP X.B = XEnter a numeric constant or expression into the current cell. X.I pname Xprompts for the expression on the top line. XThe usual way to enter a number into a cell is to type ``='', Xthen enter the number in response to the prompt on the top line. XThe quick numeric entry option, enabled through the X.B \-n Xoption or X.I ^T Xcommand, shows the prompt when you enter the first digit of a number X(you can skip typing ``=''). X.\" ---------- X.TP X.B < XEnter a label string into the current cell Xto be flushed left against the left edge of the cell. X.\" ---------- X.IP \fB"\fP X.PD 0 X.TP X.B > XEnter a label string into the current cell Xto be flushed right against the right edge of the cell. X.PD X.\" ---------- X.PP XStrings you enter must start with ". XYou can leave off the trailing " and X.I pname Xwill add it for you. XYou can also enter a string expression Xby backspacing over the opening " in the prompt. X.\" ---------- X.TP X.B e XEdit the value associated with the current cell. XThis is identical to ``='' Xexcept that the command line starts out containing Xthe old numeric value or expression associated with the cell. X.\" ---------- X.TP X.B E XEdit the string associated with the current cell. XThis is identical to ``<'', ``"'', or ``>'' Xexcept that the command line starts out containing Xthe old string value or expression associated with the cell. X.\" ---------- X.PP XTo enter and edit a cell's number part, use the ``='' and X.I e Xcommands. XTo enter and edit a cell's string part, use the ``<'', ``"'', ``>'', and X.I E Xcommands. XSee the sections below on numeric and string expressions for more information. X.\" ---------- X.TP X.B x XClear the current cell. XDeletes the numeric value, label string, and/or numeric or string expression. XYou can prefix this command with a count Xof the number of cells on the current row to clear. The current column is Xused if column recalculation order is set. XCells cleared with this command may be recalled Xwith any of the X.I pull Xcommands (see below). X.\" ---------- X.TP X.B m XMark a cell to be used as the source for the X.I copy Xcommand. X.\" ---------- X.TP X.B c XCopy the last marked cell to the current cell, Xupdating row and column references in its numeric or string expression, if any. X.\" ---------- X.TP X.B + XIf not in numeric mode, add the current numeric argument (default 1) Xto the value of the current cell. In numeric mode, ``+'' introduces a new Xnumeric expression or value, the same as ``=''. X.\" ---------- X.TP X.B - XIf not in numeric mode, subtract the current numeric argument (default 1) Xfrom the value of the current cell. In numeric mode, ``-'' introduces a new, Xnegative, numeric expression or value, like ``=''. X.\" ========== X.SS "File Commands" X.\" ---------- X\0 \" exactly one blank line (hard to get) X.PD 0 X.TP X.B G XGet a new database from a file. XIf encryption is enabled, Xthe file is decrypted before it is loaded into the spreadsheet. X.PD X.\" ---------- X.TP X.B P XPut the current database into a file. XIf encryption is enabled, Xthe file is encrypted before it is saved. X.\" ---------- X.TP X.B W XWrite a listing of the current database into a file Xin a form that matches its appearance on the screen. XThis differs from the X.I Put Xcommand in that its files are intended to be reloaded with X.IR Get , Xwhile X.I Write Xproduces a file for people to look at. Hidden rows or columns Xare not shown when the data is printed. X.\" ---------- X.TP X.B T XWrite a listing of the current database to a file, Xbut include delimiters suitable for processing by the X.IR tbl , X.IR LaTeX , Xor X.I TeX Xtable processors. XThe delimiters are controlled by the X.I tblstyle Xoption. See X.I Set Xabove. XThe delimters are are a colon\ (:) for style X.IR 0 or tbl Xand an ampersand\ (&) for style X.IR latex or tex . X.\" ---------- X.PP XWith the X.IR Put , X.IR Write , Xand X.I Table Xcommands, the optional range argument writes a subset of the spreadsheet to Xthe output file. X.\" ---------- X.PP XWith the X.I Write Xand X.I Table Xcommands, if you try to write to the last file used with the X.I Get Xor X.I Put Xcommands, or the file specified on the command line when X.I pname Xwas invoked, you are asked to confirm Xthat the (potentially) dangerous operation is really what you want. X.\" ---------- X.PP XThe three output commands, X.IR Put , X.IR Write , Xand X.IR Table , Xcan pipe their (unencrypted only) output to a program. XTo use this feature, Xenter ``| program'' to the prompt asking for a filename. XFor example, to redirect the output of the X.I Write Xcommand to the printer, Xyou might enter ``| lpr -p''. X.\" ---------- X.TP X.B M XMerge the database from the named file into the current database. XValues and expressions defined in the named file Xare read into the current spreadsheet Xoverwriting the existing entries at matching cell locations. X.\" ---------- X.TP X.B R XRun macros. XSince X.I pname Xfiles are saved as ASCII files, Xit is possible to use them as primitive macro definition files. XThe X.I Run Xcommand makes this easier. XIt's like the X.I Merge Xcommand, Xbut prints a saved path name as the start of the filename to merge in. XThe string to use is set with the X.I Define Xcommand. XTo write macros, you must be familiar with the file format written by the X.I Put Xcommand. XThis facility is still primitive and could be much improved. X.\" ---------- X.TP X.B D XDefine a path for the X.I Run Xcommand to use. X.\" ---------- X.PP XAll file operations take a filename as the first argument Xto the prompt on the top line. XThe prompt supplies a " to aid in typing in the filename. XThe filename can also be obtained from a cell's label string Xor string expression. XIn this case, delete the leading " with the backspace key Xand enter a cell name such as X.I a22 Xinstead. XIf the resulting string starts with ``|'', Xthe rest of the string is interpreted as a X.SM UNIX Xcommand, as above. X.\" ========== X.SS "Row and Column Commands" X.\" ---------- XThese commands can be used on either rows or columns. XThe second letter of the command is either a row designator X(one of the characters X.IR r , X.IR ^B , X.IR ^F , X.IR h , X.IR l ) Xor a column designator (one of X.IR c , X.IR ^P , X.IR ^N , X.IR k , X.IR j ). XA small menu lists the choices for the second letter Xwhen you type the first letter of one of these commands. XCommands which move or copy cells Xalso modify the row and column references in affected cell expressions. XThe references may be frozen by using the X.I fixed Xoperator or using the X.I $ Xcharacter in the reference to the cell (see below). X.\" ---------- X.TP X.B "ir, ic" XInsert a new row (column) Xby moving the row (column) containing the cell cursor, Xand all following rows (columns), down (right) one row (column). XThe new row (column) is empty. X.\" ---------- X.TP X.B "ar, ac" XAppend a new row (column) immediately following the current row (column). XIt is initialized as a copy of the current one. X.\" ---------- X.TP X.B "dr, dc" XDelete the current row (column). X.\" ---------- X.TP X.B "pr, pc, pm" XPull deleted rows (columns) back into the spreadsheet. XThe last deleted set of cells is put back into the spreadsheet Xat the current location. X.I pr Xinserts enough rows to hold the data. X.I pc Xinserts enough columns to hold the data. X.I pm X(merge) does not insert rows or columns; Xit overwrites the cells beginning at the current cell cursor location. X.\" ---------- X.TP X.B "vr, vc" XRemove expressions from the affected rows (columns), Xleaving only the values which were in the cells Xbefore the command was executed. X.\" ---------- X.TP X.B "zr, zc" XHide (``zap'') the current row (column). XThis keeps a row (column) from being displayed but keeps it in the data base. XThe status of the rows and columns is saved with the data base so hidden Xrows and columns will be still Xbe hidden when you reload the spreadsheet. Hidden rows or columns are not Xprinted by the X.I W Xcommand. X.\" ---------- X.TP X.B "sr, sc" XShow hidden rows (columns). XEnter a range of rows (columns) to be revealed. XThe default is the first range of rows (columns) currently hidden. XThis command ignores the repeat count, if any. X.\" ---------- X.TP X.B f XSet the output format to be used Xfor printing the numeric values in each cell in the current column. XEnter two numbers: Xthe total width in characters of the column, Xand the number of digits to follow decimal points. XValues are rounded off to the least significant digit displayed. XThe total column width affects displays of strings as well as numbers. XA preceding count can be used to affect more than one column. XThis command has only a column version (no second letter). X.\" ========== X.SS "Range Commands" X.\" ---------- XRange operations affect a rectangular region on the screen Xdefined by the upper left and lower right cells in the region. XAll of the commands in this class start with a slash; Xthe second letter of the command indicates which command. XA small menu lists the choices for the second letter when you type ``/''. X.I pname Xprompts for needed parameters for each command. XPhrases surrounded by square brackets in the prompt are informational only Xand may be erased with the backspace key. X.\" ---------- X.PP XPrompts requesting variable names may be satisfied Xwith either an explicit variable name, such as X.IR A10 , Xor with a variable name previously defined in a X.I /d Xcommand (see below). XRange name prompts require either an explicit range such as X.IR A10:B20 , Xor a range name previously defined with a X.I /d Xcommand. XA default range shown in the second line Xis used if you omit the range from the command or press the X.SM TAB Xkey (see below). XThe default range can be changed by moving the cell cursor Xvia the control commands X.RI ( ^P , X.IR ^N , X.IR ^B , X.IR ^F ) Xor the arrow keys. XThe cells in the default range are highlighted X(using the terminal's standout mode, if available). X.\" ---------- X.TP X.B /x XClear a range. XCells cleared with this command may be recalled with any of the X.I pull Xcommands. X.\" ---------- X.TP X.B /v XValues only. XThis command removes the expressions from a range of cells, Xleaving just the values of the expressions. X.\" ---------- X.TP X.B /c XCopy a source range to a destination range. XThe source and destination may be different sizes. XThe result is always one or more full copies of the source. XCopying a row to a row yields a row. XCopying a column to a column yields a column. XCopying a range to anything yields a range. XCopying a row to a column or a column to a row yields a range Xwith as many copies of the source as there are cells in the destination. XThis command can be used to duplicate a cell through an arbitrary range Xby making the source a single cell range such as X.IR b20:b20 . X.\" ---------- X.TP X.B /f XFill a range with constant values Xstarting with a given value and increasing by a given increment. XEach row is filled before moving on to the next row if row order Xrecalculation is set. Column order fills each column in the range Xbefore moving on to the next column. XThe start and increment numbers may be positive or negative. XTo fill all cells with the same value, give an increment of zero. X.\" ---------- X.TP X.B /d XUse this command to assign a symbolic name to a single cell Xor a rectangular range of cells on the screen. XThe parameters are the name, surrounded by "", Xand either a single cell name such as X.I A10 Xor a range such as X.IR a1:b20 . XNames defined in this fashion are used by the program in future prompts, Xmay be entered in response to prompts requesting a cell or range name, Xand are saved when the spreadsheet is saved with the X.I Put Xcommand. XNames defined must be more than two alpha characters long Xto differentiate them from a column names, Xand must not have embedded special characters. XNames may include the character ``_'' or numerals Xas long as they occur after the first three alpha characters. X.\" ---------- X.TP X.B /s XThis command lists (shows) the currently defined range names. XIf there are no defined range names, then a message is given, Xotherwise Xit pipes output to X.IR sort , Xthen to X.IR less . XIf the environment variable PAGER is set, its value is used in place of X.IR less. X.\" ---------- X.TP X.B /u XUse this command to undefine a previously defined range name. X.\" ========== X.SS "Miscellaneous Commands" X.\" ---------- X\0 \" exactly one blank line (hard to get) X.PD 0 X.TP X.B Q X.TP X.B q X.TP X.B ^C XExit from X.IR pname . XIf you made any changes since the last X.I Get Xor X.IR Put , X.I pname Xasks about saving your data before exiting. X.PD X.\" ---------- X.TP X.B ^G X.PD 0 X.TP X.B ESC XAbort entry of the current command. X.PD X.\" ---------- X.TP X.B ? XEnter an interactive help facility. Lets you look up brief Xsummaries of the main features of the program. The help facility is Xstructured like this manual page so it is easy to find more Xinformation on a particular topic. X.\" ---------- X.TP X.B ! XShell escape. X.I pname Xprompts for a shell command to run. XEnd the command line with the X.SM RETURN Xkey. XIf the environment variable X.SM SHELL Xis defined, that shell is run. XIf not, /bin/sh is used. XGiving a null command line starts the shell in interactive mode. XA second ``!'' repeats the previous command. X.\" ---------- X.TP X.B ^L XRedraw the screen. X.\" ---------- X.TP X.B ^R XRedraw the screen with special highlighting of cells to be filled in. XThis is useful for finding values you need to provide or update Xin a form with which you aren't familiar Xor of which you have forgotten the details. X XIt's also useful for checking a form you are creating. XAll cells which contain constant numeric values X(not the result of a numeric expression) Xare highlighted temporarily, Xuntil the next screen change, however minor. XTo avoid ambiguity, Xthe current range (if any) and current cell are not highlighted. X.\" ---------- X.TP X.B ^X XThis command is similar to X.IR ^R , Xbut highlights cells which have expressions. XIt also displays the expressions in the highlighted cells Xas left-flushed strings, Xinstead of the numeric values and/or label strings of those cells. XThis command makes it easier to check expressions, Xat least when they fit in their cells or the following cell(s) are blank Xso the expressions can slop over (like label strings). XIn the latter case, the slop over is not cleared on the next screen update, Xso you may want to type X.I ^L Xafter the X.I ^X Xin order to clean up the screen. X.\" ---------- X.TP X.B @ XRecalculates the spreadsheet. X.\" ---------- X.TP X.B ^V XType, in the command line, the name of the current cell X(the one at the cell cursor). XThis is useful when entering expressions Xwhich refer to other cells in the table. X.\" ---------- X.TP X.B ^W XType, in the command line, the expression attached to the current cell. XIf there is none, the result is ``?''. X.\" ---------- X.TP X.B ^A XType, in the command line, the numeric value of the current cell, if any. X.\" ---------- X.PP XThe X.IR ^V , X.IR ^W , Xand X.I ^A Xcommands only work when the character cursor Xis on the command line and beyond the first character. X.\" ---------- X.TP X.B TAB XWhen the character cursor is on the top line, Xdefines a range of cells via the cursor control commands or the arrow keys. XThe range is highlighted, Xstarts at the cell where you typed X.SM TAB, Xand continues through the current cell cursor. XPressing X.SM TAB Xagain causes the highlighted range to be entered into the command line Xand the highlighting to be turned off. XThis is most useful for defining ranges to functions such as X.IR @sum (). XPressing ``)'' acts just like typing the X.SM TAB Xkey the second time and adds the closing ``)''. XNote that when you give a range command, Xyou don't need to press the first X.SM TAB Xto begin defining a range starting with the current cell. X.\" ========== X.SS "Variable Names" X.\" ---------- XNormally, a variable name is just the name of a cell, such as X.IR K20 . XThe value is the numeric or string value of the cell, Xaccording to context. X.\" ---------- X.PP XWhen a cell's expression (formula) is copied to another location via X.I copy Xor X.IR range-copy , Xvariable references are by default offset by the amount the formula moved. XThis allows the new formula to work on new data. XIf cell references are not to change, Xyou can either use the X.I fixed Xoperator (see below), Xor one of the following variations on the cell name. X.\" ---------- X.TP X.I K20 XReferences cell X.IR K20 ; Xthe reference changes when the formula is copied. X.\" ---------- X.TP X.BI $ K $ 20 XAlways refers to cell X.IR K20 ; Xthe reference stays fixed when the formula is copied. X.\" ---------- X.TP X.BI $ K20 XKeeps the column fixed at column K; Xthe row is free to vary. X.\" ---------- X.TP X.IB K $ 20 XSimilarly, this fixes the row and allows the column to vary. X.\" ---------- X.PP XThese conventions also hold on defined ranges. XRange references vary when formulas containing them are copied. XIf the range is defined with fixed variable references, Xthe references do not change. X.\" ---------- X.TP X.B fixed XTo make a variable not change automatically when a cell moves, Xput the word X.I fixed Xin front of the reference, for example: XB1 \(** fixed C3. X.\" ========== X.SS "Numeric Expressions" X.\" ---------- XNumeric expressions used with the ``='' Xand X.I e Xcommands have a fairly conventional syntax. XTerms may be Xconstants, Xvariable names, Xparenthesized expressions, Xand negated terms. XRanges may be operated upon with range functions such as sum X.RI ( @sum ()) Xand average X.RI ( @avg ()). XTerms may be combined using binary operators. X.\" ---------- X.TP X.BR \- e XNegation. X.\" ---------- X.TP X.RB e + e XAddition. X.\" ---------- X.TP X.RB e \- e XSubtraction. X.\" ---------- X.TP X.RB e \(** e XMultiplication. X.\" ---------- X.TP X.RB e / e XDivision. X.\" ---------- X.TP X.RB e1 % e2 Xe1 mod e2. X.\" ---------- X.TP X.RB e ^ e XExponentiation. X.\" ---------- X.TP X.RB e < e X.PD 0 X.TP X.RB e <= e X.TP X.RB e = e X.TP X.RB e != e X.TP X.RB e >= e X.TP X.RB e > e XRelationals: Xtrue (1) if and only if the indicated relation holds, Xelse false (0). XNote that ``<='', ``!='', and ``>='' Xare converted to their ``~()'' equivalents. X.PD X.\" ---------- X.TP X.BR ~ e XBoolean operator X.SM NOT. X.\" ---------- X.TP X.RB e & e XBoolean operator X.SM AND. X.\" ---------- X.TP X.RB e | e XBoolean operator X.SM OR. X.\" ---------- X.TP X.RB @if (e, e, e) X.PD 0 X.TP X.RB e ? e : e XConditional: XIf the first expression is true then the value of the second is returned, Xotherwise the value of the third. X.\" ---------- X.PP XOperator precedence from highest to lowest is: X.PP X.nf X.RS X\-, ~ X^ X\(**, / X+, \- X<, <=, =, !=, >=, > X& X| X?: X.RE X.fi X.\" ========== X.SS "Built-in Range Functions" X.\" ---------- XThese functions return numeric values. X.\" ---------- X.TP 18 X.BR @sum (r) XSum all valid (nonblank) entries in the region Xwhose two corners are defined by the two variable names (e.g. X.IR c5:e14 ) Xor the range name specified. X.\" ---------- X.TP 18 X.BR @prod (r) XMultiply together all valid (nonblank) entries in the specified region. X.\" ---------- X.TP 18 X.BR @avg (r) XAverage all valid (nonblank) entries in the specified region. X.\" ---------- X.TP 18 X.BR @count (r) XCount all valid (nonblank) entries in the specified region. X.\" ---------- X.TP 18 X.BR @max (r) XReturn the maximum value in the specified region. See also the multi argument Xversion of X.I @max Xbelow. X.\" ---------- X.TP 18 X.BR @min (r) XReturn the minimum value in the specified region. See also the multi argument Xversion of X.I @min Xbelow. X.\" ---------- X.TP 18 X.BR @stddev (r) XReturn the sample standard deviation of the cells in the specified region. X.\" ---------- X.TP 18 X.BR @lookup (e,r) X.PD 0 X.TP 18 X.BR @lookup (se,r) X.PD XEvaluates the expression then searches through the range X.I r Xfor a matching value. XThe range should be either a single row or a single column. XThe expression can be either a string Xexpression or a numeric expression. If it is a numeric expression, Xthe range is searched for the the last value less than or equal to X.IR e . XIf the expression is a string expression, the string portions Xof the cells in the range are searched for an exact string match. XThe value returned is the numeric value from the next row and the same Xcolumn as the match, if the range was a single row, or the value from Xthe next column and the same row as the match if the range was a single Xcolumn. X.\" ---------- X.TP 18 X.BR @hlookup (e,r,n) X.PD 0 X.TP 18 X.BR @hlookup (se,r,n) X.PD XEvaluates the expression then searches through the first row in the range X.I r Xfor a matching value. XThe expression can be either a string Xexpression or a numeric expression. If it is a numeric expression, Xthe row is searched for the the last value less than or equal to X.IR e . XIf the expression is a string expression, the string portions Xof the cells in the row are searched for an exact string match. XThe value returned is the numeric value from the same column X.I n Xrows below the match. X.\" ---------- X.TP 18 X.BR @vlookup (e,r,n) X.PD 0 X.TP 18 X.BR @vlookup (se,r,n) X.PD XEvaluates the expression then searches through the first column in the range X.I r Xfor a matching value. XThe expression can be either a string Xexpression or a numeric expression. If it is a numeric expression, Xthe column is searched for the the last value less than or equal to X.IR e . XIf the expression is a string expression, the string portions Xof the cells in the column are searched for an exact string match. XThe value returned is the numeric value from the same row X.I n Xcolumns to the right of the match. X.\" ---------- X.TP 18 X.BR @index (e,r) XUse the value of the expression X.I e Xto index into Xthe range X.IR r . XThe numeric value at that position is returned. XThe value 1 selects the first item in the range, X2 selects the second item, etc. X.I R Xshould be either a single row or a single Xcolumn. X.\" ---------- X.TP 18 X.BR @stindex (e,r) XUse the value of X.I e Xto index into Xthe range X.IR r . XThe string value at that position is returned. XThe value 1 selects the first item in the range, X2 selects the second item, etc. XThe range should be either a single row or a single Xcolumn. X.\" ========== X.SS "Built-in Numeric Functions" X.\" ---------- XAll of these functions operate on floating point numbers (doubles) Xand return numeric values. XMost of them are standard system functions more fully described in X.IR math (3). XThe trig functions operate with angles in radians. X.\" ---------- X.TP 18 X.BR @sqrt (e) XReturn the square root of X.IR e . X.\" ---------- X.TP 18 X.BR @exp (e) XReturn the exponential function of X.IR e . X.\" ---------- X.TP 18 X.BR @ln (e) XReturn the natural logarithm of X.IR e . X.\" ---------- X.TP 18 X.BR @log (e) XReturn the base 10 logarithm of X.IR e . X.\" ---------- X.TP 18 X.BR @floor (e) XReturn the largest integer not greater than X.IR e . X.\" ---------- X.TP 18 X.BR @ceil (e) XReturn the smallest integer not less than X.IR e . X.\" ---------- X.TP 18 X.BR @rnd (e) XRound X.I e Xto the nearest integer. X.TP 18 X.BR @round (e,n) XRound X.I e Xto X.I n Xdecimal places. X.\" ---------- X.TP 18 X.BR @abs (e) X.PD 0 X.TP 18 X.BR @fabs (e) XReturn the absolute value of X.IR e . X.\" ---------- X.TP 18 X.BR @pow (e1,e2) XReturn X.I e1 Xraised to the power of X.IR e2 . X.\" ---------- X.TP 18 X.BR @hypot (e1,e2) XReturn sqrt(e1\(**e1+e2\(**e2), taking precautions against unwarranted Xoverflows. X.\" ---------- X.TP 18 X.B pi XA constant quite close to pi. X.\" ---------- X.TP 18 X.BR @dtr (e) XConvert X.I e Xin degrees to radians. X.\" ---------- X.TP 18 X.BR @rtd (e) XConvert X.I e Xin radians to degrees. X.\" ---------- X.TP 18 X.BR @sin (e) X.PD 0 X.TP 18 X.BR @cos (e) X.TP 18 X.BR @tan (e) XReturn trigonometric functions of radian arguments. XThe magnitude of the arguments are not checked to assure meaningful results. X.PD X.\" ---------- X.TP 18 X.BR @asin (e) XReturn the arc sine of X.I e Xin the range -pi/2 to pi/2. X.\" ---------- X.TP 18 X.BR @acos (e) XReturn the arc cosine of X.I e Xin the range 0 to pi. X.\" ---------- X.TP 18 X.BR @atan (e) XReturn the arc tangent of X.I e Xin the range -pi/2 to pi/2. X.\" ---------- X.TP 18 X.BR @atan2 (e1,e2) XReturns the arc tangent of X.IR e1 / e2 Xin the range -pi to pi. X.\" ---------- X.TP 18 X.BR @max (e1,e2,...) XReturn the maximum of the values of the expressions. Two or more expressions Xmay be specified. See also the range version of X.I @max Xabove. X.\" ---------- X.TP 18 X.BR @min (e1,e2,...) XReturn the minimum of the values of the expressions. Two or more expressions Xmay be specified. See also the range version of X.I @min Xabove. X.\" ---------- X.TP 18 X.BR @ston (se) XConvert string expression X.I se Xto a numeric value. X.\" ---------- X.TP 18 X.BR @eqs (se1,se2) XReturn 1 if string expression X.I se1 Xhas the same value as string expression X.IR se2 , X0 otherwise. X.\" ---------- X.TP 18 X.BR @nval (se,e) XReturn the numeric value of a cell selected by name. XString expression X.I se Xmust evaluate to a column name (``A''-``AE'') and X.I e Xmust evaluate to a row number (0-199). XIf X.I se Xor X.I e Xis out of bounds, or the cell has no numeric value, the result is 0. XYou can use this for simple table lookups. XBe sure the table doesn't move unexpectedly! XSee also X.IR @sval () Xbelow. X.\" ========== X.SS "String Expressions" X.\" ---------- XString expressions are made up of constant strings X(characters surrounded by double quotation marks), Xvariables X(cell names, which refer to the cells's label strings or expressions), Xand string functions. XNote that string expressions are only allowed Xwhen entering a cell's label string, not its numeric part. XAlso note that string expression results may be left or right flushed, Xaccording to the type of the cell's string label. X.\" ---------- X.TP X.B # XConcatenate strings. XFor example, the string expression X.IP "" X A0 # "zy dog" X.IP "" Xdisplays the string ``the lazy dog'' in the cell if the value of X.IR A0 's Xstring is ``the la''. X.\" ========== X.SS "Built-in String Functions" X.\" ---------- X\0 \" exactly one blank line (hard to get) X.PD 0 X.TP 18 X.BR @substr (se,e1,e2) XExtract and return from string expression X.I se Xthe substring indexed by character number X.I e1 Xthrough character number X.I e2 X(defaults to the size of X.I se Xif beyond the end of it). XIf X.I e1 Xis less than 1 or greater than X.IR e2 , Xthe result is the null string. XFor example, X.PD X.IP "" X @substr ("Nice jacket", 4, 7) X.IP "" Xreturns the string ``e jac''. X.\" ---------- X.TP 18 X.BR @fmt (se,e) XConvert a number to a string. XThe argument X.I se Xmust be a valid X.IR printf (3) Xformat string. X.I e Xis converted according to the standard rules. XFor example, the expression X.IP "" X @fmt ("\(**\(**%6.3f\(**\(**", 10.5) X.IP "" Xyields the string ``\(**\(**10.500\(**\(**''. X.I e Xis a double, so applicable formats are e, E, f, g, and G. XTry ``%g'' as a starting point. X.\" ---------- X.TP 18 X.BR @sval (se,e) XReturn the string value of a cell selected by name. XString expression X.I se Xmust evaluate to a column name (``A''-``AE'') and X.I e Xmust evaluate to a row number (0-199). XIf X.I se Xor X.I e Xis out of bounds, or the cell has no string value, Xthe result is the null string. XYou can use this for simple table lookups. XBe sure the table doesn't move unexpectedly! X.\" ---------- X.TP 18 X.BR @ext (se,e) XCall an external function (program or script). XThe purpose is to allow arbitrary functions on values, Xe.g. table lookups and interpolations. XString expression X.I se Xis a command or command line to call with X.IR popen (3). XThe value of X.I e Xis converted to a string and appended to the command line as an argument. XThe result of X.IR @ext () Xis a string: Xthe first line printed to standard output by the command. XThe command should emit exactly one output line. XAdditional output, or output to standard error, messes up the screen. X.IR @ext () Xreturns a null string and prints an appropriate warning Xif external functions are disabled, X.I se Xis null, or the attempt to run the command fails. X.IP "" XExternal functions can be slow to run, Xand if enabled are called at each screen update, Xso they are disabled by default. XYou can enable them with X.I ^T Xwhen you really want them called. X.IP "" XA simple example: X.IP "" X @ext ("echo", a1) X.IP "" XYou can use X.IR @ston () Xto convert the X.IR @ext () Xresult back to a number. XFor example: X.IP "" X @ston (@ext ("form.sc.ext", a9 + b9)) X.IP "" XNote that you can built a command line (including more argument values) Xfrom a string expression with concatenation. XYou can also "hide" the second argument by ending the command line X(first argument) with `` #'' (shell comment). X.\" ========== X.SS "Built-in Financial Functions" X.\" ---------- XFinancial functions compute the mortgage (or loan) payment, future value, Xand the present value functions. Each accepts Xthree arguments, an amount, a rate of interest (per period), and Xthe number of periods. XThese functions are the same as those commonly found in other spreadsheets Xand financial calculators X.\" ---------- X.TP 18 X.BR @pmt (e1,e2,e3) X.IR @pmt (60000,.01,360) Xcomputes the monthly payments for a $60000 mortgage at 12% annual interest X(.01 per month) for 30 years (360 months). X.\" ---------- X.TP 18 X.BR @fv (e1,e2,e3) X.IR @fv (100,.005,36) Xcomputes the future value for of 36 monthly payments of $100 at 6% Xinterest (.005 per month). It answers the question: "How much Xwill I have in 36 months if I deposit $100 per month in a savings Xaccount paying 6% interest compounded monthly?" X.\" ---------- X.TP 18 X.BR @pv (e1,e2,e3) X.IR @pv (1000,.015,36) Xcomputes the present value of an a ordinary annuity of X36 monthly payments of $1000 at 18% annual interest. XIt answers the question: "How much can I borrow at 18% for 30 years Xif I pay $1000 per month?" X.\" ========== X.SS "Built-in Date and Time Functions" X.\" ---------- XTime for X.I pname Xfollows the system standard: Xthe number of seconds since 1970. XAll date and time functions except X.IR @date () Xreturn numbers, not strings. X.\" ---------- X.TP 18 X.B @now XReturn the current time encoded Xas the number of seconds since the beginning of the Xepoch (December 31, 1969, midnight, GMT.) X.\" ---------- X.TP 18 X.BR @dts (e1,e2,e3) X.IR @dts (9,14,1988) Xconverts the date September 14, 1988 Xto the number of seconds from the epoch Xto the first second of 9/14/88, local time. XFor example, X.IR @date ( @dts (12,14,1976)) Xyields X.IP "" X.I " Tue Dec 14 00:00:00 1976" X.IP "" XThe month should be range from 1 to 12, the day should range from X1 to the number of days in the specified month, and the year should Xrange from 1970 to 1999. X.\" ---------- X.TP 18 X.BR @tts (e1,e2,e3) X.IR @tts (8,20,45) Xconverts the time 8:40:45 to the number of seconds since Xmidnight, the night before. The hour should range from 0 to 23; Xthe minutes and seconds should range from 0 to 59. X.\" ---------- X.PP XThe following functions take the time in seconds X(e.g. from X.IR @now ) Xas an argument and return the specified value. XThe functions all convert from GMT to local time. X.\" ---------- X.TP 18 X.BR @date (e) XConvert the time in seconds to a date string X24 characters long in the following form: X.IP "" X.I " Sun Sep 16 01:03:52 1973" X.IP "" XNote that you can extract parts of this fixed-format string with X.IR @substr (). X.\" ---------- X.TP 18 X.BR @year (e) XReturn the year. XValid years begin with 1970. XThe last legal year is system dependent. X.\" ---------- X.TP 18 X.BR @month (e) XReturn the month, encoded as 1 (January) to 12 (December). X.\" ---------- X.TP 18 X.BR @day (e) XReturn the day of the month, encoded as 1 to 31. X.\" ---------- X.TP 18 X.BR @hour (e) XReturn the number of hours since midnight, encoded as 0 to 23. X.\" ---------- X.TP 18 X.BR @minute (e) XReturn the number of minutes since the last full hour, encoded as 0 to 59. X.\" ---------- X.TP 18 X.BR @second (e) XReturn the number of seconds since the last full minute, encoded as 0 to 59. X.\" ========== X.SS "Spreadsheet Update" X.\" ---------- XRe-evaluation of spreadsheet expressions Xis done by row or by column depending on the selected calculation order. XEvaluation is repeated up to X.I iterations Xtimes for each update if necessary, Xso forward references usually work as expected. See X.I set Xabove. XIf stability is not reached after ten iterations, Xa warning is printed. XThis is usually due to a long series of forward references, Xor to unstable cyclic references (for example, set X.IR A0 's Xexpression to ``A0+1''). X.\" ========== X.SH SEE ALSO Xbc(1), dc(1), crypt(1), ppname(1) X.\" ========== X.SH BUGS XTop-to-bottom, left-to-right evaluation of expressions is silly. XA proper following of the dependency graph Xwith (perhaps) recourse to relaxation should be implemented. X.\" ---------- X.PP XEditing is crude. XAll you can do is backspace over and retype text to be altered. XThere is no easy way to switch a leftstring to a rightstring or vice versa. XOf course, you can always write the spreadsheet to a file with X.IR Put , Xedit it by calling an editor on the file with ``!'', Xand read it back with X.I Get X-- if you are comfortable editing spreadsheet files. X.\" ---------- X.PP XOnly one previous value is saved from any call of X.IR @ext (). XIf it is used more than once in a spreadsheet Xand external functions are enabled and later disabled, Xthe last returned value pops up in several places. X.\" ---------- X.PP XOn some systems, Xif the cell cursor is in column 0 with topline enabled X(so the current cell is highlighted), Xor if any cell in column 0 is highlighted, Xthe corresponding row number gets displayed and then blanked Xduring a screen refresh. XThis looks like a bug in X.IR curses . X.\" ---------- X.PP XMany commands give no indication (a message or beep) if they have null effect. XSome should give confirmation of their action, but they don't. END_OF_FILE if test 45229 -ne `wc -c <'sc.doc'`; then echo shar: \"'sc.doc'\" unpacked with wrong size! fi # end of 'sc.doc' fi echo shar: End of archive 1 \(of 6\). cp /dev/null ark1isdone MISSING="" for I in 1 2 3 4 5 6 ; do if test ! -f ark${I}isdone ; then MISSING="${MISSING} ${I}" fi done if test "${MISSING}" = "" ; then echo You have unpacked all 6 archives. rm -f ark[1-9]isdone else echo You still must unpack the following archives: echo " " ${MISSING} fi exit 0 exit 0 # Just in case... -- Please send comp.sources.unix-related mail to rsalz@uunet.uu.net. Use a domain-based address or give alternate paths, or you may lose out.