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


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Columns Class : GetRangeGroupInfo Method
Level of the associated outline (range group)
Gets the outlines (range groups) by level.
Syntax
'Declaration
 
Public Function GetRangeGroupInfo( _
   ByVal level As Integer _
) As RangeGroupInfo()
'Usage
 
Dim instance As Columns
Dim level As Integer
Dim value() As RangeGroupInfo
 
value = instance.GetRangeGroupInfo(level)
public RangeGroupInfo[] GetRangeGroupInfo( 
   int level
)

Parameters

level
Level of the associated outline (range group)

Return Value

RangeGroupInfo array containing all the range group information
Example
This example expands the specified group range.
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, false);
fpSpread1.ActiveSheet.AddRangeGroup(0, 5, false);
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;

private void Button1_Click(object sender, System.EventArgs e) 
{
FarPoint.Win.Spread.RangeGroupInfo[] rgi = fpSpread1.ActiveSheet.Columns.GetRangeGroupInfo(1);
fpSpread1.ActiveSheet.Columns.ExpandRangeGroup(rgi[0], true);
}
FpSpread1.ActiveSheet.AddRangeGroup(0, 10, False)
FpSpread1.ActiveSheet.AddRangeGroup(0, 5, False)
FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim rgi() As FarPoint.Win.Spread.RangeGroupInfo = FpSpread1.ActiveSheet.Columns.GetRangeGroupInfo(1)
FpSpread1.ActiveSheet.Columns.ExpandRangeGroup(rgi(0), True)
End Sub
See Also

Reference

Columns Class
Columns Members