setColumnCount Method

Sets the column count in the specified sheet area.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.setColumnCount(colCount, sheetArea);

function setColumnCount( 
   colCount : number,
   sheetArea : SheetArea
) : any;

Parameters

colCount: The column count.
sheetArea: The sheet area. If this parameter is not given, it defaults to viewport.

Example

This example sets the number of columns.

Javascript

sheet.setRowCount(4,1);
sheet.setColumnCount(4,2);
sheet.addSpan(0,0,3,3,GC.Spread.Sheets.SheetArea.colHeader);
sheet.addSpan(0,0,3,3,GC.Spread.Sheets.SheetArea.rowHeader);
sheet.addSpan(0,0,3,3,GC.Spread.Sheets.SheetArea.viewport);

Reference

Worksheet type

Product Support Forum | Print this page