Grid - FormulaSettings

30 Sep 20261 minute to read

Configures the formula cell support for the Grid.
Formula cells allow users to enter formulas that dynamically calculate values based on other cells.
Example: =SUM(A1:A5), =IF(B1>100, "High", "Low"), =A1 + B2 * 2

Properties

allowBuiltInFunctions boolean

If allowBuiltInFunctions is set to true, built-in functions such as SUM, AVERAGE,
MIN, MAX, IF, AND, OR, NOT, CONCAT, LEN, TODAY, and other supported functions
can be used in formula expressions.

Defaults to true

calculationMode FormulaCalculationMode

Defines when formula values should be recalculated. The available modes are:

  • Automatic
  • Manual

Defaults to Automatic

customFunctions Record

Defines the collection of custom formula functions that can be used within
Grid formula expressions.

Defaults to {}