RangeGroupStateChanged Event

Occurs when the user has changed the outline state (range group) for rows or columns.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance; // Type: Events
instance.RangeGroupStateChanged = function(sheet, sheetName, isRowGroup, index, level) { };

RangeGroupStateChanged = function ( 
   sheet : Worksheet,
   sheetName : string,
   isRowGroup : boolean,
   index : number,
   level : number
) { };

Parameters

sheet: The sheet that triggered the event.
sheetName: The sheet's name.
isRowGroup: Whether the outline (range group) is a group of rows.
index: The index of the RangeGroupInfo object whose state has changed.
level: The level of the RangeGroupInfo object whose state has changed.

Example

This example uses the RangeGroupStateChanged event.

Javascript

activeSheet.suspendPaint();
activeSheet.setRowCount(34);
activeSheet.setValue(0,0,"Western");
activeSheet.setValue(0,1,"Western");
activeSheet.setValue(0,2,"Western");
activeSheet.setValue(1,0,"A");
activeSheet.setValue(1,1,"B");
activeSheet.setValue(1,2,"C");
activeSheet.setValue(2,0,"A");
activeSheet.setValue(2,1,"B");
activeSheet.setValue(2,2,"C");
activeSheet.rowOutlines.group(0,2);
activeSheet.columnOutlines.group(0,1);
activeSheet.resumePaint();

activeSheet.bind(GC.Spread.Sheets.Events.RangeGroupStateChanged, function (e, info) {    
        alert("Level (" + info.level + ")");
});

Reference

Events type