Hello. Please correct import of the cells containing the formulas. I have put a file - on the first sheet the data is read normally, but on the third sheet in the cells containing the formulas absolutely other values. For example, cell R12C1 containing the formula "=SUM (R [1] C)", is imported with value 14000, but actually there 10000.
Oh....
Date of my problem is " 03-22-2010 ". Excuse me, but I didn't work for a long time with this import because I have changed a job. It is very interesting, but I now don't have time for check of your example, therefore I will believe to you that all works well. Thanks that you suffer my awful English)
Hello Brutar,
I created a sample using NetAdvantage 11.1.20111.2020 and verified the cell value being 14000 when importing the file using Workbook.Load() method.
It will be helpful to provide more information in regards to how the excel file is being loaded in the application and how the cell value is being checked.
Here's the attached sample that I ran for this.
Let me know if you have any questions with this matter. Thank you.