Skip to content

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.

<SpreadsheetEditor model={model} showFormulaReferencesOnCellSelection />

This is equivalent to passing showFormulaReferencesOnCellSelection={true}.

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.