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

Why formulas are not updated when inserting rows?

 

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

Article ID: Published Date: Last Revised Date: Platform: Control:
1901 04/30/2011 07/10/2014 Windows Forms XlsIO
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.