      K      LOCAL                                                       XSPREAD(1)       	      NAME )           xspread - X Windows spreadsheet         COMMAND LINE K           xspread [-h] [-c] [-m] [-n] [-r] [-x] [-fn font] [ _f_i_l_e ]         SUMMARY DESCRIPTIONK               The program xspread is a public domain spreadsheet which runs I           under X Windows.  You must be using an X Windows terminal to be I           able to run this program.  We are working on makeing it use the =           ascii screen if it cannot find an X display to use.   G           Xspread Reference Manual gives complete documentation for the H           program.  The LaTeX source copy for this manual is in the file           xspread.tex.  B               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.6               * Absolute and relative cell references.@               * Numeric and label (i.e.character string) data in                 cells.7               * Left or right justification for labels. 6               * Row and column insertion and deletion.8               * Hiding and unhiding of rows and columns.               * Range names.2               * Manual or automatic recalculation.A               * Numeric operators (+, -, *, /, ^(exponentiation),                   %(remaindering))E               * Relational operators (<, <=, >, >=, =, !=(not equal)) ?               * Logical (or, Boolean) operators (&(and), |(or),                  ~(not)) $               * Function references.@               * Graphs (XY, Bar, Stack Bar, Pie and Line graphs)E               * Matrix Operations (Transpose, Multiply, Add, Subtract                  and Inversion)-               * Cursor positioning with mouse .               * Menu item selection with mouseB               * References to external programs.  These are called#                 external functions.   K               The structure and operation of the spreadsheet is similar  to K           but  not  identical with popular spreadsheets such as Lotus 1-2-3 K           and its  clones.   Like  other  spreadsheets,  the  workspace  is K           arranged  into rows and columns of cells. Each cell can contain a K           number, a label (i.e.  character  string),  or  a  formula  which )           evaluates to a number or label.   K               You can start the program with or without specifying  a  file K           to be read in. This file must be a saved worksheet.  If a file is     K                                                                           1             K      XSPREAD(1)                                                       LOCAL     K           specified on the command line, xspread  attempts  to  locate  and K           read  in  the file.  If it is successful, xspread starts with the K           file's contents in the workspace.  If it is  unsuccessful  or  no K           file  is  specified  on the command line, xspread starts with the            workspace empty.  K               For a tutorial of the spreadsheet program,  run  one  of  the K           demo files: demo, demo_math, demo_matrix, see the file Sample_Run            in the doc directory.         Options  K           -c      Recalculation is done  in  column  order.   When  xspread K                   recalculates,  it  will  start at the top of the leftmost K                   column, and recalculate the all the  cells  from  top  to K                   bottom.  Then, it will recalculate the next column in the K                   same order.  It will continue in this  fashion  until  it K                   has  recalculated the rightmost column.  Xspread does NOT 6                   support natural order recalculation.  4                   Default:  Row order recalculation.  ,           -h      Display command line help.  K           -m      Start with manual recalculation.  With this  option,  the K                   spreadsheet  will  recalculate  values  only when the "@" K                   command  is  used.   With  automatic  recalculation,  the K                   spreadsheet recalculates values whenever a cells contents                    change.   4                   Default:  Automatic recalculation.  K           -n      Standard Data entry mode.  In this  mode  the  user  must K                   specify if the data entry item is numeric or a label.  To K                   single Xspread that the item is a number, the first char- K                   acter  has  to  be  a "=".  To specify that the data is a C                   label, the first character has to be a quote (").   K                   * If the first character is a numeral, a "+" sign,  or  a 7                   "-" sign, the cell contains a number.   K                   * If the first character is a greater than sign (>), less K                   than  sign  (<), or double quote ("), the cell contains a                    label.  K                   * If it is anything else, the character is a  command  to                    xspread.  K                   With standard entry mode, you must use the first  charac- K                   ter  to  tell  xspread  whether the cell is a number or a                    label.  K                   * If the cell is to be a number, the first character must !                   be an "=" sign.           2            K      LOCAL                                                       XSPREAD(1)     K                   * If the cell is to be a label, the first character  must K                   be  a  double  quote  ("), less than sign (<), or greater                     than sign (>).  5                   Default:  Standard data entry mode.   K           -r      Recalculation is done in row order.  When xspread  recal- K                   culates,  it  will  start at the left of the topmost row, K                   and recalculate all the cells from left to right.   Then, K                   it  will  recalculate the next row in the same order.  It K                   will continue in this fashion until it  has  recalculated K                   the  bottommost  row.   Xspread  does NOT support natural &                   order recalculation.  4                   Default:  Row order recalculation.  @           -x      Use encryption when reading and writing files.  2                   Default:  Do not use encryption.  
      SEE ALSO +               sc(1), bc(1), dc(1), crypt(1)   	      BUGS K               Xspread saves only one value from any call to external  func- K           tions  via  @ext().   If  @ext()  is  used  more  than  once in a K           spreadsheet and external functions are enabled and then disabled, <           the last returned value pops up in several places.                                                        K                                                                           3       