This is a migrated thread and some comments may be shown as answers.

RadGridView.ExportToXlsx not compatible with OpenOffice

1 Answer 23 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Michael
Top achievements
Rank 1
Michael asked on 04 Mar 2016, 10:49 AM

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

Sort by
0
Yoan
Telerik team
answered on 04 Mar 2016, 01:07 PM
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
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
Tags
GridView
Asked by
Michael
Top achievements
Rank 1
Answers by
Yoan
Telerik team
Share this question
or