XlDynamicFilter.DynamicFilterType Property

Gets or sets the type of the dynamic filter.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v25.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlDynamicFilterType DynamicFilterType { get; set; }

VB.NET

Public Property DynamicFilterType As XlDynamicFilterType

Property Value

Type	Description
XlDynamicFilterType	An XlDynamicFilterType enumeration member that specifies the dynamic filter type.

Available values:

Show 34 items

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.