Interface ReactSpreadsheetData<Snapshot>

Extension of SpreadsheetData interface so that it's compatible with React's useSyncExternalStore hook

Additional properties are optional, so anything that implements SpreadsheetData is compatible with something that accepts ReactSpreadsheetData.

interface ReactSpreadsheetData<Snapshot> {
    getServerSnapshot?: () => Snapshot;
    getCellFormat(
        snapshot: Snapshot,
        row: number,
        column: number,
    ): undefined | string;
    getCellValue(snapshot: Snapshot, row: number, column: number): CellValue;
    getColumnCount(snapshot: Snapshot): number;
    getColumnItemOffsetMapping(snapshot: Snapshot): ItemOffsetMapping;
    getRowCount(snapshot: Snapshot): number;
    getRowItemOffsetMapping(snapshot: Snapshot): ItemOffsetMapping;
    getSnapshot(): Snapshot;
    setCellValueAndFormat(
        row: number,
        column: number,
        value: CellValue,
        format: undefined | string,
    ): boolean;
    subscribe(onDataChange: () => void): () => void;
}

Type Parameters

Snapshot

Hierarchy (View Summary)

SpreadsheetData<Snapshot>
- ReactSpreadsheetData

Index

Methods

getCellFormat getCellValue getColumnCount getColumnItemOffsetMapping getRowCount getRowItemOffsetMapping getSnapshot setCellValueAndFormat subscribe

Properties

getServerSnapshot?

Methods

getCellFormat

getCellFormat(
    snapshot: Snapshot,
    row: number,
    column: number,
): undefined | string
Format of specified cell using 0-based row and column indexes
Parameters
- snapshot: Snapshot
- row: number
- column: number
Returns undefined | string
Inherited from SpreadsheetData.getCellFormat
- Defined in infinisheet-types/src/SpreadsheetData.ts:78

getCellValue

getCellValue(snapshot: Snapshot, row: number, column: number): CellValue
Value of specified cell using 0-based row and column indexes
Parameters
- snapshot: Snapshot
- row: number
- column: number
Returns CellValue
Inherited from SpreadsheetData.getCellValue
- Defined in infinisheet-types/src/SpreadsheetData.ts:75

getColumnCount

getColumnCount(snapshot: Snapshot): number
Number of columns in the spreadsheet
Parameters
- snapshot: Snapshot
Returns number
Inherited from SpreadsheetData.getColumnCount
- Defined in infinisheet-types/src/SpreadsheetData.ts:69

getColumnItemOffsetMapping

getColumnItemOffsetMapping(snapshot: Snapshot): ItemOffsetMapping
ItemOffsetMapping which describes sizes and offsets to start of columns
Parameters
- snapshot: Snapshot
Returns ItemOffsetMapping
Inherited from SpreadsheetData.getColumnItemOffsetMapping
- Defined in infinisheet-types/src/SpreadsheetData.ts:72

getRowCount

getRowCount(snapshot: Snapshot): number
Number of rows in the spreadsheet
Parameters
- snapshot: Snapshot
Returns number
Inherited from SpreadsheetData.getRowCount
- Defined in infinisheet-types/src/SpreadsheetData.ts:63

getRowItemOffsetMapping

getRowItemOffsetMapping(snapshot: Snapshot): ItemOffsetMapping
ItemOffsetMapping which describes sizes and offsets to start of rows
Parameters
- snapshot: Snapshot
Returns ItemOffsetMapping
Inherited from SpreadsheetData.getRowItemOffsetMapping
- Defined in infinisheet-types/src/SpreadsheetData.ts:66

getSnapshot

getSnapshot(): Snapshot
Return a snapshot to use when accessing values at a consistent point in time

Returns Snapshot
Inherited from SpreadsheetData.getSnapshot
- Defined in infinisheet-types/src/SpreadsheetData.ts:60

setCellValueAndFormat

setCellValueAndFormat(
    row: number,
    column: number,
    value: CellValue,
    format: undefined | string,
): boolean
Set value and format of specified cell
Parameters
- row: number
- column: number
- value: CellValue
- format: undefined | string
Returns boolean
True if the change was successfully applied
Inherited from SpreadsheetData.setCellValueAndFormat
- Defined in infinisheet-types/src/SpreadsheetData.ts:84

subscribe

subscribe(onDataChange: () => void): () => void
Subscribe to data changes
Parameters
- onDataChange: () => void
Returns () => void
Inherited from SpreadsheetData.subscribe
- Defined in infinisheet-types/src/SpreadsheetData.ts:57

Properties

`Optional`getServerSnapshot

getServerSnapshot?: () => Snapshot

Used by useSyncExternalStore to support server side rendering