Repeat column headings when printing

[Richard]

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?

 

[Veselin Tsvetanov]

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

[Richard]

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.

[Richard]

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

[Richard]

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

 

[Richard]

Here it is implemented in EPPlus: https://github.com/JanKallman/EPPlus/blob/master/EPPlus/ExcelPrinterSettings.cs#L552

[Veselin Tsvetanov]

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