Create & Read excel file with fomula

[Nhat Nguyen]

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]

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. 

 

Sample Link:  http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample1744867856.zip  

 

 

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.