Converted to xml ods file does not pass xml validation

Aspose.Cells Product Family
1

Hi,

We are converting the ODS file SAU Rapporter.zip (65.2 KB) to SpreadsheetML format using Aspose.Cells 17.12 and next simple code:
using (var workbook = new Workbook(inputFilePath))
{
workbook.Save(outputFilePath, SaveFormat.SpreadsheetML);
}
The result file SAU Rapporter.xml.zip (23.1 KB) does not pass XML validation because it contains XML element with double prefix: <o:meta:generator>.

Best regards
Valeriy

2

@uaprogrammer

Thanks for using Aspose APIs.

We were able to observe this issue and logged it in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45837 - Spreadsheet XML gets invalidated because it contains elements with double prefix e.g. <o:meta:generator> etc.

C#

Workbook wb = new Workbook("SAU Rapporter.ods");
wb.Save("output.xml", SaveFormat.SpreadsheetML);

We found the following line invalidates the XML.

<o:meta:generator>NeoOffice/3.0.2$Unix OpenOffice.org_project/Patch 0</o:meta:generator>

3

@uaprogrammer,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-45837”) now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4

@uaprogrammer

Thanks for using Aspose APIs.

Please download and try the following fix and let us know your feedback.

5

The issues you have found earlier (filed as CELLSNET-45837) have been fixed in this Aspose.Cells for .NET 18.1 update.

Please also check the following article: