Class CellFormulaOptions

The defaults of CellFormulaOptionsIf (cell formulas).

Example

CellFormulaOptions.create(true)?.maxRangeCells;   // 10000000

Since

1.1.99

Hierarchy

  • CellFormulaOptions

Implements

Constructors

constructor

Properties

columns? functions isoDatesAsDates maxRangeCells rejectInvalidFormulas

Methods

create

Constructors

constructor

Properties

Optional columns

columns?: string[] = undefined

Only these properties hold formulas (the other columns keep =… as text). Default: every data column.

functions

functions: Record<string, FormulaFunction> = {}

Own functions by name (case-insensitive); they may replace built-in ones. A range argument (A1:B5) arrives as FormulaRange, a date as its serial number.

isoDatesAsDates

isoDatesAsDates: boolean = true

ISO text ("2026-10-16") counts as date in arithmetic (=A2+1) and date functions. Default true.

maxRangeCells

maxRangeCells: number = 10_000_000

Larger ranges are #ERROR! (A1:XFD1048576). Default 10_000_000.

rejectInvalidFormulas

rejectInvalidFormulas: boolean = false

The table refuses formulas with a syntax error instead of storing them (#ERROR!). Default false.

Methods

Static create

Settings

Member Visibility

Theme

On This Page