Kendo Spreadsheet performance Issue with formula range

[Janaki]

Use Case:

I have n row and m columns.

columns m is sum of 1 to (m-1) columns

row n is sum of 1 to (n-1) row 

basically m column and nth row is created with formulas

 

Issue:

After spreadsheet load when I'm trying to update even one cell it takes ~5-10sec to trigger change event depending on size of data

Sample:

Attaching a fiddler link. Here after spreadsheet is loaded , edit one cell and click out.

https://jsfiddle.net/u2kz7cjb/

 

[Martin]

Hello, Janaki,

Thank you for the provided example.

With the given configuration, the Spreadsheet has approximately 800k cell, and making changes in a cell would trigger a large amount of calculations. Currently it takes the component around 3 seconds to trigger the change event, which seems reasonable given the large amount of data.

Let me know if I am missing something from the issue.

Regards,
Martin
Progress Telerik

[Janaki]

if i have formula added to bottom as well it take around 5-7 seconds for single cell update. It there any way i can reduce this time

[Ahmed]

What is the limit of cells that the Spreadsheet would work in less than 2 seconds in this scenario? With formulas etc?

Please advise ASAP.

[Martin]

Hello, Janaki, 

We cannot say a specific number as a limitation for the cells in the Spreadsheet. If you could modify the initial example to observe the 5-7 seconds delay, we will be able to investigate the configuration to check if there's something we can offer.

Also, if you wish to get a faster response, you can open a support ticket to benefit the 24h response time of your paid support subscription.

[Janaki]

https://jsfiddle.net/xywzu2dn/1/

 

please check this example. Just edit a cell and click outside. it almost took 8 seconds for it trigger event.

[Georgi Denchev]

Hello Janaki,

I am stepping in for my colleague Martin.

Thank you for providing the example.

As Martin mentioned, making changes to 800k cells triggers a significant number of calculations. Adding formulas to these cells further increases the computational load, resulting in slower performance.

While using the sheet.batch method does improve performance to some extent, any change will cause the Spreadsheet component to refresh. This means all cells will be re-rendered, and all calculations will be performed again. Even if re-rendering a single cell with a formula takes approximately 10 microseconds (depending on the machine), re-rendering 800k cells would take around 8 seconds.

There is no specific limit on the number of cells. However, based on the time required for processing 800k cells, achieving performance within the 2-second range is feasible with approximately 150k to 200k cells.