Spread Windows Forms 7.0 Product Documentation
RangeGroupInfo Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > RangeGroupStateChangingEventArgs Class : RangeGroupInfo Property


Glossary Item Box

Gets the infomation about the outline (range group) whose state was changed.

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property RangeGroupInfo As RangeGroupInfo
Visual Basic (Usage)Copy Code
Dim instance As RangeGroupStateChangingEventArgs
Dim value As RangeGroupInfo
 
value = instance.RangeGroupInfo
C# 
public RangeGroupInfo RangeGroupInfo {get;}

Example

This example changes the color of the group background.
C#Copy Code
fpSpread1.ActiveSheet.AddRangeGroup(0, 20, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true);
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;

private void fpSpread1_RangeGroupStateChanging(object sender, FarPoint.Win.Spread.RangeGroupStateChangingEventArgs e) {
if (e.IsRowGroup == true) 
{
if ((e.RangeGroupInfo().Start == 0)) 
{
e.View.Sheets(e.View.ActiveSheetIndex).RangeGroupBackGroundColor = Color.Goldenrod;
}
}
}
Visual BasicCopy Code
FpSpread1.ActiveSheet.AddRangeGroup(0, 20, True)
FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True)
FpSpread1.ActiveSheet.AddRangeGroup(0, 5, True)
FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced

Private Sub FpSpread1_RangeGroupStateChanging(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.RangeGroupStateChangingEventArgs)
Handles FpSpread1.RangeGroupStateChanging
If e.IsRowGroup = True Then
If e.RangeGroupInfo().Start = 0 Then
e.View.Sheets(e.View.ActiveSheetIndex).RangeGroupBackGroundColor = Color.Goldenrod
End If
End If
End Sub

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.