API REFERENCE
undoSpillTransaction
Undoes a dynamic array formula transaction and returns the result.
What does this API do?
Undoes a dynamic array formula transaction and returns the result.
API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns
Exact input and result types
undoSpillTransaction(mutationId: GridMutationId): Promise<SyGridSpillUndoResult>| Arguments | Required | Type |
|---|---|---|
| mutationId | Required | GridMutationId |
The return type is Promise<SyGridSpillUndoResult>.
Usage flow
After registering and initializing the Grid element, call grid.undoSpillTransaction(…). 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.