XlDynamicFilter.DynamicFilterType Property
Gets or sets the type of the dynamic filter.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v23.2.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
Property Value
Type | Description |
---|---|
XlDynamicFilterType | An XlDynamicFilterType enumeration member that specifies the dynamic filter type. |
Available values:
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. |