setActiveCell - cfsimplicity/spreadsheet-cfml GitHub Wiki

Sets the cell to be active (focused) when the spreadsheet is opened.

setActiveCell( workbook, row, column )

Required arguments

  • workbook spreadsheet object
  • row numeric
  • column numeric

Chainable? Yes.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.addColumn( workbook , "1,1" );//add 2 rows
spreadsheet.setActiveCell( workbook, 2, 1 );// set focus on the first cell in the second row when the spreadsheet is opened