Spreadsheet - Freezing Top Row

2 posts, 0 answers
  1. Brandon
    Brandon avatar
    2 posts
    Member since:
    Jul 2012

    Posted 28 Jul 2016 Link to this post

    Is there a way to via server-side or client side to freeze the top row of headers?
  2. Ivan Danchev
    Ivan Danchev avatar
    1630 posts

    Posted 02 Aug 2016 Link to this post

    Hello Brandon,

    The SpreadsheetSheet object exposes the set_frozenRows() client-side method, which accepts int and will freeze the number of rows specified starting from row 1. For example if you want to freeze the first row you can pass 1 to the method (as shown in the code snippet below), if you want the Sheet's first three rows frozen you pass 3:
    function pageLoad() {
        var spreadsheet = $find("<%=RadSpreadsheet1.ClientID%>");
        var activeSheet = spreadsheet.get_activeSheet();

    You can find the set_frozenRows() an other important SpreadsheetSheet object methods in the following documentation article.

    Ivan Danchev
    Telerik by Progress
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top