CellsException "More than one token in stack" in v8.5.0.2

Aspose.Cells Product Family
1
Hi Aspose,

In v8.5.0.2, we are getting the following error when simply opening the Excel file:

Exception in thread "main" com.aspose.cells.CellsException: Name[Aspose.Cells.Name [ NumHistColToSee; ReferTo:=]] based on [0]Sheet1!A1-Invalid formula: More than one token in stack
at com.aspose.cells.zya.a(Unknown Source)
at com.aspose.cells.zya.a(Unknown Source)
at com.aspose.cells.Name.c(Unknown Source)
at com.aspose.cells.Name.s(Unknown Source)
at com.aspose.cells.zcet.a(Unknown Source)
at com.aspose.cells.zyj.a(Unknown Source)
at com.aspose.cells.Shape.e(Unknown Source)
at com.aspose.cells.zajn.f(Unknown Source)
at com.aspose.cells.zajn.c(Unknown Source)
at com.aspose.cells.zajn.a(Unknown Source)
at com.aspose.cells.zajn.a(Unknown Source)
at com.aspose.cells.zccy.e(Unknown Source)
at com.aspose.cells.zccy.b(Unknown Source)
at com.aspose.cells.zccy.a(Unknown Source)
at com.aspose.cells.zccy.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 asposetest.AsposeTest.openAndSave(AsposeTest.java:100)
at asposetest.AsposeTest.main(AsposeTest.java:38)

Attached is the file that can reproduce the problem.

Code which triggers the exception:

final Workbook workbook = new Workbook("C:\\Temp\\MoreThanOneTokenInStack.xlsb");

The same code and Excel file work fine with an older version, v8.4.2.

Please let us know how we can resolve this issue. Thanks.

2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue by opening your source xlsb file with the latest version: Aspose.Cells
for Java v8.5.0.2. It throws cells exception on opening the xlsb file.

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

  • CELLSJAVA-41399 - CellsException on opening the source xlsb file

3

Hi Simon,


This is to inform you that we have fixed the problem logged earlier as CELLSJAVA-41399. We will shortly provide the fix here with next maintenance release of Aspose.Cells for Java.
4

Hi,

Thanks for using Aspose.Cells for Java.

Please download and try this fix: Aspose.Cells for Java v8.5.0.4 and let us know your feedback.

5

Hi Aspose,


Thanks. v8.5.0.4 has resolved this particular problem.

However we discovered another issue and I’ve created another topic for it:
VBA code in .xlsb lost after saving in v8.5.0.4

6

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your previous issue is resolved. For your other issue, we will look into it in your other thread and update you there.

7

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

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