Spread Windows Forms 9.0 Product Documentation
GetRangeGroupLevels Method (IRangeGroupSupport)
Example 


Whether the outline (range group) is of rows
Gets the amount of the level of an outline (range group).
Syntax
'Declaration
 
Function GetRangeGroupLevels( _
   ByVal isRowGroup As Boolean _
) As Integer
'Usage
 
Dim instance As IRangeGroupSupport
Dim isRowGroup As Boolean
Dim value As Integer
 
value = instance.GetRangeGroupLevels(isRowGroup)
int GetRangeGroupLevels( 
   bool isRowGroup
)

Parameters

isRowGroup
Whether the outline (range group) is of rows
Example
This example returns the number of group levels.
fpSpread1.ActiveSheet.AddRangeGroup(0, 20, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true);
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;

FarPoint.Win.Spread.IRangeGroupSupport rangeGroupSupport = ((FarPoint.Win.Spread.IRangeGroupSupport)(fpSpread1.ActiveSheet));
if ((rangeGroupSupport == null)) {
    return;
}
int i = rangeGroupSupport.GetRangeGroupLevels(true);
if ((i > 0)) {
    MessageBox.Show(("The number of group levels is " + i.ToString()));
}
FpSpread1.ActiveSheet.AddRangeGroup(0, 20, True)
FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True)
FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced

Dim rangeGroupSupport As FarPoint.Win.Spread.IRangeGroupSupport = CType(FpSpread1.ActiveSheet, FarPoint.Win.Spread.IRangeGroupSupport)
If rangeGroupSupport Is Nothing Then
   Return
End If
Dim i As Integer = rangeGroupSupport.GetRangeGroupLevels(True)
If i > 0 Then
MessageBox.Show("The number of group levels is " & i.ToString())
End If
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

IRangeGroupSupport Interface
IRangeGroupSupport Members

 

 


Copyright © GrapeCity, inc. All rights reserved.