This is a migrated thread and some comments may be shown as answers.

Excel Page Width

5 Answers 95 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mohsin
Top achievements
Rank 1
Mohsin asked on 03 Mar 2015, 02:48 PM
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.

5 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 06 Mar 2015, 10:20 AM
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.

 
0
Moe
Top achievements
Rank 1
Iron
Iron
Veteran
answered on 21 Nov 2018, 08:39 AM

Hi Stef,

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

 

Thanks

Moe

0
Silviya
Telerik team
answered on 22 Nov 2018, 01:58 PM
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
0
Moe
Top achievements
Rank 1
Iron
Iron
Veteran
answered on 23 Nov 2018, 02:46 AM

HI Silviya,

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

 

Thanks

Moe

0
Silviya
Telerik team
answered on 26 Nov 2018, 02:57 PM
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
Tags
General Discussions
Asked by
Mohsin
Top achievements
Rank 1
Answers by
Stef
Telerik team
Moe
Top achievements
Rank 1
Iron
Iron
Veteran
Silviya
Telerik team
Share this question
or