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!)