Hello Colleagues,
We run into the unpredictable to us behaviour during rendering report into the Excel format (the PDF looks like fine).
The vertical page breaks is appeared and splits the page content but all properties related to the layout and element dimensions were configered properly for our opinion.
Shortly,
1)page setting is set up as: A4 (210 x 297 mm), Portrait, Margings Left/Right = 2 / 1 cm, width of detailSection 18cm
2)The content: one table with total widht 18 cm
Result of rendering to the Excel: 2 pages with vertical splits the table.
Table width = detailSection width (180mm). detailSection width(180) + Left/Right margins(20/10) = A4 width (210) = 210 mm
The mail question here is Why?
During some experiments we found that the result of page rendering into the Excel doesn't have any vertical breaks if content in the sectionDetails is not closer to the right edge of report layout then 13mm.
Could you help with understanding the rendering mechanism to the Excel format?
How properly placing the report elemets on the layout to avoiding vertical page breaking the Excel result?
Screenshots was attached. The archive (rar or zip) of template and excel results I couldn't attached
Thank in advance
Best,
Alex
1 Answer, 1 is accepted
Hello Alex,
Thank you for the attached screenshots and the additional information!
The page layout in Excel depends on the selected printer and its DPI settings, so additional automatic page breaks may appear when printing the document or viewing it in the "Page Break Preview" view mode.
To ensure the uniform look of the printed document, please check the Scaling options in Excel's Page Layout view. You may have a look at the Scale a worksheet - Microsoft Support article for instructions on how to scale the worksheet to a single page. For example:
For more information about the Excel rendering, you may have a look at the Excel Rendering Design Considerations at a glance - Telerik Reporting article.
Please let me know if I can help with anything else.
Regards,
Dimitar
Progress Telerik
Rank 1
Hello Dimitar,
Thaks a lot for your response.
I expected like that, but thought that exists something in render configuration that could impact on page breaking
Thanks,
Best,
Alex