Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / RemoveRangeGroup Method
Starting index
Number of the rows or columns to remove from being grouped together in the outline (range group)
Whether the outline (range group) is of rows
Example


In This Topic
    RemoveRangeGroup Method (SheetView)
    In This Topic
    Removes rows or columns from an outline (range group) from a specified start index by a specified amount, and returns them to individual rows or columns.
    Syntax
    'Declaration
     
    Public Sub RemoveRangeGroup( _
       ByVal startIndex As Integer, _
       ByVal count As Integer, _
       ByVal isRowGroup As Boolean _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim startIndex As Integer
    Dim count As Integer
    Dim isRowGroup As Boolean
     
    instance.RemoveRangeGroup(startIndex, count, isRowGroup)
    public void RemoveRangeGroup( 
       int startIndex,
       int count,
       bool isRowGroup
    )

    Parameters

    startIndex
    Starting index
    count
    Number of the rows or columns to remove from being grouped together in the outline (range group)
    isRowGroup
    Whether the outline (range group) is of rows
    Example
    This example removes the specified range group.
    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) 
    {
    fpSpread1.ActiveSheet.RemoveRangeGroup(0, 10, 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
    FpSpread1.ActiveSheet.RemoveRangeGroup(0, 10, True)
    End Sub
    See Also