Type of base layer SpreadsheetData instance
Type of edit layer SpreadsheetData instance
Type of snapshot used by BaseData. By default, inferred from BaseData.
Type of snapshot used by EditData. By default, inferred from EditData.
Creates a LayeredSpreadsheetData instance from two existing SpreadsheetData instances.
All type parameters can be inferred from the constructor arguments.
Type of base layer SpreadsheetData instance
Type of edit layer SpreadsheetData instance
Type of snapshot used by BaseData. By default, inferred from BaseData.
Type of snapshot used by EditData. By default, inferred from EditData.
Format of specified cell using 0-based row and column indexes
Value of specified cell using 0-based row and column indexes
Number of columns in the spreadsheet
ItemOffsetMapping which describes sizes and offsets to start of columns
Return load status at the time the snapshot was created
On Success returns true if load has completed, false if still in progress On Err returns most recent error reported by the storage system
Number of rows in the spreadsheet
ItemOffsetMapping which describes sizes and offsets to start of rows
Return a snapshot to use when accessing values at a consistent point in time
Return the viewport in force (if any)
Check whether value and format are valid to set for specified cell
Ok if the value and format are valid
Set value and format of specified cell
Ok if the change was successfully applied
Set viewport of interest
Can be used by SpreadsheetData implementations to optimize data retrieval and memory usage.
Queries for cells outside the viewport may return undefined. Clients should not rely on any particular behavior
for queries outside the viewport.
Set to undefined (the default) if the client needs access to the entire spreadsheet
Subscribe to data changes
Implementation of SpreadsheetData that layers two other
SpreadsheetDatainstances on top of each other.There's an "edit" layer on top where any changes are stored, with a "base" layer underneath. If a value is
undefinedin the edit layer, the corresponding value is returned from the base layer instead.Common use case is a read only reference data source as the base layer with an initially empty edit layer that accepts changes.