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.


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
public RangeGroupInfo RangeGroupInfo {get;}


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


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.