XlDynamicFilterType Enum
Lists the types of dynamic filter, i.e., a filter whose results may depend on the data to which it is applied or the current date.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v21.1.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
Members
Name | Description |
---|---|
AboveAverage
|
Shows values that are above the average value. |
BelowAverage
|
Shows values that are below the average value. |
Tomorrow
|
Shows tomorrow’s dates. |
Today
|
Shows today’s dates. |
Yesterday
|
Shows yesterday’s dates. |
NextWeek
|
Shows dates occurring next week. |
ThisWeek
|
Shows dates occurring this week. |
LastWeek
|
Shows dates occurring last week. |
NextMonth
|
Shows dates occurring next month. |
ThisMonth
|
Shows dates occurring this month. |
LastMonth
|
Shows dates occurring last month. |
NextQuarter
|
Shows dates occurring next quarter. |
ThisQuarter
|
Shows dates occurring this quarter. |
LastQuarter
|
Shows dates occurring last quarter. |
NextYear
|
Shows dates occurring next year. |
ThisYear
|
Shows dates occurring this year. |
LastYear
|
Shows dates occurring last year. |
YearToDate
|
Shows dates occurring between the beginning of the current year and today, inclusive. |
Quarter1
|
Shows dates occurring in the 1st quarter, regardless of the year. |
Quarter2
|
Shows dates occurring in the 2nd quarter, regardless of the year. |
Quarter3
|
Shows dates occurring in the 3rd quarter, regardless of the year. |
Quarter4
|
Shows dates occurring in the 4th quarter, regardless of the year. |
Month1
|
Shows dates occurring in January, regardless of the year. |
Month2
|
Shows dates occurring in February, regardless of the year. |
Month3
|
Shows dates occurring in March, regardless of the year. |
Month4
|
Shows dates occurring in April, regardless of the year. |
Month5
|
Shows dates occurring in May, regardless of the year. |
Month6
|
Shows dates occurring in June, regardless of the year. |
Month7
|
Shows dates occurring in July, regardless of the year. |
Month8
|
Shows dates occurring in August, regardless of the year. |
Month9
|
Shows dates occurring in September, regardless of the year. |
Month10
|
Shows dates occurring in October, regardless of the year. |
Month11
|
Shows dates occurring in November, regardless of the year. |
Month12
|
Shows dates occurring in December, regardless of the year. |
Related API Members
The following properties accept/return XlDynamicFilterType values:
Remarks
The values listed by this enumeration are used to construct the XlDynamicFilter filter criteria.