Telerik report. Export to Excel 2007 (10). "Rows to repeat at top".

9 posts, 2 answers
  1. Andrey
    Andrey avatar
    14 posts
    Member since:
    Sep 2010

    Posted 21 Sep 2011 Link to this post

    Hello,

      I use "ColumnHeadersPrintOnEveryPage" setting to repeat column headers on each page in the report.
      It sucessfully works when I export the report to PDF or Word, but unfortunately does not work when I export it into Excel.
      
      Is it possible to mark some rows in the report do be repeated on each page in Excel during exporting to excel (see picture)?

    Thanks,
    -Andrey Popov
  2. Answer
    Steve
    Admin
    Steve avatar
    10941 posts

    Posted 21 Sep 2011 Link to this post

    Hi Andrey,

    The following rendering extension categorization shows how supported extensions vary:

    • Data rendering extensions: CSV
    • Logical page layout rendering extensions: HTML, Excel
    • Physical page layout rendering extensions: Image, PDF, RTF, XPS, PPTX, DOCX
    So as you see, Excel is not a page oriented format and is indefinite by width and height. When printing from excel, it is the program that handles the excel file that separates the content into logical pages. We have no control over that.

    Kind regards,
    Steve
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  3. Andrey
    Andrey avatar
    14 posts
    Member since:
    Sep 2010

    Posted 22 Sep 2011 Link to this post

    Hello Steve,

      Thanks for your reply.

      Are You going to implement this functionallity in the future, for example using "Excel Device Information Settings" (http://www.telerik.com/help/reporting/programmatic-exporting-report.html)?

      Something like that:  
      var deviceInfo = new Hashtable();
      deviceInfo.Add("RowsToRepeatAtTop", "$1:$2");

    Thanks,
    -Andrey Popov
  4. Answer
    Steve
    Admin
    Steve avatar
    10941 posts

    Posted 22 Sep 2011 Link to this post

    Hi Andrey,

    Feature request implementations are based on number of inquiries from users. The higher the interest in some functionality, the bigger the chances are that we are going to implement it in subsequent versions. At this time you are the second person who has requested this functionality and this feature is with low priority in our tasks.

    Kind regards,
    Steve
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  5. Teddy
    Teddy avatar
    3 posts
    Member since:
    Dec 2011

    Posted 22 Dec 2011 Link to this post

    hi,
    I would like to know if you implement this functionallity ( Rows to repeat at top) ?
    thanks
  6. Sathya
    Sathya avatar
    1 posts
    Member since:
    Jan 2014

    Posted 03 Jan 2014 Link to this post

    Hi,

     I'm rendering the report with Excel format. I have use the property "Rows to repeat at top". Its not working. Is this feature is implemented?

    Thanks!
  7. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 06 Jan 2014 Link to this post

    Hello Sathya,

    Currently we do not support such feature. You will have to apply the setting through MS Office, use additional libraries to set the worksheets printer settings through code, or use other physical page layout rendering extensions, where the desired functionality exists.

    Regards,
    Stef
    Telerik

    New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

  8. Stephen McDaniel
    Stephen McDaniel avatar
    48 posts
    Member since:
    Mar 2008

    Posted 21 Jan 2015 Link to this post

    I would also love the ability to specify a "Rows To Repeat At Top" setting that flows through to the exported Excel file.
  9. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 24 Jan 2015 Link to this post

    Hi Stephen,

    Thank you for your feedback.

    Please use the public feedback portal to add your feature requests. Based on the demand for a feature, it is considered for implementation.

    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.

     
Back to Top