Huge font in Excel export

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

    Posted 18 Nov 2015 Link to this post

    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?

     

     

     

  2.
  3. Tapakah
    Tapakah avatar
    13 posts
    Member since:
    Apr 2014

    Posted 18 Nov 2015 Link to this post

    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) 
  5. Todor Vyagov
    Admin
    Todor Vyagov avatar
    36 posts

    Posted 19 Nov 2015 Link to this post

    @ 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
    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
  7. Tapakah
    Tapakah avatar
    13 posts
    Member since:
    Apr 2014

    Posted 19 Nov 2015 in reply to Todor Vyagov Link to this post

    I dont find RadSpreadProcessing in TelerikExport.dll
  8.
  9. Tapakah
    Tapakah avatar
    13 posts
    Member since:
    Apr 2014

    Posted 20 Nov 2015 in reply to Tapakah Link to this post

    *PivotGridSpreadExport  in TelerikExport.dll
  11. Christian
    Christian avatar
    44 posts
    Member since:
    May 2012

    Posted 20 Nov 2015 Link to this post

    @Todor 

    Ticket ID:989252

  13. Todor Vyagov
    Admin
    Todor Vyagov avatar
    36 posts

    Posted 23 Nov 2015 Link to this post

    @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
    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
  14.
  15. Tapakah
    Tapakah avatar
    13 posts
    Member since:
    Apr 2014

    Posted 23 Nov 2015 in reply to Todor Vyagov Link to this post

    @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"

  17. Todor Vyagov
    Admin
    Todor Vyagov avatar
    36 posts

    Posted 25 Nov 2015 Link to this post

    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
    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
  19. Tapakah
    Tapakah avatar
    13 posts
    Member since:
    Apr 2014

    Posted 25 Nov 2015 in reply to Todor Vyagov Link to this post

     @Todor Vyagov

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

  20.
Back to Top