Data Grid Cell Caching
Overview
The cache feature allows a formula's result to be stored, accelerating the loading time of a new spreadsheet.
Documentation
Methods
The following methods can be used to get or set comments in one or multiple data grid cells.
| Method | Description |
|---|---|
| getCache | Get the cache for a cell. worksheetInstance.getCache(cellName: String) |
| setCache | Set the cache for one or more cells. @param {string|object} cellName - Identification of a cell or an object with multiple definitions @param {string?} value worksheetInstance.setCache(cellName: String | object, value?: String) |
Initial Settings
The following properties are available through the initialization of the online spreadsheet.
| Property | Description |
|---|---|
| cache: object | Object with the initial cache values. Example: { A1: 'test', B1: 'another test' } |
Examples
Loading formula values from cache
To optimize formula value caching in Jspreadsheet, initialize the spreadsheet with the configuration set to use cached data for formulas. This approach speeds up the loading of pre-calculated values, improving performance and user experience, particularly in data-heavy scenarios.
// Create the spreadsheet
let worksheets = jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
minDimensions: [10,10],
data: [
[10,'=SUM(A1)*10'],
],
cache: { A1: 100 },
}],
});