Free Support Forum - aspose.com

ODS to XLSX - graph data selection changes


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