Adjusting formulas across the sheet while new row inserted in ejSpreadsheet

[Unknown]

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,

Sudhakar. A

[Vinoth Kumar Sundara Moorthy]

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 

[Ivan Borges]

Hi.

Sorry to jump in, but this is far from being an improvement. It is a bug. In any spreadsheet you insert a row/column, the expected behavior is to automatically adjust every Formulas for the new row/column range. Otherwise, the control is completely useless. 

By the way, the EJ2 Spreadsheet is even worse than the EJ1. Is it really recommended to use this control in a production environment?

Best.

Ivan

[Sangeetha Priya Murugan]

Hi Ivan, 

 

Thank you for your update. 

 

We have checked your query and we would let you know that, the formula dependent cell references updated properly while insert/delete column in our EJ2 spreadsheet. And it works properly in EJ2 Spreadsheet, if you face any difficulties with EJ2 spreadsheet features. Please share the details regarding the issues, we will check and update you the better solution quickly. 

 

Regards, 

Sangeetha M