DynamicFilterType Enumeration

Specifies a value that indicates the type of dynamic filter.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum DynamicFilterType 
   Inherits System.Enum

'Usage
 
Dim instance As DynamicFilterType

public enum DynamicFilterType : System.Enum

Members

Member	Description
AboveAverage	Filters cells whose values are greater than the average value; used for number filter.
BelowAverage	Filters cells whose values are less than the average value; used for number filter.
LastMonth	Filters cells whose values are in the last month; used for date filter.
LastQuarter	Filters cells whose values are in the last quarter; used for date filter.
LastWeek	Filters cells whose values are in the last week; used for date filter.
LastYear	Filters cells whose values are in the last year; used for date filter.
M1	Filters cells whose values are in January, regardless of year; used for date filter.
M10	Filters cells whose values are in October, regardless of year; used for date filter.
M11	Filters cells whose values are in November, regardless of year; used for date filter.
M12	Filters cells whose values are in December, regardless of year; used for date filter.
M2	Filters cells whose values are in February, regardless of year; used for date filter.
M3	Filters cells whose values are in March, regardless of year; used for date filter.
M4	Filters cells whose values are in April, regardless of year; used for date filter.
M5	Filters cells whose values are in May, regardless of year; used for date filter.
M6	Filters cells whose values are in June, regardless of year; used for date filter.
M7	Filters cells whose values are in July, regardless of year; used for date filter.
M8	Filters cells whose values are in August, regardless of year; used for date filter.
M9	Filters cells whose values are in September, regardless of year; used for date filter.
NextMonth	Filters cells whose values are next month; used for date filter.
NextQuarter	Filters cells whose values are in the next quarter; used for date filter.
NextWeek	Filters cells whose values are in the next week; used for date filter.
NextYear	Filters cells whose values are in the next year; used for date filter.
Q1	Filters cells whose values are in the first quarter, regardless of year; used for date filter.
Q2	Filters cells whose values are in the second quarter, regardless of year; used for date filter.
Q3	Filters cells whose values are in the third quarter, regardless of year; used for date filter.
Q4	Filters cells whose values are in the fourth quarter, regardless of year; used for date filter.
ThisMonth	Filters cells whose values are in this month; used for date filter.
ThisQuarter	Filters cells whose values are in this quarter; used for date filter.
ThisWeek	Filters cells whose values are in this week; used for date filter.
ThisYear	Filters cells whose values are in this year; used for date filter.
Today	Filters cells whose values are equal to today; used for date filter.
Tomorrow	Filters cells whose values are equal to tomorrow; used for date filter.
YearToDate	Fitlers cells whose values are between the beginning of the year and today, inclusive; used for date filter.
Yesterday	Filters cells whose values are equal to yesterday; used for date filter.

Example

This example filters above average values.

fpSpread1.Sheets[0].Cells[0, 0, 2, 2].Value = 3;
FarPoint.Win.Spread.DynamicFilterItem dy = new FarPoint.Win.Spread.DynamicFilterItem(FarPoint.Win.Spread.DynamicFilterType.AboveAverage);
FarPoint.Win.Spread.IRowFilter rowFilter = new FarPoint.Win.Spread.HideRowFilter(fpSpread1.ActiveSheet);
FarPoint.Win.Spread.FilterColumnDefinition fd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Custom);
fd.Filters.Add(dy);
rowFilter.ColumnDefinitions.Add(fd);
fpSpread1.ActiveSheet.RowFilter = rowFilter;
fpSpread1.ActiveSheet.AutoFilterColumn(1, dy.DisplayName, 0);
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;

VB.NET

FpSpread1.Sheets(0).Cells(0, 0, 2, 2).Value = 3
Dim dy As New FarPoint.Win.Spread.DynamicFilterItem(FarPoint.Win.Spread.DynamicFilterType.AboveAverage)
Dim rowFilter As New FarPoint.Win.Spread.HideRowFilter(FpSpread1.ActiveSheet)
Dim fd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Custom)
fd.Filters.Add(dy)
rowFilter.ColumnDefinitions.Add(fd)
FpSpread1.ActiveSheet.RowFilter = rowFilter
FpSpread1.ActiveSheet.AutoFilterColumn(1, dy.DisplayName, 0)
FpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.DynamicFilterType

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FarPoint.Win.Spread Namespace