SpreadsheetAddFreezePane

Adds freeze pane to a spreadsheet.

Method Signature

SpreadsheetAddFreezePane(spreadsheetObj=[any], column=[any], row=[any], endColumn=[any], endRow=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
column	NUMERIC	true	The column boundary of the freeze pane (columns to the left are frozen).
row	NUMERIC	true	The row boundary of the freeze pane (rows above are frozen).
endColumn	NUMERIC	false	An additional column to be included in the freeze pane (optional).
endRow	NUMERIC	false	An additional row to be included in the freeze pane (optional).

Examples

Freeze panes in spreadsheet:

// Freeze header row
var spreadsheet = SpreadsheetNew();
SpreadsheetAddRow( spreadsheet, [ "Name", "Email", "Phone" ] );
// Add many more rows...

SpreadsheetAddFreezePane( spreadsheet, 2, 1 );  // Freeze row 1

Related

• SpreadsheetAddAutofilter() - Add filter

• SpreadsheetSetActiveCell() - Set active cell