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.v18.1.Core.dll
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.
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlDynamicFilterType enum.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.