officefileapi-devexpress-dot-spreadsheet-dot-autofiltercolumn-36b80694.md
Gets the type of the dynamic filter applied to the current column.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
DynamicFilterType DynamicFilterType { get; }
ReadOnly Property DynamicFilterType As DynamicFilterType
| Type | Description |
|---|---|
| DynamicFilterType |
A DynamicFilterType enumeration member which indicates the dynamic filter type.
|
Available values:
Show 35 items
| 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.
|
If the AutoFilterColumn.FilterType property value is not FilterType.DynamicFilter, the DynamicFilterType property is null.
See Also