Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / AutoFilterReset Method
Column index
Example


In This Topic
    AutoFilterReset Method
    In This Topic
    Resets the filters on the rows in the specified column.
    Syntax
    'Declaration
     
    Public Sub AutoFilterReset( _
       ByVal column As Integer _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim column As Integer
     
    instance.AutoFilterReset(column)
    public void AutoFilterReset( 
       int column
    )

    Parameters

    column
    Column index
    Example
    This example resets the filter for the specified column.
    fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
    fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = true;
        
    private void Button1Click(object sender, System.EventArgs e) {
         fpSpread1.ActiveSheet.AutoFilterReset(0);
    }
    
    FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
    FpSpread1.ActiveSheet.Columns(1).AllowAutoFilter = True
    
    Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        FpSpread1.ActiveSheet.AutoFilterReset(0)
    End Sub
    See Also