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.
Syncfusion Feedback

Create & Read excel file with fomula

Thread ID:

Created:

Updated:

Platform:

Replies:

124372 Jun 3,2016 05:17 PM UTC Jun 6,2016 12:12 PM UTC WinForms 1
loading
Tags: XlsIO
Nhat Nguyen
Asked On June 3, 2016 05:17 PM UTC

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)

Thanks

Abirami Varadharajan [Syncfusion]
Replied On 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. 
 
Regards, 
Abirami. 


CONFIRMATION

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.

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

;