sctable

PURPOSE

This parser is used to do some spread sheet calculation based on sc in a regular wiki table. The first column/first line coordinate is A0.

CALLING SEQUENCE

{ { {
#!sctable [-column_header -row_header -show_formular -format ]
} } }

INPUTS

-column_header : additional in the result the column header is shown
-row_header : additional in the result the line number header is shown
-show_formular : if set the formular instead of the result is shown, data is arranged in textmode. Blanks in formulars are removed
-format : is used to set the number of digits of a real number for each column (separator is a comma), e.g. -format 1,2 means first column has one digit and second has two digits.

RESTRICTIONS

MODIFICATION

 @copyright: 2004-09-19 by Reimar Bauer (R.Bauer@fz-juelich.de) sctable.py

1.2.3-2    : 2004-09-19 (RB) bug fixed: line #!sctable was not found by giving input parameters
1.2.3-3    : (RB) input parameter -show_formular added, column width is set to 200 chars
           : if this parameter is used
           : (RB) bug removed (already) #!sctable position could be different from 0
           :  but always greater -1
1.2.3-4    : 2004-10-05 (RB) format always extended for sc call to 200 signs.
                 bug with blanks in names removed, more as one blank in a cell handled as one blank.
1.2.3-5    : 2004-10-16 RB format codes for colors and cells removed before calculations
                -format optional input var added

1.3        : 2004-11-13 RB changed to PARSER
                 bug fixed: strings with blanks are formatted to the left
                 feature added: column width of row numbers is set to 5%
                 some examples fixed
  
          : 2005-02-06 RB description of input parameter format added 

1.3.3-2 patch and examples from towi AT geocities DOT SPAM com implemented

        FUNCTIONAL ADDITIONS

        * a cell can now start with an wiki format string that will format
          the cell according to wiki table formatting,
          examples:
          <:>@sum(A3:a6)
          <rowbgcolor=cyan>Title

       * you can define a name for a cell and use it later (no range defines yet):
         when combinign with <format> the format must come first.
         examples:
         {income}20000
         <:>{outcome}=income/2

1.3.5-3: 2005-08-05 RB tmp path set relative to installation and created if it isn't there
                    space before and after a cell entry by now ignored

1.3.5-4:  I had problems running this on FreeBSD. I had to install manually the source because the ports
          in FreeBSD seem to be out of date (using version 6.x of sc). 
          Furthermore, i had to comment out the f.flush() call that was causing an I/O error 
          for some reason. -- TheAnarcat 2005-12-18 23:34:15     
1.5.2-5: 2006-03-11 RB code revised (tabs removed!)