Spread Windows Forms 11.0 Product Documentation
GetRangeGroupInfo Method (IRangeGroupSupport)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > IRangeGroupSupport Interface : GetRangeGroupInfo Method
Level of outline (range group)
Whether the outline (range group) is of rows
Gets all the outlines (range groups) in a specified level.
Syntax
'Declaration
 
Function GetRangeGroupInfo( _
   ByVal level As Integer, _
   ByVal isRowGroup As Boolean _
) As RangeGroupInfo()
'Usage
 
Dim instance As IRangeGroupSupport
Dim level As Integer
Dim isRowGroup As Boolean
Dim value() As RangeGroupInfo
 
value = instance.GetRangeGroupInfo(level, isRowGroup)
RangeGroupInfo[] GetRangeGroupInfo( 
   int level,
   bool isRowGroup
)

Parameters

level
Level of outline (range group)
isRowGroup
Whether the outline (range group) is of rows

Return Value

Collection of outlines (range groups) in the level
Example
This example expands the second group in the range.
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;
}
FarPoint.Win.Spread.RangeGroupInfo[] rgi = rangeGroupSupport.GetRangeGroupInfo(2, true);
rangeGroupSupport.ExpandRangeGroup(rgi[0], true, true);
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 rgi() As FarPoint.Win.Spread.RangeGroupInfo = rangeGroupSupport.GetRangeGroupInfo(2, True)
rangeGroupSupport.ExpandRangeGroup(rgi(0), True, True)
See Also

Reference

IRangeGroupSupport Interface
IRangeGroupSupport Members