We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Adjusting formulas across the sheet while new row inserted in ejSpreadsheet

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

3 Replies

VK Vinoth Kumar Sundara Moorthy Syncfusion Team August 27, 2019 01:15 PM UTC

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, 
The fix will be available in any of our upcoming releases. We appreciate your patience until then. 
Vinoth Kumar S 

IB Ivan Borges December 17, 2021 05:59 PM UTC


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?



SP Sangeetha Priya Murugan Syncfusion Team December 21, 2021 11:09 AM UTC

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. 
Sangeetha M 

Live Chat Icon For mobile
Up arrow icon