formulaEvaluated

What does this API do?

Emitted when a formula result is calculated. Distinguish formula text from its result.

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

Exact input and result types

formulaEvaluated: GridFormulaEvaluatedDetail

Usage flow

Subscribe with grid.addEventListener('formulaEvaluated', 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('formulaEvaluated', event => {
  console.log(event.detail);
}, { signal: controller.signal });
// On view disposal: controller.abort();

Read related types

• GridFormulaEvaluatedDetail

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.