Files
0a022b61f7 craft-sheet: built-in number formats 37 to 40 are the codes Excel reports (#2020) (#2291)
Excel 16 (en-US) reports #,##0_);(#,##0), #,##0_);[Red](#,##0),
#,##0.00_);(#,##0.00) and #,##0.00_);[Red](#,##0.00) for ids 37 to 40,
not the ECMA-376 Part 1 18.8.30 text the table held. It writes neither a
numFmt nor a FORMAT record for these ids, so the table is the only source
of their codes when a file Excel saved is read, as .xlsx or as .xls.

Co-authored-by: kiwi4boy <kiwi4boy@gmail.com>
Co-authored-by: Dylan M. Taylor <dylan@dylanmtaylor.com>
2026-11-18 23:55:20 -05:00
..

craft-sheet

What every spreadsheet file format says in the same words, kept once so that craft-xls, craft-xlsx and craft-ods hand an application the same types:

  • CellRef and Range: zero-based cell positions, and their A1 text both ways (B3, $B$3, A1:C2), inside Excel's 1,048,576 by 16,384 grid.
  • Value and CellError: what a cell stores, and the error values with their text (#DIV/0!).
  • Visibility: visible, hidden, very hidden.
  • sheet_needs_quotes, quote_sheet: a sheet name as a reference spells it ('My Sheet'!A1).
  • HAlign, VAlign, Underline, Script, BorderStyle, Pattern: the cell formatting choices BIFF8 and SpreadsheetML share.
  • builtin_format, builtin_format_id: the number format codes behind the built-in ids (ECMA-376 Part 1, 18.8.30; [MS-XLS] 2.4.126).
  • DEFAULT_PALETTE: the 64 indexed colours ([MS-XLS] 2.4.188; ECMA-376 Part 1, 18.8.27).

It is not a file format and has no dependencies. It holds no document model: sheets, styles and formulas are each format's own.