# undoSpillTransaction

Undoes a dynamic array formula transaction and returns the result.

Canonical: https://grid.syidax.com/docs/methods/undoSpillTransaction/

<a id="meaning"></a>

## 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

<a id="contract"></a>

## Exact input and result types

```typescript
undoSpillTransaction(mutationId: GridMutationId): Promise<SyGridSpillUndoResult>
```

| Arguments | Required | Type |
| --- | --- | --- |
| mutationId | Required | GridMutationId |

The return type is `Promise<SyGridSpillUndoResult>`.

<a id="usage"></a>

## 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.

<a id="types"></a>

## Read related types

- [GridMutationId](https://grid.syidax.com/docs/types/GridMutationId.md)
- [SyGridSpillUndoResult](https://grid.syidax.com/docs/types/SyGridSpillUndoResult.md)

<a id="recipes"></a>

## Feature explanations and examples

- [Formula calculation](https://grid.syidax.com/docs/features/formulas.md) — 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.
