API REFERENCE
clearSpillFormula
Clears a dynamic array formula's anchor cell and releases its occupied range.
What does this API do?
Clears a dynamic array formula's anchor cell and releases its occupied range.
API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns
Exact input and result types
clearSpillFormula(target: SyGridSpillTarget): Promise<SyGridSpillClearResult>| Arguments | Required | Type |
|---|---|---|
| target | Required | SyGridSpillTarget |
The return type is Promise<SyGridSpillClearResult>.
Usage flow
After registering and initializing the Grid element, call grid.clearSpillFormula(…). 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.