API REFERENCE
showFormulas
Displays formula text instead of calculated results for review in a table with formulas enabled.
What does this API do?
Displays formula text instead of calculated results for review in a table with formulas enabled.
API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns
Exact input and result types
showFormulas: boolean| Item | Value |
|---|---|
| JavaScript name | showFormulas |
| HTML attribute | show-formulas |
| Default | false |
| Input type | boolean |
Usage flow
Set this on a property of the Grid element. In HTML, you can also use the show-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.