addSplitPane

Splits a worksheet into 4 separate panes

addSplitPane( workbook, xSplitPosition, ySplitPosition, leftmostColumn, topRow[, activePane ] )

Required arguments

• workbook spreadsheet object
• xSplitPosition numeric: Specifies the x-axis position of the first quadrant. The x-position value is 1/20th the value of a pixel in the worksheet.
• ySplitPosition numeric: Specifies the y-axis position of the first quadrant. The y-position value is 1/20th the value of a pixel in the worksheet.
• leftmostColumn numeric: left column to be visible in the second quadrant
• topRow numeric: top row to be visible in the third quadrant

Optional arguments

• activePane string default="UPPER_LEFT": Valid values are "LOWER_LEFT", "LOWER_RIGHT", "UPPER_LEFT", and "UPPER_RIGHT"

Chainable? Yes.

Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.addSplitPane( workbook,1000,1000,5,5 );