ODS to XLSX - fontwork is lost

Aspose.Cells Product Family
1

Using aspose-cells-18.11 JDK to convert ODS to XLSX.
Converting spreadsheet with a fontwork (SmartArt) object. The fontwork is replaced by a rectangle.

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

Before/after sample attached

Missing Fontwork.zip (209.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-42793 - ODS to XLSX - fontwork is lost

3

@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)

4

This is still an issue the fontwork is still replaced by a black box when its converted from ODS to XLSX.

Using this code:
com.aspose.cells.LoadOptions loadOptions = new com.aspose.cells.LoadOptions(com.aspose.cells.FileFormatType.ODS);
com.aspose.cells.Workbook workbook = new com.aspose.cells.Workbook(inputPath,loadOptions);
workbook.save(outputPath, com.aspose.cells.SaveFormat.XLSX);

Using aspose-cells-19.10.jar.

CELLSJAVA-42793.zip (212.7 KB)

5

@simon.wiseman,

Thanks for the sample ODS file and output XLSX.

You are right, I tested and confirmed the issue using your provided file. The smart art shape is replaced with black rectangle. Your issue is still Open, so hopefully, we will figure it out not so soon though.

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

6

Great, thanks.

7

@simon.wiseman,
You are welcome.

8

@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.

9

That’s great, thank you.

10

@simon.wiseman,
Please try our latest version/fix: Aspose.Cells for Java v19.11.7 (attached)

aspose-cells-19.11.7.zip (6.7 MB)

Your issue should be fixed in it.

Let us know your feedback.

11

Thanks this fix works, the SmartArt now appears in the document using the “aspose-cells-19.11.7” version.

However in the XLSX file when you highlight the SmartArt there isn’t any font style, its just blank.
image.png (20.5 KB)

Whereas in the ODS file it has “Arial black” font style.
image.png (21.3 KB)

MissingFontwork2.zip (210.0 KB)

12

@simon.wiseman,
Thank you for the feedback. We have observed the missing font issue and have reopened the ticket for further investigation. We will write back here once any update is ready to share.

13

Many thanks.

14

@simon.wiseman,

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

15

The issues you have found earlier (filed as CELLSJAVA-42793) have been fixed in Aspose.Cells for Java v19.12. This message was posted using Bugs notification tool by ahsaniqbalsidiqui