Repeat column headings when printing

7 posts, 0 answers
  1. Richard
    Richard avatar
    7 posts
    Member since:
    Aug 2017

    Posted 23 Oct 2017 Link to this post

    Hi,

    In Excel there is a setting to set the rows that will repeat at the top of the grid on each page in Page Setup -> Sheet - Print Titles - Rows to repeat at top.

    I don't see how to do that in Telerik.Windows.Documents.Spreadsheet. Is it possible?

     

  2. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    863 posts

    Posted 25 Oct 2017 Link to this post

    Hi Richard,

    I am afraid, that the required functionality is not available for the Telerik UI for ASP.NET MVC Spreadsheet. In case you think, that such would add value to the widget, I would suggest you to log your idea as a feature request on our Feedback portal.

    Regards,
    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Richard
    Richard avatar
    7 posts
    Member since:
    Aug 2017

    Posted 25 Oct 2017 in reply to Veselin Tsvetanov Link to this post

    Wow, that's insane. That seems like it would be a V1 feature since it's existed in Excel since at least 2007. Who doesn't want repeating row headers when printing?

    Is there any way to add it myself, a way to manually edit the XML that the library generates? I don't have time to wait for possibly, maybe, sometime having it probably implemented. Otherwise, I'm going to have to find another Excel library that includes it.

  4. Richard
    Richard avatar
    7 posts
    Member since:
    Aug 2017

    Posted 25 Oct 2017 Link to this post

    Here's a request from April.

    http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/18957514-spreadsheet-mark-certain-columns-as-headers-that

  5. Richard
    Richard avatar
    7 posts
    Member since:
    Aug 2017

    Posted 25 Oct 2017 Link to this post

    And February: https://feedback.telerik.com/Project/184/Feedback/Details/212387-print-titles
    April 2016: https://feedback.telerik.com/Project/184/Feedback/Details/190066-spreadprocessing-repeat-specific-rows-or-columns-on-every-printed-page

     

  6. Richard
    Richard avatar
    7 posts
    Member since:
    Aug 2017

    Posted 25 Oct 2017 Link to this post

    Here it is implemented in EPPlus: https://github.com/JanKallman/EPPlus/blob/master/EPPlus/ExcelPrinterSettings.cs#L552
  7. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    863 posts

    Posted 27 Oct 2017 Link to this post

    Hi Richard,

    I am afraid, that at this stage manually adding headers to the exported pages would not be possible.

    As you have noticed, other developers are also interested in the discussed functionality. Therefore, I would suggest you to cast your vote for the feature request in the Kendo Feedback portal. Based on the support it receives from the community, we will decide on whether to proceed with its implementation or not.

    Note, that our roadmap and priorities depend largely on the business value and customer demand for specific components and features. However, I would like to present you an offering that may be relevant and applicable to your needs - our Feature Acceleration program. It allows a customer to negotiate a certain component or functionality to be implemented on demand or sooner than our roadmap implies. Feature acceleration fits well in scenarios where a feature or enhancement is important for an application's success, but it is not planned to be available at the time of the application's completion.

    Let me know if you are interested in pursuing this option at any time and I will put you in touch with our Professional Services team to discuss your exact specifications and possible timeframes.

    Regards,
    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top