Header and Footer in Download Telerik to Excel

2 posts, 0 answers
  1. Julian
    Julian avatar
    1 posts
    Member since:
    Feb 2015

    Posted 23 Aug 2016 Link to this post


    Hello, i'm new in telerik. I want to ask, why when i download the Telerik Reporting (R2 2016) to Excel the header and footer in print preview is just in page 1?

    I'm using "Page Header" and "Page Footer" to set header and footer in telerik, when i download in PDF its fine, the header show in every page in print preview. Why just in Excel i cant see the header and footer in the every page?

    Best Regards,

    Julian Agam Riantiadi

  2. Rick
    Rick avatar
    14 posts

    Posted 23 Aug 2016 Link to this post

    Hello Julian,

    What you are seeing is the expected behavior. Excel isn't a page-orientated format. Excel treats documents as one long continuous page. As a result, we implement Page Headers as a Frozen Row by default. You can override this behavior and use Excel's Native Page Headers in the Excel Device Information Settings by changing the UseNativePageHeader property to true.

    Additional resources on this subject:

    Telerik by Progress
    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