SSTable Parser

Description

The SSTable parser allows you to have create spreadsheets inside Moin's code blocks by using just Python.

Download & Release Notes

Installation

For general installation instructions, see ParserMarket/InstallingParsers. This parser requires no special dependencies, such as outside Python libraries.

Usage

To use this parser, simply put #!sstable after the beginning of the code block.

Example

{{{#!sstable
,1,2,
,3,4,
,5,6,
}}}

For more detailed examples, see /Examples

Copyright

This parser is copyrighted by AndrewShewmaker

License

This parser is released under the terms of the GNU GPL.

Discussion

• The spreadsheet code needs more functions. It currently has:
  • Python built-ins
    • ceil, floor, round
    • fabs
    • fmod, modf
    • frexp, ldexp, exp
    • log, log10
    • pow, sqrt
    • acos, asin, atan, atan2
    • cos, sin, tan
    • cosh, sinh, tanh
    • hypot
    • degrees, radians
    • cmp, len
    • hex, oct
    • constants: pi, e
  • spread sheet functions that operate on ranges of cells
    • max, min
    • sum, average, median

• If a function is not already defined it should not end up with an empty cell. ||=mean(a0:a10)|| One of these would be better

  • write a list of defined functions with similiar names or a link to the wiki page
  • write the formular call and a hint e.g. typemismatch

• I have a problem here where a cell that computes something *with* a sum just gives me the sum. The formula =D1-(D2+D3) works while =D1-(@sum(D2:D3)) gives me the result of =@sum(D2:D3). This is weird. -- TheAnarcat 2006-09-07 19:43:01

• bolds in cells make text disappear. e.g.:

  • || '''Total''': || 100 ||

    becomes:

    100

    It would be nice to be able to have markup in the cells, esp. bolds. FYI, ../sctable does it right. -- TheAnarcat 2006-09-11 16:46:25

Patch for moin 1.9

   1 --- sstable-1.0.4.py    2010-06-09 16:29:04.000000000 -0300
   2 +++ sstable-1.0.4.py    2010-06-09 18:26:56.000000000 -0300
   3 @@ -286,7 +286,7 @@
   4  Dependencies = []
   5  import re
   6  from math import *
   7 -from MoinMoin.parser import wiki
   8 +from MoinMoin.parser import text_moin_wiki
   9  from MoinMoin.action import AttachFile
  10  from MoinMoin.Page import Page
  11  from MoinMoin import wikiutil
  12 @@ -563,5 +563,5 @@
  13          else:
  14              result = result[1:]
  15              result = wikiutil.unquoteWikiname(result)
  16 -            wikiizer = wiki.Parser(result,self.request) # parser for wiki tabular
  17 +            wikiizer = text_moin_wiki.Parser(result,self.request) # parser for wiki tabular
  18              wikiizer.format(formatter)