5.3 The data area

Begins with an form feed character (whose ASCII code is 014 in octal notation), followed by sets of cell-definition macros for each row, followed by the set of local printer definitions, followed by column-widths, column-printers, default-printer, and header-row. Then there’s the global parameters (file-format ID, row count, column count, local printer count) and the local variables (specifying SES mode for the buffer, etc.).

When a SES file is loaded, first the global parameters are loaded, then the entire data area is evaled, and finally the local variables are processed.

You can edit the data area, but don’t insert or delete any newlines except in the local-variables part, since SES locates things by counting newlines. Use C-x C-e at the end of a line to install your edits into the spreadsheet data structures (this does not update the print area, use, e.g., C-c C-l for that).

The data area is maintained as an image of spreadsheet data structures as stored in buffer-local variables from initially loading the area. If the data area gets messed up in the sequel, you can try reconstructing the data area from the data structures:

C-c M-C-l

(ses-reconstruct-all).