Spreadsheet - Freezing Top Row

[Brandon]

Is there a way to via server-side or client side to freeze the top row of headers?

[Ivan Danchev]

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();
    activeSheet.set_frozenRows(1);
}

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

Regards,
Ivan Danchev
Telerik by Progress