1. Feedback
  2. Angular
  3. 25627

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!

2
Votes

Deleting a whole row on sheet that references other sheets changes values to '#REF!'

Need to fix the formula issue, while delete the row in spreadsheet. Formula reference not getting updated while delete the row. Ensure all the related cases for both insert and delete actions.


Issue Replicable sample: https://stackblitz.com/edit/angular-f1tn2u-dwt67j?file=app.component.html


  1. Have 2 or more sheets:
  2. On the second sheet insert some random data to cells.
  3. On the first sheet create some functions that reference cells ranges from the second sheet, eg. "=SUM(Sheet2!A1:B1)" or "=IF('Sheet2'!A1>0,1,0)", 
     =IF(SUMIF(Sheet2!$A1:$A6,">3",Sheet2!$B1:$B6)<3,1,''').
  4. Insert some data to rows below in the first sheet.
  5. Delete the whole row with some data:

  1. After deleting the row, the sheet references in the created functions are changed to "#REF!" values and the whole cell receives "#REF!" in result:

Actual Result:

Empty


Expected Result:


Empty