Adjusting formulas across the sheet while new row inserted in ejSpreadsheet

Hi,
While inserting/deleting rows, how update formulas across the sheets .Ex:

In sheet1 cell A3 have value as 100
In sheet2 cell A1 have formulae as=Sheet1!A3
I i will remove sheet1 A2 entire rows ..cell A3 changing as A2 .but the formula in sheet2 cell A1 is =Sheet1!A3 referring same cell it should change to =Sheet1!A2.if any why to update those formulae?

Thanks and Regards,

Hi Sudhakar, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported requirement and considered this as an improvement. You can track the status of this report using below link from our feedback portal, 

 

https://www.syncfusion.com/feedback/8496/need-to-improve-formula-calculation-while-insert-delete-the-row-and-column 

 

The fix will be available in any of our upcoming releases. We appreciate your patience until then. 

 

Regards, 

Vinoth Kumar S