addSplitPane - cfsimplicity/spreadsheet-cfml GitHub Wiki

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 );