ODS to XLSX - graph data selection changes

Aspose.Cells Product Family
1

Using aspose-cells-18.11 JDK to convert ODS to XLSX.
Converting spreadsheet with a graph. The graphs data area changes, so some columns are not rendered.

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

Before/after sample attached

lost graph columns.zip (23.7 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-42791” for your issue. The ticket is logged as following:
CELLSJAVA-42791 - ODS to XLSX - graph data selection changes

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,

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

All fixed, thanks.

6

@simon.wiseman,

Good to know that your issue is sorted out by the suggested version/fix. 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.