After further testing I noticed a significant drop on performance when using the grid with formulas.
I read your performance tips, but the result is more less the same.
The process of inserting a value and registering it takes around 3s which is too much for simple operations.
Do you have any tips as of how to solve the problem?
The cells implementation is the same as in your example in docs.
settings['cells'] = function (row, col) {
const cellProperties = {};
const data_ = this.instance.getData();
if (row === 0 || data_[row] && data_[row][col] === 'readOnly') {
cellProperties['readOnly'] = true; // make cell read-only if it is first row or the text reads 'readOnly'
}
if (row === 0) {
cellProperties['renderer'] = this.firstRowRenderer; // uses function directly
}
return cellProperties;
};