AutoFilterReset Method

Resets the filters on the rows in the specified column.

Syntax

Visual Basic
C#

'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);
}

Visual Basic

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Filtering of Rows