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
Example


In This Topic
    GetRangeGroupInfo Method (SheetView)
    In This Topic
    Gets range groups of rows or columns by level.
    Syntax
    'Declaration
     
    Public Function GetRangeGroupInfo( _
       ByVal level As Integer, _
       ByVal isRowGroup As Boolean _
    ) As RangeGroupInfo()
    'Usage
     
    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
    )

    Parameters

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

    Return Value

    The collection of range groups with the specified level.
    Example
    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