API reference / Common / Engine types / GridFormula

Interface: GridFormula

A formula as the model stores it (ST_Formula, §18.18.35): the text it was written with and, once bound, what its references named. An edit makes a new one; binding only fills in what the text already names.

Properties

Property	Description
text string	The original text, without its =, as loaded or typed, its functions without a file's prefix: SUM(Sheet2!A1:A3), CONCAT(A1).
grammar FormulaGrammar	The grammar it was parsed by.
cellRefMode FormulaCellRefMode	The mode it was written in: A1 from a file, the workbook's for a typed one.
bindings GridFormulaBinding[] | null	What each sheet name, column and row of this workbook the text writes named, in the order its references are met; None until bound.