com.aspose.cells.CellsException: Invalid formula:"=!$AA$1"

Hi,


We are encountering the above exception when opening the workbook that I have attached to this post.
Could you please take a look and advise if there is a problem with Cells Java. I have tested with the latest release.

Thanks,
Henrick Blake

Hi,

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

I have tested your file with the latest version:
Aspose.Cells
for Java v7.3.0.3

and found that when the file is opened, it throws exception.

We have logged this issue in our database. We will look into it and fix the bug and 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 CELLSJAVA-40272.

Please see the sample code and exception below.

Java


String path = “F:\Shak-Data-RW\Downloads\EH2.xlsx”;

Workbook workbook = new Workbook(path);


Exception:
Exception in thread "main" com.aspose.cells.CellsException: Invalid formula:"=!$AA$1".
at com.aspose.cells.iF.a(Unknown Source)
at com.aspose.cells.Name.g(Unknown Source)
at com.aspose.cells.NameCollection.a(Unknown Source)
at com.aspose.cells.ml.n(Unknown Source)
at com.aspose.cells.ml.a(Unknown Source)
at com.aspose.cells.mj.h(Unknown Source)
at com.aspose.cells.mj.a(Unknown Source)
at com.aspose.cells.mi.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)
at ClsAsposeTest.f1(ClsAsposeTest.java:44)
at ClsAsposeTest.main(ClsAsposeTest.java:25)

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for Java v7.3.0.4

Hi,


I’ve tested the fix and it works.

Thanks,
Henrick

Hi,

Thanks for your feedback.

It’s good to know your issue is resolved now.

If you face any other issue, please feel free to let us know, we will be glad to help you.

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


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