RadGridView.ExportToXlsx not compatible with OpenOffice

2 posts, 0 answers
  1. Michael
    Michael avatar
    1 posts
    Member since:
    Nov 2014

    Posted 04 Mar Link to this post

    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?

  2. Yoan
    Admin
    Yoan avatar
    1066 posts

    Posted 04 Mar Link to this post

    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
  3. UI for WPF is Visual Studio 2017 Ready
Back to Top