ResetFilter() Method

Resets the filter settings for the entire row filter.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub ResetFilter()

'Usage
 
Dim instance As DefaultRowFilter
 
instance.ResetFilter()

public void ResetFilter()

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

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()
    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