Excel file with pivot table corrupt


#1

(I tested Aspose.Cells for Java v17.12.2 and i still see problems)
i uploaded a file called orig.xlsb , it contains a pivot table.
after saving it as name converted.xlsb
i get several error message and also the data is corrupted and not like the original file

please fix this so we can support pivot tables

thanks
Dov
Datarails (paying acount)

unnamed.png (6.7 KB)
unnamed.png (6.7 KB)
Downloads.zip (2.7 MB)


#2

@turaaa

Thanks for using Aspose APIs.

We were able to observe this issue in the output Excel file using the following code and found, output Excel file gets corrupt after opening and re-saving the input Excel file.

Download Link:
output-17.12.3.zip (1.2 MB)

This issue has been logged as

  • CELLSJAVA-42489 - XLSB file gets corrupt after opening and saving

Java

Workbook wb = new Workbook(dirPath + "orig.xlsb");
wb.save(dirPath + "output-" + CellsHelper.getVersion() + ".xlsb");

#3

any news with this?

thanks
Dov


#4

@turaaa

Thanks for using Aspose APIs.

We are afraid there is no update for you at this moment regarding this issue. However, we have logged your comment in our database against this issue and requested the product team to provide some fix or ETA for this issue. Once there is some news for you, we will update you asap by posting in this topic.


#5

@turaaa,

We are working over your issue and hopefully, your issue should be fixed by January 10, 2018.

Keep in touch.


#6

@turaaa

Thanks for using Aspose APIs.

This is to inform you that we have fixed your issue CELLSJAVA-42489 now. We will soon provide the fix after performing QA and including other enhancements and fixes.


#7

@turaaa

Please download and try the following fix and let us know your feedback.


#8

The issues you have found earlier (filed as CELLSJAVA-42489) have been fixed in this Aspose.Cells for Java 18.1 update.

Please also check the following document/blog for your reference: