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

PivotExportToExcelML RowHeadersLayout

1 Answer 17 Views
PivotGrid and PivotFieldList
This is a migrated thread and some comments may be shown as answers.
Christian
Top achievements
Rank 1
Christian asked on 08 Mar 2018, 08:33 AM

Hello,

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.

Christian

XML-FEHLER in Tabelle
GRUND:  Ung├╝ltiger Wert
DATEI:  C:\Users\...\Test.xls
GRUPPE: Table
TAG:    Column
ATTRIBUT:   Width
WERT:   -20

1 Answer, 1 is accepted

Sort by
0
Hristo
Telerik team
answered on 08 Mar 2018, 02:47 PM
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 Xlsx format. This approach is the preferred way to export the control. 

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

Regards,
Hristo
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.
Tags
PivotGrid and PivotFieldList
Asked by
Christian
Top achievements
Rank 1
Answers by
Hristo
Telerik team
Share this question
or