XlDynamicFilterType Enum

Lists the types of dynamic filter, i.e., a filter whose results may depend on the data to which it is applied or the current date.

Namespace: DevExpress.Export.Xl

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

Declaration

public enum XlDynamicFilterType

Members

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.

Related API Members

The following properties accept/return XlDynamicFilterType values:

Remarks

The values listed by this enumeration are used to construct the XlDynamicFilter filter criteria.

See Also