AutoFilterColumn.DynamicFilterType Property
Gets the type of the dynamic filter applied to the current column.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v18.2.Core.dll
Declaration
Property Value
| Type | Description |
|---|---|
| DynamicFilterType | A DynamicFilterType enumeration member which indicates the dynamic filter type. |
Available values:
| Name | Description |
|---|---|
| Null | Does not apply any filter. |
| AboveAverage | Shows values which are greater than the average value. |
| BelowAverage | Shows values which are less than the average value. |
| Tomorrow | Shows tomorrow’s dates. |
| Today | Shows today’s dates. |
| Yesterday | Shows yesterday’s dates. |
| NextWeek | Shows dates occurring in the next week. |
| ThisWeek | Shows dates in the current week. |
| LastWeek | Shows dates occurring in the last week. |
| NextMonth | Shows dates occurring in the next calendar month. |
| ThisMonth | Shows dates in the current month. |
| LastMonth | Shows dates occurring in the last calendar month. |
| NextQuarter | Shows dates occurring in the next quarter. |
| ThisQuarter | Shows dates in the current quarter. |
| LastQuarter | Shows dates occurring in the last quarter. |
| NextYear | Shows dates occurring in the next year. |
| ThisYear | Shows dates in the current year. |
| LastYear | Shows dates occurring in the last year. |
| YearToDate | Shows dates occurring between the beginning of the current year and today, inclusive. |
| Q1 | Shows dates occurring in the 1st quarter, regardless of year. |
| Q2 | Shows dates occurring in the 2nd quarter, regardless of year. |
| Q3 | Shows dates occurring in the 3rd quarter, regardless of year. |
| Q4 | Shows dates occurring in the 4th quarter, regardless of year. |
| M1 | Shows dates occurring in January, regardless of the year. |
| M2 | Shows dates occurring in February, regardless of the year. |
| M3 | Shows dates occurring in March, regardless of the year. |
| M4 | Shows dates occurring in April, regardless of the year. |
| M5 | Shows dates occurring in May, regardless of the year. |
| M6 | Shows dates occurring in June, regardless of the year. |
| M7 | Shows dates occurring in July, regardless of the year. |
| M8 | Shows dates occurring in August, regardless of the year. |
| M9 | Shows dates occurring in September, regardless of the year. |
| M10 | Shows dates occurring in October, regardless of the year. |
| M11 | Shows dates occurring in November, regardless of the year. |
| M12 | Shows dates occurring in December, regardless of the year. |
Remarks
If the AutoFilterColumn.FilterType property value is not FilterType.DynamicFilter, the DynamicFilterType property is null.