Spread Windows Forms 7.0 Product Documentation
AutoFilterReset Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : AutoFilterReset Method


column
Column index

Glossary Item Box

Resets the filters on the rows in the specified column.

Syntax

Visual Basic (Declaration) 
Public Sub AutoFilterReset( _
   ByVal column As Integer _
) 
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim column As Integer
 
instance.AutoFilterReset(column)
C# 
public void AutoFilterReset( 
   int column
)

Parameters

column
Column index

Example

This example resets the filter for the specified column.
C#Copy Code
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 BasicCopy Code
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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.