DynamicFilterType Enumeration

Specifies the type of a dynamic autofilter.

Namespace: MindFusion.Spreadsheet.Wpf
Assembly: MindFusion.Spreadsheet.Wpf

 Syntax

C#

public enum DynamicFilterType

Visual Basic

Public Enum DynamicFilterType

 Members

	Member name	Description
	AboveAverage	Shows all values that are above average.
	BelowAverage	Shows all values that are below average.
	DatesInApril	Shows the dates that are in April, regardless of year.
	DatesInAugust	Shows the dates that are in August, regardless of year.
	DatesInDecember	Shows the dates that are in December, regardless of year.
	DatesInFebruary	Shows the dates that are in February, regardless of year.
	DatesInJanuary	Shows the dates that are in January, regardless of year.
	DatesInJuly	Shows the dates that are in July, regardless of year.
	DatesInJune	Shows the dates that are in June, regardless of year.
	DatesInMarch	Shows the dates that are in March, regardless of year.
	DatesInMay	Shows the dates that are in May, regardless of year.
	DatesInNovember	Shows the dates that are in November, regardless of year.
	DatesInOctober	Shows the dates that are in October, regardless of year.
	DatesInQuarter1	Shows the dates that are in the first calendar quarter, regardless of year.
	DatesInQuarter2	Shows the dates that are in the second calendar quarter, regardless of year.
	DatesInQuarter3	Shows the dates that are in the third calendar quarter, regardless of year.
	DatesInQuarter4	Shows the dates that are in the fourth calendar quarter, regardless of year.
	DatesInSeptember	Shows the dates that are in September, regardless of year.
	LastMonth	Shows last month's dates.
	LastQuarter	Shows last quarter's dates.
	LastWeek	Shows last week's dates, using Sunday as the first week day.
	LastYear	Shows last year's dates.
	NextMonth	Shows next month's dates.
	NextQuarter	Shows next quarter's dates.
	NextWeek	Shows next week's dates, using Sunday as the first week day.
	NextYear	Shows next year's dates.
	ThisMonth	Shows this month's dates.
	ThisQuarter	Shows this quarter's dates.
	ThisWeek	Shows this week's dates, using Sunday as the first week day.
	ThisYear	Shows this year's dates.
	Today	Shows today's dates.
	Tomorrow	Shows tomorrow's dates.
	YearToDate	Shows the dates between the beginning of the year and today, inclusive.
	Yesterday	Shows yesterday's dates.