SSTable Parser

Description

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

Download & Release Notes

Download	Release Version	Moin Version	Release Notes
sstable-1.0.4.py	1.0.4	1.5	ParserMarket/Sstable/ReleaseNotes
sstable.py	1.0.5	1.9	Updated to work with MoinMoin 1.9 Fixed bug reported by TheAnarcat in which formulas are not properly evaluated Made non-numeric cell input be treated as 0 by formulas

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
  - I second this. -- TakeoKatsuki 2014-11-03 17:47:05

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)

MoinMoin: ParserMarket/Sstable (last edited 2014-11-03 17:47:05 by TakeoKatsuki)