API REFERENCE
formulaBar
Shows a formula bar for inspecting and editing the active cell's source value or formula. Enter commits; Escape cancels.
What does this API do?
Shows a formula bar for inspecting and editing the active cell's source value or formula. Enter commits; Escape cancels.
API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns
Exact input and result types
formulaBar: boolean| Item | Value |
|---|---|
| JavaScript name | formulaBar |
| HTML attribute | formula-bar |
| Default | false |
| Input type | boolean |
Usage flow
Set this on a property of the Grid element. In HTML, you can also use the formula-bar 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.