Skip to content
GRID Editor

Formula Reference Highlighting

When the SpreadsheetEditor component’s showFormulaReferencesOnCellSelection property is set to true, selecting a cell that contains a formula will highlight all the cells it references.

Interactive Demo

Section titled “Interactive Demo”

Usage

Section titled “Usage”
<SpreadsheetEditor
  model={model}
  showFormulaReferencesOnCellSelection
/>

This is equivalent to passing showFormulaReferencesOnCellSelection={true}.

When to use this

Section titled “When to use this”

This is useful when building tools where understanding formula dependencies matters — for example, auditing spreadsheets, teaching formula construction, or letting users explore how values are derived.

For programmatic highlighting (triggering highlights from outside the editor), see Controlling the Editor.