# applySpillFormula

Atomically applies a dynamic array formula under the conflict policy. Inspect conflicts, rejections, and unrendered areas in the report.

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

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

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

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

## Exact input and result types

```typescript
applySpillFormula(input: SyGridSpillApplyInput): Promise<SyGridSpillApplyResult>
```

| Arguments | Required | Type |
| --- | --- | --- |
| input | Required | SyGridSpillApplyInput |

The return type is `Promise<SyGridSpillApplyResult>`.

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

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

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

## Read related types

- [SyGridSpillApplyInput](https://grid.syidax.com/docs/types/SyGridSpillApplyInput.md)
- [SyGridSpillApplyResult](https://grid.syidax.com/docs/types/SyGridSpillApplyResult.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.