Aspose.Cells (7.1.2.0) fails to open document with complex formula

Aspose.Cells Product Family
1
I just updated to the most recent version of Aspose.Cells (7.1.2.0), in order to take advantage of the RibbonXml feature.

However, a document which was loadable with v 7.0.4.0 now fails.
This is not the first time Aspose introduces bugs in new versions. It is rather worrying, since it means we need to test all our Excel-templates thoroughly each time we upgrade to newer versions.
I hope this can be addressed as soon as possible.

See the attached example. The error we get is:

Error in Cell: T10-Invalid formula."IF(COUNT(I10:R10)<>0,
MAX(
IF(COUNT(I10,J10)<>0,I10*Gross_LivArea+J10*Gross_ComArea,MinMarker),
IF(COUNT(L10,M10)<>0,L10*Saleable_LivArea+M10*Saleable_ComArea,MinMarker),
IF(COUNT(O10,P10)<>0,O10*NumLU_NonCom+P10*NumLU_Com,MinMarker),
IF(COUNT(R10)<>0,R10,MinMarker)
),"")"
2

Hi,


Sorry for any inconvenience caused!

We found the issue as you mentioned opening your template file with Aspose.Cells for .NET. We have logged your issue into our issue tracking system with an id: CELLSNET-40618. We have already started working over it and we will fix it soon.

Sample code:
var workbook3 = new Aspose.Cells.Workbook(@“e:\test2\Formula.xlsx”);

Thank you.

3

Hi,

Please download and try this fix: Aspose.Cells for .NET 7.2.0.3

4

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.