since the second last update (2015-3-930 and including the latest update 2015-3-1104) the font in the excel export is huge (font size 400something). In "PivotExportToExcelML" there are some changes regarding font/font size (in "CreateStyleElement"). The code hasn't changed and is very simple:
(ExportVisualSetting true/false doesn't change anything)
Can you confirm that and any plans on fixing this?
9 Answers, 1 is accepted
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.
PivotGridSpreadExport is located in Telerik.WinControls.PivotGrid assembly. As you mentioned your project also needs to have reference to the TelerikExport assembly, which contains exporting logic.
More information can be found here: PivotGridSpreadExport | UI for WinForms Documentation
Should you have any other questions, do not hesitate to contact us.
" PivotGridSpreadExport is located in Telerik.WinControls.PivotGrid assembly"
"The spread export functionality is located in the TelerikExport.dll assembly. You need to include the following namespace in order to access the types contained in TelerikExport:
Thank you for writing back.
Note that Telerik.WinControls.PivotGrid contains the RadPivotGrid and all its components as well as PivotGridSpreadExport. TelrikExport makes the connection between PivotGrid and SpreadProcessing libraries and this is why you need to add it as a reference in your project.
If you have any additional questions, please let me know.
:) Thanks, PivotGridSpreadExport export option is well suited and has good functionality for configuring