I'm using the RadGridView.ExportToXlsx() to export my grid to an Excel (.xlsx) file. The exported File works perfectly in Excel 2016, but in OpenOffice (Apache_OpenOffice_4.1.2_Win_x86_install_de) I get the error "Wrong Format".
The only workaround is to open the exported file in Excel and save it. After that the file can be opened in OpenOffice.
I can reproduce the error with the WPF Controls Examples Q1 2016 SP1 (Exporting to Xlsx and Pdf fromats).
Is there any way to solve this?
1 Answer, 1 is accepted
0
Hi Michael,
Actually, this is known limitation. Here is a link to the public item logged into our Feedback portal:
OpenXML documents exported with DPL cannot be imported with OpenOffice and on MAC (Numbers and Pages)
The issue is in the relationships parts, relationship element. The Target attribute can be either a URI (Target="/word/theme/theme1.xml") or a relative reference (Target="theme/theme1.xml") as stated in Ecma Office Open XML Part 2 - Open Packaging Conventions. The DPLs use URI (while Word and Excel use relative references), which OpenOffice is unable to interpret, despite them being allowed by the specification.
Regards,
Yoan
Telerik
Actually, this is known limitation. Here is a link to the public item logged into our Feedback portal:
OpenXML documents exported with DPL cannot be imported with OpenOffice and on MAC (Numbers and Pages)
The issue is in the relationships parts, relationship element. The Target attribute can be either a URI (Target="/word/theme/theme1.xml") or a relative reference (Target="theme/theme1.xml") as stated in Ecma Office Open XML Part 2 - Open Packaging Conventions. The DPLs use URI (while Word and Excel use relative references), which OpenOffice is unable to interpret, despite them being allowed by the specification.
Regards,
Yoan
Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items