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: November 16, 2018).
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.

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