ODS to XLSX - text colour changed

Aspose.Cells Product Family
1

Using aspose-cells-18.11 JDK to convert ODS to XLSX.
Converting spreadsheet with white text having black background. The text colour changes to black, so the text “disappears”.

Code below:
LoadOptions loadOptions = new LoadOptions(FileFormatType.ODS);
Workbook workbook = new Workbook(inputPath,loadOptions);
workbook.save(outputPath, SaveFormat.XLSX);

Before/after sample attached

Missing text.zip (13.9 KB)

2

@simon.wiseman,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42794 - ODS to XLSX - text colour changed
3

@simon.wiseman,

We evaluated your issue further. The color of the text is automatic, the color will be auto changed when the background color is changed. But MS Excel does not support this aspect. We have to calculate the color of the text to implement this feature by ourselves. We will do that to figure out the issue.

4

@simon.wiseman,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

5

@simon.wiseman,

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

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells for Java_v18.12.9.zip (6.4 MB)

6

The issues you have found earlier (filed as CELLSJAVA-42794) have been fixed in Aspose.Cells for Java 19.1. You can also get the latest Aspose.Cells for Java version from Maven repos. with simple configurations. Please see the document for your reference: Installation|Documentation

This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

7

All works, thanks.

8

@simon.wiseman,

Good to know that your issue is sorted out by the latest version/fix (as suggested). Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.