Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ClearRangeGroup Method
Whether the outline is a group of rows
Example


In This Topic
    ClearRangeGroup Method (SheetView)
    In This Topic
    Removes all the outlines (range grouping) from all rows or columns.
    Syntax
    'Declaration
     
    Public Sub ClearRangeGroup( _
       ByVal isRowGroup As Boolean _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim isRowGroup As Boolean
     
    instance.ClearRangeGroup(isRowGroup)
    public void ClearRangeGroup( 
       bool isRowGroup
    )

    Parameters

    isRowGroup
    Whether the outline is a group of rows
    Example
    This example clears the 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.ClearRangeGroup(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.ClearRangeGroup(True)
    End Sub
    See Also