Free Support Forum - aspose.com

ODS to XLSX - Aspose produces a broken file that has to be repaired

When converting an ODS to XLSX, Aspose produces a broken XLSX file that needs to be repaired when opened in Excel. After repairing the XLSX file, content is missing from the spreadsheet, such as graphs.

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

Using aspose-cells-20.6.4.jar

Original and “after Aspose” files attached here:
RepairXLSX.zip (287.7 KB)

@simon.wiseman,
I have tried to convert this with MS Excel but this dialog box appears. Excel.PNG (3.3 KB)

The output xlsx created by Excel looks same as the output created by Aspose.Cells. So this looks like limitation of ODS to Excel conversion.

I am using “Microsoft Excel 2019 MSO (16.0.13001.20266) 32-bit” and I get a repair dialog pop-up when I open the XLSX file (see attached screenshot).
Please can you clarify when version of Excel you were using please. Thank you.
repair.PNG (3.1 KB)

@simon.wiseman,
I have tested it with MS Excel for office 365 MSO (16.0.11929.20836) 32-bit.

What is happening in regards to this case? Is a fix being looked at for it? Thanks.

@simon.wiseman,
No further investigation is done in this regard as it was informed earlier that even MS Excel is not able to convert it properly and charts are missing in the output. The same output is generated by Aspose.Cells, therefore it does not seem to be an issue. Please share some sample ODS file which is converted fine by MS Excel. We will try the sample file with Aspose.Cells and share our feedback.