1. Feedback
  2. Angular
  3. 58774

Welcome to the Angular feedback portal. We’re happy you’re here! If you have feedback on how to improve the Angular, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Improve the formula recalculation performance when deleting the values on the formula dependent cells

Description:

When deleting the cell values ranging from D1:E80 the spreadsheet will hang for several minutes.

Validated Details:

In the attached sample below, the cells ranging from D1:E80 has been updated with the formula using the updateCell() method.

The formula used in the columns of above sample contains the references as mentioned below:

Column D -> contains reference of A1, A2, A3 and F column cells.
Column E ->  contains reference of B1 and D column cells.
Column F -> contains reference of F and E column cells.

As, the cells from the above mentioned columns are dependent on the cells of A, B, D, E , F columns, when we try to delete one or more cells, from the above columns the dependent cells of the cells which you are trying to delete gets updated first and then gets deleted. This process occurs to all the cells which contains formula.

So, when deleting the cells ranging from D1:E80 there are many dependent cells which needs to be updated, causing the spreadsheet to hang for several minutes.