ColdFusion 9.0 Resources |
SpreadsheetAddSplitPaneDescriptionSplits panes into four separate worksheet areas. ReturnsDoes not return a value. CategoryMicrosoft Office Integration Function syntaxSpreadsheetAddSplitPane(spreadsheetobj, x-position, y-position, splitcol, splitrow [,position]) See alsoSpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow, SpreadsheetDeleteRow, SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftRows HistoryColdFusion 9: Added the function. Parameters
UsageYou
can split the pane into four worksheet areas in the spread sheet.
The split is applied at the pixel level. You can adjust the worksheet
area by dragging the split bar, as required.
Note: You cannot split
the pane into two worksheet areas.
ExampleThe
following example splits the spreadsheet into four quadrants. The
x and y positions are at 2000 and 2000 values. Column 5 of the spreadsheet
appears in quadrant 2; and row 7 of the spreadsheet appears in quadrant
7. The split bar appears at the lower left side of the spreadsheet.
SpreadSheetAddSplitPane(spreadsheetobj, 2000, 2000, 5, 7, LOWER_LEFT ); |