# Source

## 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:.