Source

restructured-spreadsheet / doc / spreadsheet.rst

Full commit

The :rst:dir:`spreadsheet` directive

Cell equation

Cell equation has the shape like this:

{NUM} = STATEMENT

or:

{NUM:CONDITION} = STATEMENT

More precisely, the syntax of the cell equation is the following:

:token:`expression_stmt_format` is as same as :token:`expression_stmt` except for that it will be formatted by the python's str.format function and then used as a python expression. Defined fields are the integers which represent the index of the columns. For example, {0} will be replaced by the 0-th cell of the current row.

Note

Current version of rstSpreadsheet cannot parse the :token:`condition` which has { or } in it.

Special variables

rstSpreadsheet provides the following special variables. You can use these in the cell equation. Note that you can override these variables by variables in :setup:.