GrapeCity.Xaml.SpreadSheet.UI
RangeGroupStateChanged Event (GcSpreadSheet)
Example 


Occurs after the user has changed the state of the outline (range group) rows or columns.
Syntax
'Declaration
 
Public Event RangeGroupStateChanged As EventHandler(Of RangeGroupStateChangedEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of RangeGroupStateChangedEventArgs)
 
AddHandler instance.RangeGroupStateChanged, handler
public event 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.

PropertyDescription
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.Xaml.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.Xaml.SpreadSheet.UI.RangeGroupStateChangingEventArgs e)
        {
            listBox1.Items.Add(e.Index.ToString());
            listBox1.Items.Add(e.IsRowGroup.ToString());
            listBox1.Items.Add(e.Level.ToString());
        }
gcSpreadSheet1.Sheets(0).RowRangeGroup.Group(0, 2)

Private Sub gcSpreadSheet1_RangeGroupStateChanged(sender As Object, e As GrapeCity.Xaml.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 Object, e As GrapeCity.Xaml.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 Server 2012, Windows RT

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options