Spread Windows Forms 11.0 Product Documentation
AutoFilterReset Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : AutoFilterReset Method
Column index
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

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Filtering of Rows