Adds freeze pane (non-scrollable columns/rows) to spreadsheet

spreadsheetAddFreezePane(spreadsheetObj, column, row [, endColumn] [, endRow]) → returns void

Argument Reference

spreadsheetObj variableName

Spreadsheet variable name

freezeColumn numeric

Amount of columns from left which should be freeze

freezeRow numeric

Amount of rows from top which should be freeze

hideColumn numeric

Amount of columns which should be hidden under/behind freeze columns (Scrolls left to first unhidden column).

hideRow numeric

Amount of rows which should be hidden under/behind freeze rows (Scrolls down to first unhidden row).

Sample code invoking the spreadsheetAddFreezePane function

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub