API REFERENCE
getSpillReport
Inspects current dynamic array formulas and their occupied ranges.
What does this API do?
Inspects current dynamic array formulas and their occupied ranges.
API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns
Exact input and result types
getSpillReport(): Promise<SyGridSpillReport>| Arguments | Required | Type |
|---|
The return type is Promise<SyGridSpillReport>.
Usage flow
After registering and initializing the Grid element, call grid.getSpillReport(…). 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.