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
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback
Essential JS2

Syncfusion jQuery based widgets are no longer in active development. Switch to our pure JavaScript based next generation Essential JS 2 library.

Adjusting formulas across the sheet while new row inserted in ejSpreadsheet

Thread ID:





146963 Aug 26,2019 10:34 AM UTC Aug 27,2019 01:15 PM UTC jQuery 1
Tags: ejSpreadSheet
Asked On August 26, 2019 10:34 AM UTC

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 [Syncfusion]
Replied On 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 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon