colRangeGroup Field

Indicates the column range group.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: RangeGroup
value = instance.colRangeGroup;

var colRangeGroup : RangeGroup;

Example

This example creates groups.

Javascript

sheet.setRowCount(34);
sheet.setValue(0,0,"Western");
sheet.setValue(0,1,"Western");
sheet.setValue(0,2,"Western");
sheet.setValue(1,0,"A");
sheet.setValue(1,1,"B");
sheet.setValue(1,2,"C");
sheet.setValue(2,0,"A");
sheet.setValue(2,1,"B");
sheet.setValue(2,2,"C");
sheet.rowRangeGroup.group(0,2);
sheet.colRangeGroup.group(0,1);
sheet.rowRangeGroup.expand(0,false);
sheet.colRangeGroup.expand(0,false);
spread.repaint();

Reference

Sheet type

Send comments on this topic.