Issue with .xlsb excel format (getting "found unreadable content" and gettting aspose exception)

Aspose.Cells Product Family
1

Hi Team,


I am facing two issues with aspose latest jar (aspose cells 8.3.0).

XLSB format is critical for us. so please look into these issues and provide the needful solution.

1)I am running simple program to save .xlsb file and when i try to open the file its showing “found unreadable content” and am not able to open the file.

2)I am adding data in one of the sheet (“sheet1”) and running same report and its showing aspose exception.

java.lang.ArrayIndexOutOfBoundsException: -1
at java.util.ArrayList.get(Unknown Source)
at com.aspose.cells.zro.b(Unknown Source)
at com.aspose.cells.zro.c(Unknown Source)
at com.aspose.cells.Name.c(Unknown Source)
at com.aspose.cells.Name.t(Unknown Source)
at com.aspose.cells.zbpl.i(Unknown Source)
at com.aspose.cells.zbpl.e(Unknown Source)
at com.aspose.cells.zbpl.a(Unknown Source)

---------------

sample code


try
{
String in=“D:/Current_Plan_Report.xlsb”;
String out=“E:/Current_Plan_Report.xlsb”;
Workbook workbook= new Workbook(in);
workbook.save(out,SaveFormat.XLSB);
System.out.println(“Saved”);
}
catch(Exception e)
{
e.printStackTrace();
}

----------------------------------------------------





thanks
2

Hi,


Thanks for the template files and sample code.

1) After an initial test, I observed the issue as you mentioned by just opening and re-saving the XLSB file you attached. When I open the output XLSB file into MS Excel, I got an error:
“Excel found unreadable content…” error
e.g
Sample code:

String in=“Current_Plan_Report1_issue 1.xlsb”;
String out=“outCurrent_Plan_Report1.xlsb”;
Workbook workbook= new Workbook(in);
workbook.save(out,SaveFormat.XLSB);
System.out.println(“Saved”);

I have logged a ticket with an id “CELLSJAVA-41101” for your issue. We will look into it to figure it out soon.

Once we have any update on it, we will let you know here.

2) Could you paste the sample code (runnable) with your data, so we could evaluate your issue properly.

Thank you.
3

Hi Chandra,

Thanks for your posting and using Aspose.Cells.

We have looked into your second issue further and were able to replicate it using the following code with the latest version: Aspose.Cells for Java 8.3.0. ArrayIndexOutOfBoundsException occurs on opening your second 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-41102 - ArrayIndexOutOfBoundsException on opening the XLSB file

Java

String filePath = “F:\Shak-Data-RW\Downloads\Current_Plan_Report_issue 2.xlsb”;


Workbook workbook = new Workbook(filePath);

Exception:
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: -1
at java.util.ArrayList.get(Unknown Source)
at com.aspose.cells.zro.b(Unknown Source)
at com.aspose.cells.zro.c(Unknown Source)
at com.aspose.cells.Name.c(Unknown Source)
at com.aspose.cells.Name.t(Unknown Source)
at com.aspose.cells.zbpl.i(Unknown Source)
at com.aspose.cells.zbpl.e(Unknown Source)
at com.aspose.cells.zbpl.a(Unknown Source)
at com.aspose.cells.zbpu.c(Unknown Source)
at com.aspose.cells.zbpu.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:402)
at ClsAsposeTest.main(ClsAsposeTest.java:38)

4

Hi Team,


As this is a critical issue from our side, can you please provide the ETA for these issues so that we can plan accordingly.



thanks
5

Hi Chandra,


Thank you for writing back.

Both tickets (CELLSJAVA-41101 & CELLSJAVA-41102) were logged a few hours ago so they are currently pending for analysis and are in the queue with other priority tasks. We cannot share the estimated release schedule for the fix unless we have thoroughly analyzed the presented scenarios to isolate the problem cause. Please note, we have recorded notes on the aforesaid tickets requesting the core team to schedule them for analysis at earliest possible. As soon as we have updates for you, we will post here for your kind reference.
6

Hi,

Thanks for using Aspose.Cells for Java.

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

7

Hi


Thanks for the quick reply. we will test it and will share our results.


thanks
8

Hi


I tested with latest aspose jar, but issue still exists. Please find the attached template.


thanks.
9

Hi Chandra,

Thanks for your feedhack and using Aspose.Cells.

We were able to replicate this issue using the latest version: Aspose.Cells
for Java v8.3.0.2 by executing the following sample code. Opening and saving Current_Plan_Report_issue2.xlsb makes it corrupt.

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-41111 - Opening and saving Current_Plan_Report_issue2.xlsb makes it corrupt

I have attached the output xlsb file which shows error when opened in Microsoft Excel for a reference.

Java

String filePath = “D:\Downloads\Current_Plan_Report_issue2.xlsb”;


Workbook workbook = new Workbook(filePath);

workbook.save(filePath + “out.xlsb”);

10

Hi Team,


any update on this issue.


thanks
11

Hi,


Well, we are working on your issue “CELLSJAVA-41111”. Please spare us 3-5 days further, hopefully your issue would be fixed in the next week.

Once we have any update on it, we will let you know here.

Keep in touch.

Thank you.
12

Hi,

Thanks for your using Aspose.Cells.

We have fixed this issue.

  • CELLSJAVA-41111 - Opening and saving Current_Plan_Report_issue2.xlsb makes it corrupt

Please download and try the latest fix: Aspose.Cells for Java v8.3.0.4 and let us know your feedback.

13

Hi Team,



thanks for your reply.

I tried with latest jar. But when i ran the report with excel (XLSB) which has slicers its not working. its corrupting the base report again.

note: same report in xlsx format is working fine.


please look into the issue ASAP.





thanks.

14

Hi Chandra,

Thanks for your feedhack and using Aspose.Cells.

We were able to replicate this issue using the latest version: Aspose.Cells
for Java v8.3.0.4 by executing the following sample code. Opening and saving Financial_Statement_Input_Report_Withdata.xlsb makes it corrupt.

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-41122 - Opening and saving Financial_Statement_Input_Report_Withdata.xlsb makes it corrupt

I have attached the output xlsb file which shows error when opened in Microsoft Excel for a reference.

Java

String filePath = "D:\\Downloads\\Financial_Statement_Input_Report_Withdata.xlsb";

Workbook workbook = new Workbook(filePath);
workbook.save(filePath + ".out.xlsb");

15

Hi Team,


Any update on this issue?


Thanks
16

Hi,


I am afraid, your issue logged as “CELLSJAVA-41122” is still in process. I have logged your concerns against your issue into our database. I have also asked the concerned developer to update on it or provide an eta if possible. Once we have any update on it, we will let you know immediately here.

Sorry for the inconvenience caused!
17

Hi,

Thanks for using Aspose.Cells.

It is to update you that CELLSJAVA-41122 should be fixed in about 19-December-2014.

18

The issues you have found earlier (filed as CELLSJAVA-41111;CELLSJAVA-41101;CELLSJAVA-41102) have been fixed in this update.

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

Hi,


Please try our latest version/fix: Aspose.Cells for Java v8.3.1.1

We have fixed your issue “CELLSJAVA-41122” now.

Let us know your feedback.

Thank you

20

Hi


Thanks for the reply.

I tested with latest jar. Below are my observations:(attaching original and generated files for reference)

1) Am able to open template with out any issue.
2) Pivot options are not working.

left top corner of the excel sheet , we have a box WORLD_REAGION Desc–> if you click on buttons in that like Americas, asia pacific etc.you will observe that the values in the right side boxes to that change and the values in below table gets change.


Please look into this issue ASAP.

Thanks