Next: , Up: The Basics

3.1 Cell formulas

To insert a value into a cell, simply type a numeric expression, ‘"double-quoted text"’, or a Lisp expression.

0..9
Self-insert a digit (ses-read-cell).
-
Self-insert a negative number (ses-read-cell).
.
Self-insert a fractional number (ses-read-cell).
"
Self-insert a quoted string. The ending double-quote is inserted for you (ses-read-cell).
(
Self-insert an expression. The right-parenthesis is inserted for you (ses-read-cell). To access another cell's value, just use its identifier in your expression. Whenever the other cell is changed, this cell's formula will be reevaluated. While typing in the expression, you can use M-<TAB> to complete symbol names.
' (apostrophe)
Enter a symbol (ses-read-symbol). SES remembers all symbols that have been used as formulas, so you can type just the beginning of a symbol and use <SPC>, <TAB>, and ? to complete it.

To enter something else (e.g., a vector), begin with a digit, then erase the digit and type whatever you want.

RET
Edit the existing formula in the current cell (ses-edit-cell).
C-c C-c
Force recalculation of the current cell or range (ses-recalculate-cell).
C-c C-l
Recalculate the entire spreadsheet (ses-recalculate-all).