XLSB tabs losing colors

Aspose.Cells Product Family
1

Hi Aspose,


After merely saving the Excel .xlsb file with Aspose.Cells 8.4.2 for Java, the tabs are losing all of their original colors. See attachment for screenshot and the .xlsb file which can reproduce this problem.

// Open Excel file.
final Workbook workbook = new Workbook(“C:\Temp\ColorTabs.xlsb”);

// Save Excel file.
workbook.save(“C:\Temp\ColorTabs_out.xlsb”);

Interestingly, if the original file is .xlsm, the colors are retained.

Please advise how we can resolve this issue. Thanks.
2

Hi Simon,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for Java 8.4.2.7, and we are able see the problem. The tab colors seem not to retain while re-saving your provided XLSB with v8.4.2.7. We have logged this incident in our bug tracking system under the ticket CELLSJAVA-41379 for further investigation & correction purposes. please spare us little time to isolate the problem cause, and provide a fix, In the meanwhile, we will keep you posted with updates in this regard.
3

Hi again,


This is to inform you that we have fixed the problem logged earlier as CELLSJAVA-41379. We will shortly provide the fix here after performing quality assurance and incorporating other enhancements.

Thank you for your patience.
4

Hi,


Please try our latest version/fix: Aspose.Cells for Java v8.5.0.2 (attached).

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

Let us know your feedback.

Thank you.
5

Yes, v8.5.0.2 has fixed the issue. The tab colors are now retained.


However v8.5.0.2 is causing a CellsException regarding “more than one token in stack”. I have created another topic about it.

Thanks.

6

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your previous issue is resolved. We will check your next issue in your other thread and update you there.

7

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

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