Free Support Forum -

ODS to XLSX - graph data selection changes


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);, SaveFormat.XLSX);

Before/after sample attached

lost graph (23.7 KB)



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.



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.



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 (6.4 MB)