Angular wrapper performance issues

Getting help Questions
1

Hello!

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?

dense%20grid%20performance
dense%20grid%20performance399×647 32.7 KB

video demo:

2

I noticed that the performance increases dramatically if I remove the ‘cells’ handler from settings.
Do you have any alternative for styling cells?

Stefan

3

Hey @s.ilic

can you share your cells implementation? Maybe there are some ways to impove it.

4

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;
};

I’ll send you the rest of the settings on support@handsontable.com

Stefan

5

Thank you. We’ll continue the subject on emails.