Spread Silverlight Documentation
RangeGroupStateChanging Event (GcSpreadSheet)
Example 


Occurs before the user changes the state of the outline (range group) rows or columns.
Syntax
'Declaration
 
Public Event RangeGroupStateChanging As System.EventHandler(Of RangeGroupStateChangingEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of RangeGroupStateChangingEventArgs)
 
AddHandler instance.RangeGroupStateChanging, handler
public event System.EventHandler<RangeGroupStateChangingEventArgs> RangeGroupStateChanging
Event Data

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

PropertyDescription
Cancel (Inherited from System.ComponentModel.CancelEventArgs)
IndexGets the index of the RangeGroupInfo object whose state is changing.  
IsRowGroupGets whether the outline (range group) is a group of rows.  
LevelGets the level of the RangeGroupInfo object whose state is changing.  
Example
This example uses the RangeGroupStateChanging 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());
        }
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

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.