IAutoFilter Interface |
Represents autofiltering for the specified worksheet..
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The IAutoFilter type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
FirstCondition |
First condition of autofilter.
|
|
|
IsAnd |
True means to use AND operation between conditions,
False to use OR. Read-only.
|
|
|
IsFiltered |
False indicates that this autofilter was not used; otherwise True.
|
|
|
IsSimple1 |
True if the first condition is a simple equality. Read-only.
|
|
|
IsSimple2 |
True if the second condition is a simple equality. Read-only.
|
|
|
IsTop10Items |
True if the condition is a Top 10 AutoFilter. Read-only.
|
|
|
IsTop10Percent |
True if the Top 10 AutoFilter shows percentage;
False if it shows items. Read-only.
|
|
|
SecondCondition |
Second condition of autofilter.
|
|
|
ShowTopItem |
True if the Top 10 AutoFilter shows the top items;
False if it shows the bottom items. Read-only.
|
|
|
Top10Items |
Number of elements to show in Top10 mode. Read-only.
|
See Also
