API REFERENCE
applySpillFormula
Atomically applies a dynamic array formula under the conflict policy. Inspect conflicts, rejections, and unrendered areas in the report.
What does this API do?
Atomically applies a dynamic array formula under the conflict policy. Inspect conflicts, rejections, and unrendered areas in the report.
API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns
Exact input and result types
applySpillFormula(input: SyGridSpillApplyInput): Promise<SyGridSpillApplyResult>| Arguments | Required | Type |
|---|---|---|
| input | Required | SyGridSpillApplyInput |
The return type is Promise<SyGridSpillApplyResult>.
Usage flow
After registering and initializing the Grid element, call grid.applySpillFormula(…). Read the return value with await. For methods returning a boolean or report, inspect the result before continuing.
Read related types
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.