This is an old revision of the document!
Empty cells are equivalent to Not-a-Number values.
Many table editing functions are available in table context menu.
Columns are enumerated starting with 1. The first 26 columns are additionally denoted with Latin letters:
A, B, C, … Y, Z, 27, 28, 29, …. You can use either numbers or letters, addressing cells and columns. Moreover, you can use letters in algebraical expressions:
example column formula.
Ctrl key (on Windows and Linux only) or
Alt key (on Mac OS X) and drag column header to rearrange table columns.
Alt keys are not pressed, mouse dragging on header will select the columns.
You can edit table cell by double click on it. You can either enter a number or an expression (e.g. writing
pi in cell equals to
1+2 equals to
See Formula section for expression syntax.