collapseColumnGroup - cfsimplicity/spreadsheet-cfml GitHub Wiki

Visually collapses a set of previously grouped columns. Unliked hidden columns, collapsed columns can be expanded easily by the user in the UI.

collapseColumnGroup( workbook, column )

Required arguments

• workbook spreadsheet object
• column numeric: any column in the group

Chainable? Yes.

Examples

spreadsheet = New spreadsheet();
workbook = spreadsheet.newXlsx();
rowData = [ "column1", "column2", "column3", "column4" ];
spreadsheet
  .addRows( workbook, [ rowData, rowData, rowData, rowData ] );//add a 4x4 dataset
  .groupColumns( workbook, 2, 3 );// group columns 2-3
  .collapseColumnGroup( workbook, 2 ); //the columns 2 and 3 will now be collapsed: hidden but expandable in the UI