formulaError

What does this API do?

Emitted when formula evaluation fails. Connect target and error information to a review UI.

API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns

Exact input and result types

formulaError: GridFormulaErrorDetail

Usage flow

Subscribe with grid.addEventListener('formulaError', handler). The result is in event.detail, and event names are case-sensitive. Remove subscriptions when disposing of the view.

const controller = new AbortController();
grid.addEventListener('formulaError', event => {
  console.log(event.detail);
}, { signal: controller.signal });
// On view disposal: controller.abort();

Read related types

• GridFormulaErrorDetail

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.