I can confirm that since Q3 2015 WinForms release PivotExportToExcelML
fonts exporting is changed, in order to fix this issue
and now all RadPivotGrid
fonts should be correctly exported. So make sure your pivot grid does not contain cells with such a big font size and if the experienced issue still persists, please open a support ticket (which is private communication channel) and send us a sample project where the issue can be reproduced so we can investigate the precise case. Thank you in advance.
When exporting with PivotExportToExcelML you can customize the visual style of cells on the PivotExcelCellFormatting event. Unfortunately, the column widths cannot be changed during the export, also the width of RadPivotGrid columns is not taken under consideration when exporting. I have logged these two issues in our feedback portal
. You can track their progress, subscribe for status changes and add your vote/comment on the following links:
- FIX. RadPivotGrid - when exporting to excel with PivotExportToExcelML column widths are not correct.
- FIX. RadPivotGrid - when exporting to excel with PivotExportToExcelML the worksheet cannot be customized.
I have also updated your Telerik points
Instead, you can use PivotGridSpreadExport
, which utilizes our RadSpreadProcessing
libraries and allows a lot of customizations to the exported worksheet.
I hope this information helps.
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