Huge font in Excel export

[Christian]

Hello,

 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:

PivotExportToExcelML excelExporter = new PivotExportToExcelML(rPVPanels);
excelExporter.ExportVisualSettings = true;
excelExporter.RunExport(TempFile);

(ExportVisualSetting true/false doesn't change anything)

 Can you confirm that and any plans on fixing this?

 

 

 

[Tapakah]

Hi.I am sorry that this topic, the issue of the topic :) Tell how to set parameters for all columns at export PivotExportToExcelML (width, stand, font) 

[Todor]

@ Christian,
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.

@ TaPaKaH,
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.

Regards,
Todor Vyagov
Telerik

[Tapakah]

I dont find RadSpreadProcessing in TelerikExport.dll

[Tapakah]

*PivotGridSpreadExport  in TelerikExport.dll

[Christian]

@Todor 

Ticket ID:989252

[Todor]

@TaPaKaH

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.

Regards,
Todor Vyagov
Telerik

[Tapakah]

@Todor Vyagov

thank you!!

" PivotGridSpreadExport is located in Telerik.WinControls.PivotGrid assembly"

FAQ

"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:
Telerik.WinControls.TelerikExport"

[Todor]

Hello TaPaKaH,

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.

Regards,
Todor Vyagov
Telerik

[Tapakah]

 @Todor Vyagov

:) Thanks, PivotGridSpreadExport export option is well suited and has good functionality for configuring