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

Excel sheet calculation on the fly

Thread ID:





102142 Jan 3,2012 10:23 AM UTC Feb 29,2012 03:35 AM UTC ASP.NET Web Forms (Classic) 5
Tags: XlsIO
Michael Tse
Asked On January 3, 2012 10:23 AM UTC


I have read a sample on Syncfusion and realized that XlsIO is capable to re-calculate the formulas on the worksheet by the IWorkSheet.EnableSheetCalculations().However, I cannot find this method in IWorksheet of my Syncfusion library. The Syncfusion version I am using is 8.403.0.10. Can you please advise how can I activate the calculation?


Manoj Kumar G M [Syncfusion]
Replied On January 4, 2012 06:49 AM UTC

Hi Michael,

Thank you very much for your interest in Syncfusion Products.

Essential XlsIO includes support for enabling the calculations of Essential Calculate supported formulas that are added at runtime to the worksheet.

The computed value will be set to the “CalculatedValue” property associated to the “IRange” object.

The following code snippet illustrates how to enable the sheet formula calculations.


IWorksheet sheet = workbook.Worksheets[0];
//Formula calculation is enabled for the sheet.
string computedValue = sheet.Range["C1"].CalculatedValue;

Please go through the following online documentation link for more details.


Please try the sample and let us know if this helps you.

Please let us know if you require any further clarifications.



Michael Tse
Replied On January 6, 2012 02:57 AM UTC

I am using Syncfusion version 8.403.0.10.
In this version, seems the IWoksheet interface has no EnableSheetCalculations method and IRange interface has no CalculatedValue property. Can you please advise how can I do this in version 8?

Manoj Kumar G M [Syncfusion]
Replied On January 6, 2012 11:03 AM UTC

Hi Michael,

Sorry for the inconvenience.

The reported version 8.403.0.10 is almost 5 versions back and we do not have the implementation of EnableSheetCalculation method. So we strongly recommend you to upgrade your essential studio version to our latest version. We provided the latest version download link for your reference.


Please let us know if you need any clarifications.


Michael Tse
Replied On February 24, 2012 07:14 AM UTC

Thank you.

Manoj Kumar G M [Syncfusion]
Replied On February 29, 2012 03:35 AM UTC

Hi Michael,

Thanks for your update.

Please let us know if you require any further clarifications.



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