corelibraries-devexpress-dot-export-dot-xl-064187db.md
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.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public enum XlDynamicFilterType
Public Enum XlDynamicFilterType
| 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.
|
The following properties accept/return XlDynamicFilterType values:
The values listed by this enumeration are used to construct the XlDynamicFilter filter criteria.
See Also