)
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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Why formulas are not updated when inserting rows?

Platform: WinForms |
Control: XlsIO |
Published Date: April 30, 2011 |
Last Revised Date: July 10, 2014

 

This issue happens not because of inserting the rows. if the sheet has the range that refers to a single cell [For eg:SUM(B2:B2)] then formulas cannot be updated. This is the default behavior of MS Excel. This can be solved by changing range reference in your template file as follows:

  • Insert a new row.
  • Then Change the formula. Say, "SUM(B2:B3)" instead of using "SUM(B2:B2)"
  • Also you can delete the unwanted rows after updating the formulas.

The below link has the sample with the changed template file:

http://websamples.syncfusion.com/samples/KB/XlsIO.Windows/UpdateFormula/Insert_Update_Formula.zip

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

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

Up arrow icon

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