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

Create & Read excel file with fomula

Hi all,

I'm facing problem with formula after creating excel file and need your help. 

I have a excel template file with 3 columns 
  1. Cost (Number)
  2. Quality (Number)
  3. Total (formula) = Cost  * Quality 
I read this template and fill data into column Cost and Quality, then save new file (NEWFILE.xlsx)

Scenario 1:
  • Read the NEWFILE.xlsx but can't get the value from Total column
  • After using the EnableSheetCalculations method I can get the value but I realize the performance is every slow with difficult formula 
Scenario 2
  • Open the NEWFILE.xlsx, Ctr + S (saving) without any changes
  • Read the NEWFILE.xlsx but can get the value from Total column

I have done some suggestions on the internet but not working
  • EnableSheetCalculations before creating NEWFILE.xlsx
  • EnableSheetCalculations for calculating value runtime (very slow performance)


1 Reply

AV Abirami Varadharajan Syncfusion Team June 6, 2016 12:12 PM UTC

Hi Nhat, 
Thank you for contacting Syncfusion support. 
We are unable to reproduce the performance issue with EnableSheetCalculation method from our end. We have prepared a sample based on your requirement and shared it for your reference which can downloaded from the following link. 
Kindly try this sample and let us know whether the issue is resolved or not. If you are still facing this issue, then kindly share us the issue reproducing sample which will be helpful for us to provide you a prompt solution at the earliest. 
Please let us know if you have any concerns. 

Live Chat Icon For mobile
Up arrow icon