Invalid Formula Ver 8.2.2.0

Aspose.Cells Product Family
1

When processing the attached document with version 8.2.2.0, I get the following error:


{“Invalid formula:”=IF(Category[‘Spud Well Count’]=0,0,(Category[‘Completion Capex’]/Category[‘Completion Well Count’]))"."}


at . . (Int32 , String , Int32 , Int32 , , , Boolean , Boolean , Boolean )
at . .SetFormula(Int32 , String )
at . . (PivotTable )
at . . ()
at . .Read()
at . . (Workbook , LoadOptions )
at Aspose.Cells.Workbook. (Stream , LoadOptions , Boolean )
at Aspose.Cells.Workbook. (String , LoadOptions )
at Aspose.Cells.Workbook…ctor(String file, LoadOptions loadOptions)

2

Hi Angel,

Thanks for your posting and using Aspose.Cells.

We were able to observe this exception by executing the following sample code with your source xlsx file using the latest version: Aspose.Cells
for .NET v8.3.1.4.

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-43302 - Invalid Formula error on opening the Xlsx workbook

C#

string filePath = @“F:\Shak-Data-RW\Downloads\AAA±+ESSBASE+DATA+DUMP.xlsx”;


Workbook workbook = new Workbook(filePath);


3

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.3.1.6

We have fixed your issue now.

Let us know your feedback.

Thank you.