AutoFilterColumn.DynamicFilterType Property

Gets the type of the dynamic filter applied to the current column.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v25.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

DynamicFilterType DynamicFilterType { get; }

VB.NET

ReadOnly Property DynamicFilterType As DynamicFilterType

Property Value

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.

Remarks

If the AutoFilterColumn.FilterType property value is not FilterType.DynamicFilter, the DynamicFilterType property is null.