API REFERENCE
formulas
Evaluates cell strings beginning with = as formulas. A1 references use original column and row order, not display sorting.
What does this API do?
Evaluates cell strings beginning with = as formulas. A1 references use original column and row order, not display sorting.
API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns
Exact input and result types
formulas: boolean| Item | Value |
|---|---|
| JavaScript name | formulas |
| HTML attribute | formulas |
| Default | false |
| Input type | boolean |
Usage flow
Set this on a property of the Grid element. In HTML, you can also use the formulas attribute. Pass arrays, objects, and callbacks through JavaScript, and use new arrays or objects when applying changes.
Feature explanations and examples
- Formula calculation
Formulas evaluate strings beginning with = and display the result in a cell. For example, =SUM(A1:A3) references the first column in the original column definitions and the first three source rows.