ODS to XLSX - circular graph loses content

Aspose.Cells Product Family
1

Using aspose-cells-18.11 JDK to convert ODS to XLSX.
Converting spreadsheet with a circular graph. The bars disappear.

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

Before/after sample attached
Donut chart colours wrong.zip (47.2 KB)

2

@simon.wiseman,

Thanks for the template ODS file and output XLSX file.

After an initial test, I am able to observe/confirm the issue as you mentioned by converting your template ODS file to XLSX file format. I have logged a ticket with an id “CELLSJAVA-42787” for your issue. The ticket is logged as following:
CELLSJAVA-42787 - ODS to XLSX - circular graph loses content

We will look into it soon.

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

3

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

4

@simon.wiseman,

@hucq_landray_com_cn,

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)

5

The circular graphs are preserved, however they are a different type of graph. The colours aren’t the same in the graphs and they look different when comparing the ODS graph with the XLSX (see attached files).

To open the ODS file I used OpenOffice Calc and to open the XLSX file I used Microsoft Excel 2019.

Using aspose-cells-19.10.jar.

Using the following 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);

CELLSJAVA-42787.zip (47.1 KB)

6

@simon.wiseman,

Thanks for the template ODS file and output XLSX file.

After an initial test, I am able to observe/confirm the issue (ODS to XLSX - circular graph colors are not the same) as you mentioned by converting your template ODS file to XLSX file format. I have logged a ticket with an id “CELLSJAVA-43049” for your issue. The ticket is logged as following:
CELLSJAVA-43049 - ODS to XLSX - circular graph colors are not the same

We will look into it soon.

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

7

Great, thank you.

8

@simon.wiseman,

You are welcome.