Click or drag to resize

FilterColumn Properties

The FilterColumn type exposes the following members.

Properties
Name Description
Public property FieldIndex
Gets or sets the index of the field.
Public property Filter
Gets or sets the filter applied to data.
Public property FilterType
Gets or sets the type of filter.
Public property FirstCondition
First condition of autofilter.
Public property HasFirstCondition
First condition used.
Public property HasSecondCondition
Second condition used
Public property IsAnd
Logical AND of FirstCondtion and SecondCondition.
Public property IsFiltered
False indicates that this autofilter was not used; otherwise True.
Public property IsSimple1
True if the first condition is a simple equality.
Public property IsSimple2
True if the second condition is a simple equality.
Public property IsTop10Items
Highest-valued 10 items displayed
Public property IsTop10Percent
Highest-valued 10 items displayed (percentage specified in condition)
Public property SecondCondition
Second condition of autofilter.
Public property ShowTopItem
Gets or sets a value indicating whether the top item should be shown based on the filter.
Public property Top10Items
number of items display in Top10Items mode.
Public property Visibledropdown
Indicates whether the AutoFilter button for this column is visible.
Top
See Also