PivotExportToExcelML RowHeadersLayout

2 posts, 0 answers
  1. Christian
    Christian avatar
    44 posts
    Member since:
    May 2012

    Posted 08 Mar 2018 Link to this post


    Exporting a PivotGrid with RowHeadersLayout set to "Compact" results in an invalid XLS file.

    The first column has an negative width. Which results in an Excel error while opening the xls file.


    XML-FEHLER in Tabelle
    GRUND:  Ungültiger Wert
    DATEI:  C:\Users\...\Test.xls
    GRUPPE: Table
    TAG:    Column
    ATTRIBUT:   Width
    WERT:   -20
  2. Hristo
    Hristo avatar
    1522 posts

    Posted 08 Mar 2018 Link to this post

    Hello Christian,

    Thank you for writing.

    Indeed, the Compact layout type will result in an invalid width for the first column in the exported file. The issue is not reproducible with the PivotGridSpreadExport class. This object utilizes the RadSpreadProcessing libraries and exports natively in the .Xlsx format. This approach is the preferred way to export the control. 

    I hope this helps. Let me know if you have other questions.

    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top