Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / GetRangeGroupInfo Method
Level for the associated range group
Whether the outline is a group of rows

In This Topic
    GetRangeGroupInfo Method (SheetView)
    In This Topic
    Gets range groups of rows or columns by level.
    Public Function GetRangeGroupInfo( _
       ByVal level As Integer, _
       ByVal isRowGroup As Boolean _
    ) As RangeGroupInfo()
    Dim instance As SheetView
    Dim level As Integer
    Dim isRowGroup As Boolean
    Dim value() As RangeGroupInfo
    value = instance.GetRangeGroupInfo(level, isRowGroup)
    public RangeGroupInfo[] GetRangeGroupInfo( 
       int level,
       bool isRowGroup


    Level for the associated range group
    Whether the outline is a group of rows

    Return Value

    The collection of range groups with the specified level.
    This example expands the specified level of the group range, in this case the range group from 0 to 10.
    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 Button1_Click(object sender, System.EventArgs e) 
    FarPoint.Win.Spread.RangeGroupInfo[] rgi = fpSpread1.ActiveSheet.GetRangeGroupInfo(2, true);
    fpSpread1.ActiveSheet.ExpandRangeGroup(rgi[0], true, true);
    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 Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim rgi() As FarPoint.Win.Spread.RangeGroupInfo = FpSpread1.ActiveSheet.GetRangeGroupInfo(2, True)
    FpSpread1.ActiveSheet.ExpandRangeGroup(rgi(0), True, True)
    End Sub
    See Also