"Excel found unreadable content" after file is saved by Aspose v8.3.0.1

Aspose.Cells Product Family
1
After merely re-saving an Excel file by Aspose v8.3.0.1, we're getting the below error (excelerror1.png):

Excel found unreadable content in 'original_2.xlsb'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

After clicking Yes, we got another error (excelerror2.png):

Excel was able to open the file by repairing or removing the unreadable content.
Removed Part: /xl/pivotCache/pivotCacheDefinition1.bin part. (PivotTable cache)
Removed Part: /xl/pivotTables/pivotTable1.bin part. (PivotTable view)

Source code to reproduce this error is simply:

final Workbook workbook = new Workbook("C:\\Temp\\original.xlsb");
workbook.save("C:\\Temp\\original_2.xlsb");

The original Excel file is attached (original_xlsb.zip).

Any idea how to get rid of the errors?



2

Hi Simon,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version: Aspose.Cells
for Java v8.3.2.1. It should fix this issue.

We have tested this issue with the following sample code using the latest version and it generated the correct output xlsb file which we have attached for your reference.

Java


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


Workbook workbook = new Workbook(filePath);

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

3

Thanks Shakeel. Updating to v8.3.2.1 resolved this particular issue.


However, after performing some other operations, we are getting a similar error, this time on “Worksheet properties” (excelerror4.png).

Source code to reproduce the problem:

final Workbook workbook = new Workbook(“C:\Temp\original.xlsb”);

workbook.getWorksheets().add(“NewSheet1”);

workbook.getWorksheets().add(“NewSheet2”);
workbook.getWorksheets().get(“NewSheet2”).getCells().get(“A1”).setValue(“abc”);

workbook.save(“C:\Temp\original_2.xlsb”);

Please help.
4

Hi Simon,


Thank you for writing back.

We have evaluated your recently shared scenario while using the latest version of Aspose.Cells for Java 8.3.2.3, and we are able to replicate the said problem. After adding a worksheet and cell value the XLSB file becomes corrupted and causes MS Excel application to pop-up repair warning. We have logged the problem in our bug tracking system under the ticket CELLSJAVA-41196 for further investigation & correction purposes. Please spare us little time to properly evaluate the problem cause, and to provide the fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.
5

Hi,

Thanks for using Aspose.Cells.

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

6

Hi Shakeel, v8.3.2.4 has fixed this problem. Thanks!

7

Hi Simon,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest version. Let us know if you encounter any other issue, we will be glad to look into it and help you further.

8

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

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