Spread Windows Forms 12.0 Product Documentation
DynamicFilterType Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : DynamicFilterType Enumeration
Specifies a value that indicates the type of dynamic filter.
Syntax
'Declaration
 
Public Enum DynamicFilterType 
   Inherits System.Enum
'Usage
 
Dim instance As DynamicFilterType
public enum DynamicFilterType : System.Enum 
Members
MemberDescription
AboveAverageFilters cells whose values are greater than the average value; used for number filter.
BelowAverageFilters cells whose values are less than the average value; used for number filter.
LastMonthFilters cells whose values are in the last month; used for date filter.
LastQuarterFilters cells whose values are in the last quarter; used for date filter.
LastWeekFilters cells whose values are in the last week; used for date filter.
LastYearFilters cells whose values are in the last year; used for date filter.
M1Filters cells whose values are in January, regardless of year; used for date filter.
M10Filters cells whose values are in October, regardless of year; used for date filter.
M11Filters cells whose values are in November, regardless of year; used for date filter.
M12Filters cells whose values are in December, regardless of year; used for date filter.
M2Filters cells whose values are in February, regardless of year; used for date filter.
M3Filters cells whose values are in March, regardless of year; used for date filter.
M4Filters cells whose values are in April, regardless of year; used for date filter.
M5Filters cells whose values are in May, regardless of year; used for date filter.
M6Filters cells whose values are in June, regardless of year; used for date filter.
M7Filters cells whose values are in July, regardless of year; used for date filter.
M8Filters cells whose values are in August, regardless of year; used for date filter.
M9Filters cells whose values are in September, regardless of year; used for date filter.
NextMonthFilters cells whose values are next month; used for date filter.
NextQuarterFilters cells whose values are in the next quarter; used for date filter.
NextWeekFilters cells whose values are in the next week; used for date filter.
NextYearFilters cells whose values are in the next year; used for date filter.
Q1Filters cells whose values are in the first quarter, regardless of year; used for date filter.
Q2Filters cells whose values are in the second quarter, regardless of year; used for date filter.
Q3Filters cells whose values are in the third quarter, regardless of year; used for date filter.
Q4Filters cells whose values are in the fourth quarter, regardless of year; used for date filter.
ThisMonthFilters cells whose values are in this month; used for date filter.
ThisQuarterFilters cells whose values are in this quarter; used for date filter.
ThisWeekFilters cells whose values are in this week; used for date filter.
ThisYearFilters cells whose values are in this year; used for date filter.
TodayFilters cells whose values are equal to today; used for date filter.
TomorrowFilters cells whose values are equal to tomorrow; used for date filter.
YearToDateFitlers cells whose values are between the beginning of the year and today, inclusive; used for date filter.
YesterdayFilters 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;
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

See Also

Reference

FarPoint.Win.Spread Namespace