ColdFusion 9.0 Resources |
SpreadsheetAddFreezePaneDescriptionLocks or freezes specific rows or columns in the worksheet. ReturnsDoes not return a value. CategoryMicrosoft Office Integration Function syntaxSpreadsheetAddFreezePane(spreadsheetobj, freezcol, freezrow[, col, row]) See alsoSpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow, SpreadsheetDeleteRow, SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftRows HistoryColdFusion 9: Added the function. Parameters
UsageYou can keep an area of the worksheet visible while scrolling to another area of the worksheet by freezing panes. When you freeze a pane, you lock or freeze specific rows and columns in the worksheet. The rows and columns that are frozen in the worksheet are indicated by a solid line. Note: You cannot split the pane into two
worksheet areas.
ExampleThe following example freezes the spreadsheet at column 3 and row 2 of the worksheet. SpreadSheetAddFreezePane(SpreadsheetObj,3,2); The
following example freezes the spreadsheet at column 3 and row 2,
and hides data in column 4 and rows 3 to 10.
SpreadSheetAddFreezePane(SpreadsheetObj,3,2,5,10); |