Printer functions convert binary cell values into the print forms that Emacs will display on the screen.
A printer can be a format string, like ‘"$%.2f"’. The result string is right-aligned within the print cell. To get left-alignment, use parentheses: ‘("$%.2f")’. A printer can also be a one-argument function (a symbol or a lambda), whose result is a string (right-aligned) or list of one string (left-aligned). While typing in a lambda, you can use M-TAB to complete the names of symbols.
Each cell has a printer. If
nil, the column-printer for the cell’s
column is used. If that is also
nil, the default-printer for the
spreadsheet is used.
Enter a printer for current cell or range (
Enter a printer for the current column (
Enter the default printer for the spreadsheet
ses-read-XXX-printer commands have their own minibuffer
history, which is preloaded with the set of all printers used in this
spreadsheet, plus the standard printers.
The standard printers are suitable only for cells, not columns or
default, because they format the value using the column-printer (or
nil) and then center the result:
Centering with spill-over to following blank cells.
Centering using dashes (-) instead of spaces.
Centering with dashes and spill-over.
Centering with tildes (~) and spill-over.
You can define printer function local to a sheet with the command
ses-define-local-printer. For instance, define a printer
"%.2f", and then use symbol ‘foo’ as a
printer function. Then, if you call again
ses-define-local-printer on ‘foo’ to redefine it as
"%.3f", all the cells using printer ‘foo’ will be