This is the official manual for the latest Org-mode release.
You can edit individual formulas in the minibuffer or directly in the field.
Org can also prepare a special buffer with all active formulas of a table.
When offering a formula for editing, Org converts references to the standard
D&) if possible. If you prefer to only work
with the internal format (like
$4), configure the
B3) and internal (like
B3and you press S-<right>, it will become
C3. This also works for relative references and for hline references.
Making a table field blank does not remove the formula associated with the field, because that is stored in a different line (the ‘#+TBLFM’ line)—during the next recalculation the field will be filled again. To remove a formula from a field, you have to give an empty reply when prompted for the formula, or to edit the ‘#+TBLFM’ line.
You may edit the ‘#+TBLFM’ directly and re-apply the changed equations with C-c C-c in that line or with the normal recalculation commands in the table.
You may apply the formula temporarily. This is useful when you switch the formula. Place multiple ‘#+TBLFM’ lines right after the table, and then press C-c C-c on the formula to apply. Here is an example:
| x | y | |---+---| | 1 | | | 2 | | #+TBLFM: $2=$1*1 #+TBLFM: $2=$1*2
Pressing C-c C-c in the line of ‘#+TBLFM: $2=$1*2’ yields:
| x | y | |---+---| | 1 | 2 | | 2 | 4 | #+TBLFM: $2=$1*1 #+TBLFM: $2=$1*2
Note: If you recalculate this table (with C-u C-c *, for example), you will get the following result of applying only the first ‘#+TBLFM’ line.
| x | y | |---+---| | 1 | 1 | | 2 | 2 | #+TBLFM: $2=$1*1 #+TBLFM: $2=$1*2
When the evaluation of a formula leads to an error, the field content
becomes the string ‘#ERROR’. If you would like see what is going
on during variable substitution and calculation in order to find a bug,
turn on formula debugging in the
Tbl menu and repeat the
calculation, for example by pressing C-u C-u C-c = <RET> in a
field. Detailed information will be displayed.