When opening workbook I get error "Invalid formula�

Aspose.Cells Product Family
1

Hello!

Could you please look at this issue? When trying to open workbook:

Workbook _wb = new Workbook("ArrayFormula_error.xlsm");

I have got an exception: “Invalid formula:”.

The attached file contains Multi Cell Array Formula in the range A1:A13.

I work with Aspose.Cells version 7.3.2.4.

Thank you!

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We were able to replicate this exception using the latest version:
Aspose.Cells
for .NET v7.3.3 with the following sample code.

We have logged this issue in our database. We will look into this issue and fix it.

Once the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41157.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\ArrayFormula_error.xlsm”;


Workbook workbook = new Workbook(filePath);


Exception:
An unhandled exception of type 'Aspose.Cells.CellsException' occurred in Aspose.Cells.dll

Additional information: Invalid formula:
3

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.3.3.1 and let us know your feedback.

4

Hi Shakeel,

It works!

Thank you for help!

5

Hi,

Thanks for your feedback.

It’s good to know that your issue has resolved with the given fix. We have now closed this thread.

Let us know if you face any other issue, we will be glad to help you further.

6

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

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