ShowFilterIndicator Property (DefaultRowFilter)

Gets or sets whether the filter indicator should be displayed.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ShowFilterIndicator As Boolean

'Usage
 
Dim instance As DefaultRowFilter
Dim value As Boolean
 
instance.ShowFilterIndicator = value
 
value = instance.ShowFilterIndicator

public bool ShowFilterIndicator {get; set;}

Property Value

Boolean: true to display the filter indicator; false to hide it

Example

This examples shows the icon in the column header for filtering.

fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = true;
fpSpread1.ActiveSheet.RowFilter.ShowFilterIndicator = true;
fpSpread1.ActiveSheet.RowFilter.AllString = "Show All"; 
fpSpread1.ActiveSheet.RowFilter.BlanksString = "Show The Blanks";
fpSpread1.ActiveSheet.RowFilter.NonBlanksString = "Show The Non-Blanks";

Visual Basic

FpSpread1.ActiveSheet.Columns(1).AllowAutoFilter = True
FpSpread1.ActiveSheet.RowFilter.ShowFilterIndicator = True
FpSpread1.ActiveSheet.RowFilter.AllString = "Show All" 
FpSpread1.ActiveSheet.RowFilter.BlanksString = "Show The Blanks"
FpSpread1.ActiveSheet.RowFilter.NonBlanksString = "Show The Non-Blanks"

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