ResetFilter(Int32) Method

Resets the filter settings for the specified column.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub ResetFilter( _
   ByVal modelColumn As Integer _
)

'Usage
 
Dim instance As DefaultRowFilter
Dim modelColumn As Integer
 
instance.ResetFilter(modelColumn)

public void ResetFilter( 
   int modelColumn
)

Parameters

modelColumn: Column index

Example

This example uses the ResetFilter method.

private void Form1_Load(object sender, EventArgs e)
        {
            fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = true;
            fpSpread1.ActiveSheet.RowFilter.ShowFilterIndicator = true;   
        }

        private void button1_Click(object sender, EventArgs e)
        {
            fpSpread1.ActiveSheet.RowFilter.ResetFilter(1);
        }

Visual Basic

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        FpSpread1.ActiveSheet.Columns(1).AllowAutoFilter = True
        FpSpread1.ActiveSheet.RowFilter.ShowFilterIndicator = True
    End Sub

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        FpSpread1.ActiveSheet.RowFilter.ResetFilter(1)
    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

DefaultRowFilter Class
DefaultRowFilter Members
Overload List