RangeGroupStateChanged Event (GcSpreadSheet)

Occurs after the user has changed the state of the outline (range group) rows or columns.

Syntax

Visual Basic
C#

'Declaration
 
Public Event RangeGroupStateChanged As System.EventHandler(Of RangeGroupStateChangedEventArgs)

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of RangeGroupStateChangedEventArgs)
 
AddHandler instance.RangeGroupStateChanged, handler

public event System.EventHandler<RangeGroupStateChangedEventArgs> RangeGroupStateChanged

Event Data

The event handler receives an argument of type RangeGroupStateChangedEventArgs containing data related to this event. The following RangeGroupStateChangedEventArgs properties provide information specific to this event.

Property	Description
Index	Gets the index of the RangeGroupInfo object whose state has changed.
IsRowGroup	Gets whether the outline (range group) is a group of rows.
Level	Gets the level of the RangeGroupInfo object whose state has changed.

Example

This example uses the RangeGroupStateChanged event.

gcSpreadSheet1.Sheets[0].RowRangeGroup.Group(0, 2);

private void gcSpreadSheet1_RangeGroupStateChanged(object sender, GrapeCity.Windows.SpreadSheet.UI.RangeGroupStateChangedEventArgs e)
        {
            listBox1.Items.Add(e.Index.ToString());
            listBox1.Items.Add(e.IsRowGroup.ToString());
            listBox1.Items.Add(e.Level.ToString());
        }

private void gcSpreadSheet1_RangeGroupStateChanging(object sender, GrapeCity.Windows.SpreadSheet.UI.RangeGroupStateChangingEventArgs e)
        {
            listBox1.Items.Add(e.Index.ToString());
            listBox1.Items.Add(e.IsRowGroup.ToString());
            listBox1.Items.Add(e.Level.ToString());
        }

VB.NET

GcSpreadSheet1.Sheets(0).RowRangeGroup.Group(0, 2)

Private Sub GcSpreadSheet1_RangeGroupStateChanged(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.RangeGroupStateChangedEventArgs) Handles GcSpreadSheet1.RangeGroupStateChanged
        ListBox1.Items.Add(e.Index.ToString())
        ListBox1.Items.Add(e.IsRowGroup.ToString())
        ListBox1.Items.Add(e.Level.ToString())
    End Sub

    Private Sub GcSpreadSheet1_RangeGroupStateChanging(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.RangeGroupStateChangingEventArgs) Handles GcSpreadSheet1.RangeGroupStateChanging
        ListBox1.Items.Add(e.Index.ToString())
        ListBox1.Items.Add(e.IsRowGroup.ToString())
        ListBox1.Items.Add(e.Level.ToString())
    End Sub

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GcSpreadSheet Class
GcSpreadSheet Members