addFreezePane - cfsimplicity/spreadsheet-cfml GitHub Wiki

Locks or freezes rows or columns so that they remain visible when scrolling.

addFreezePane( workbook, freezeColumn, freezeRow[, leftmostColumn [, topRow ] ] )

Required arguments

  • workbook spreadsheet object
  • freezeColumn numeric: the number of the column to lock/freeze
  • freezeRow numeric: the number of the row to lock/freeze

Optional arguments

  • leftmostColumn numeric: left column to be visible in the right pane
  • topRow numeric: top row to be visible in the bottom pane

Chainable? Yes.

Notes

Use 0 for freezeColumn or freezeRow if you don't want a column or row to be locked.

Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
//Freezes the header row only
spreadsheet.addFreezePane( workbook,0,1 );