Gets whether the outline (range group) is a group of rows.
Syntax
Visual Basic (Declaration) | |
---|
Public ReadOnly Property IsRowGroup As Boolean |
C# | |
---|
public bool IsRowGroup {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 Basic | 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 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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also