Issues when you export the report in Excel

2 posts, 0 answers
  1. Bharat
    Bharat avatar
    10 posts
    Member since:
    Feb 2019

    Posted 14 May Link to this post

    Hello Everyone,
    I am using Telerik Standalone Report designer.
    I have following issues regarding export to excel.
    1. Padding is not working in Excel.
    2. Text color set through HTMLBox is not working in excel.
    3. Page layout is not working  as PDF.(I can print report from PDF in one Landscape page but from excel it will expand columns so it will not fit in one Landscape page )

    in attached Excel screenshot you can see the Padding issue in right and Left side and also text color issue.
    PDF screenshot is perfect.

    Please reply if you have any Solutions related this issues.
  2. Neli
    Admin
    Neli avatar
    172 posts

    Posted 16 May Link to this post

    Hi Bharat,

    The Excel Rendering Extensions tries to reproduce as much of the original report as possible regarding layout and styling. However, there are some limitations.

    1. Padding is not working in Excel.
    This is correct, the export to Excel does not support padding of the items. You may use TextAlign property instead.

    2. Text color set through HTMLBox is not working in excel.
    Note that the HtmlTextBox is rendered as plain text with no formatting.

    3. Page layout is not working  as PDF.(I can print report from PDF in one Landscape page but from excel it will expand columns so it will not fit in one Landscape page)
    The entire report is rendered into a single Excel worksheet and there is no paging when exporting to Excel.

    If it is possible you can send us the report, so we can test it locally to see if there is something wrong.

    For more information, please, refer to Design Considerations for Excel Rendering article.

    Regards,
    Neli
    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