Spread Windows Forms 9.0 Product Documentation
View Property (RangeGroupStateChangingEventArgs)
Example 


Gets the view that contains the outline (range group) whose state is changing.
Syntax
'Declaration
 
Public ReadOnly Property View As SpreadView
'Usage
 
Dim instance As RangeGroupStateChangingEventArgs
Dim value As SpreadView
 
value = instance.View
public SpreadView View {get;}
Example
This example changes the color of the group background.
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;
}
}
}
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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

RangeGroupStateChangingEventArgs Class
RangeGroupStateChangingEventArgs Members

 

 


Copyright © GrapeCity, inc. All rights reserved.