We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Formulas are not calculated on a slightly complex excelfile. (w. repo)

Hello,

We have ran into a problem with the attached excelfile.

None of the values on the “OUT_ProcessInformation” sheet seem to be calculated.

For example, when we open in the file in excel then the cell with he name “Out_Conclusion” shows up having the value: 'KnownCoverageWithClaim_P1C1C1

However, if we read the value from code, the value ‘KnownCoverageNoClaim_P1C1C0’ comes up. We have tried playing around with several settings and or earlier versions (8.0.0.1 , 8.3.0.0 and another), all have the same problem.

The attached project is a c# application that will throw an exception when the wrong value is read.

In the past we have never worried much about the timetable when we encounter a problem with your software, however, for the current project we are working on, the correct function of excelfiles is on the critical path, a quick resolution to this problem is essential.

Please advice us in how to solve this problem.

Hi Wouter,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after calculating the formulas on your workbook using the latest version: Aspose.Cells
for .NET v8.3.0.4
. After the calculation the value in cell C4 whose name is Out_Conclusion inside the worksheet OUT_ProcessInformation is wrong. The correct value is KnownCoverageWithClaim_P1C1C1 but Aspose.Cells calculates this as KnownCoverageNoClaim_P1C1C0.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43225 - Formulas are not calculated on a slightly complex Excel file

I have attached the source Excel file, output PDF and screenshot highlighting this issue for a reference.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\t\BadEvaluation_Complex.Xlsx”;


Workbook workbook = new Workbook(filePath);


workbook.CalculateFormula();


workbook.Save(filePath + “.out.pdf”);

Hi Wouter,

Thanks for your using Aspose.Cells.

Please download and try the latest version: Aspose.Cells for .NET 8.3.1 and let us know your feedback.

The issues you have found earlier (filed as CELLSNET-43225) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

I have used the 8.3.1 (ddl only) version… to great success!

I wish to speak out my great thanks to all the people involved, for the very speedy resolution of this problem.


Thank you, it helps a lot.

----- on an unrelated note -----

The ‘WorkBook.Open’ method is marked as obsolete and scheduled for deletion by july 2011.
The comment also directs us to use the constructor.
Yet the constructor does not have support for the ‘WorkBook.Setting’ object.
One of the properties of that object is ‘Settings.ParsingFormulaOnOpen’.

From a performance perspective, this could be a problem.

Since 2011 is long gone, why not just delete the ‘obsolete’ attribute?

Hi Wouter,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest version. Let us know if you encounter any other issue, we will be glad to look into it and help you further.