Variable Mode`Const`

Mode: { Display: "display"; Formula: "formula"; Value: "value" } = ...

How much formatting to apply before encoding.

Type Declaration

ReadonlyDisplay: "display"

The cell as displayed — number format applied.

Remarks
4%, 2024-01-01, $1,234.57. What a human reading the grid sees, and what a values read prints.
ReadonlyFormula: "formula"

The formula text where the cell has a formula (=SUM(B2:B9)), else its stored value.

Remarks
Excel's Show Formulas view: for reading a block's logic as a grid. The inputs read as the scalars the formulas compute with — 0.25, not 25%; a date as its serial. The text carries its leading =, as the formula bar shows it.
ReadonlyValue: "value"

The stored scalar — what getValue() returns, with no number format applied.

Remarks
1234.5678 where display shows $1,234.57, 0.04 where it shows 4%, and a date as its serial. A reader wants one of two things: what the grid shows, or what a formula computes with. There is deliberately no layer in between — the formula bar's text (4% at full precision, dates kept) is the stored scalar restyled by the format's category, and both of those are already reported.