Initial Selection

You can set an initial cell or range selection when the SpreadsheetViewer mounts using the initialSelection prop.

Interactive Demo

Usage

The initialSelection prop accepts an A1-style reference string, optionally prefixed with a sheet name.

Programmatic References

You can build a reference programmatically using the re-exported A1Ref class:

import { SpreadsheetViewer, A1Ref } from "@grid-is/mondrian-react";

const ref = new A1Ref(selection, { sheetName: "Summary" });
<SpreadsheetViewer model={model} initialSelection={ref.toString()} />;

A1-Style Reference Format

The A1-style reference format follows Excel’s standard notation:

• A1 - Single cell
• A1:B5 - Range of cells
• Sheet1!A1 - Cell on a specific sheet
• Sheet1!A1:B5 - Range on a specific sheet

Tip

If you don’t specify a sheet name, the selection will apply to the first sheet in the workbook.

Related

• Handling Events - Listen to selection changes
• Component Props - See all available props