Excel Page Width

6 posts, 0 answers
  1. Mohsin
    Mohsin avatar
    2 posts
    Member since:
    Jul 2014

    Posted 03 Mar 2015 Link to this post

    There is a setting in page layout where you can set the page width from automatic to 1 page, 2 page. Can we use this feature while exporting the telerik report to excel. This will enable the report to be printed on a single page.
  2. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 06 Mar 2015 Link to this post

    Hello Mohsin,

    Telerik reports are rendering in Excel format based on the Design Considerations for Excel Rendering article. The Excel renderer is a logical layout renderer, which purpose is to put data with formatting close to the visualized in the report's interactive preview. The available settings for the renderer are listed here.

    Controlling the print settings from Excel is not supported, instead you can test using PDF format.
    In PDF there is a Javascript device setting allowing you to inject functionality in the document, which will be interpreted by the PDF reader. You need to set the report's PageSettings to a custom page format and size the physical page to gather the reports content. And export the report with injected a Javascript as in this code library post, which will force the PDF reader displaying the produced file to open its Print Dialog. Then the user can select the Adobe Print Dialog's Fit option (if not selected), which will use the Adobe Reader's resizing capabilities to gather the document on a single page.


    Let us know if you have any further questions.

    Regards,
    Stef
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. Moe
    Moe avatar
    24 posts
    Member since:
    Jan 2018

    Posted 21 Nov 2018 in reply to Stef Link to this post

    Hi Stef,

    I would like to know until the logic not change? My problem also same Mohsin what he wants.

     

    Thanks

    Moe

  4. Silviya
    Admin
    Silviya avatar
    422 posts

    Posted 22 Nov 2018 Link to this post

    Hello Moe,

    Only in in PDF there is a Javascript device setting allowing you to inject functionality in the document, which will be interpreted by the PDF reader.
    In Excel (and other formats), you will have to manually configure the document or select proper Report.PageSettings (PaperSize, Margins, Landscape).

    Regards,
    Silviya
    Progress 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
  5. Moe
    Moe avatar
    24 posts
    Member since:
    Jan 2018

    Posted 22 Nov 2018 Link to this post

    HI Silviya,

    But still 2 pages . May I know do you have control of  'Fit Sheet On Page' for excel?

     

    Thanks

    Moe

  6. Silviya
    Admin
    Silviya avatar
    422 posts

    Posted 26 Nov 2018 Link to this post

    Hi Moe,

    By design the exported Excel file is configured to use the default scaling option which happens to be No Scaling. The export to Excel settings do not expose an option to change this configuration to Fit Sheet on One Page at the moment. You can request such feature in the Ideas & Feedback portal.

    Regards,
    Silviya
    Progress 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
Back to Top