Spread for ASP.NET 7.0 Product Documentation
DynamicFilterType Enumeration
Example  See Also  Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : DynamicFilterType Enumeration


Glossary Item Box

Specifies a value that indicates the type of dynamic filter.

Syntax

Visual Basic (Declaration) 
Public Enum DynamicFilterType 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As DynamicFilterType
C# 
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 uses the DynamicFilterType enumeration.
C#Copy Code
protected void Page_Load(object sender, System.EventArgs e)
{
if (this.IsPostBack) return;
FpSpread1.Sheets[0].RowCount = 5;
FpSpread1.Sheets[0].Cells[0, 0, 2, 2].Value = 3;
FpSpread1.Sheets[0].Cells[0, 0, 2, 2].BackColor = Color.Red;
FpSpread1.Sheets[0].Cells[4, 1].Text = System.DateTime.Now.ToString();

FarPoint.Web.Spread.DynamicFilterItem dy = new FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.AboveAverage);
FarPoint.Web.Spread.ColorFilterItem colorfilter = new FarPoint.Web.Spread.ColorFilterItem(false, Color.Red);
FarPoint.Web.Spread.DynamicFilterItem datefilter = new FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.LastMonth);
FarPoint.Web.Spread.HideRowFilter rowFilter = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView);
FarPoint.Web.Spread.FilterColumnDefinition fd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom);
fd.Filters.Add(dy);
fd.Filters.Add(colorfilter);
fd.Filters.Add(datefilter);
rowFilter.ColumnDefinitions.Add(fd);
FpSpread1.ActiveSheetView.RowFilter = rowFilter;
FpSpread1.ActiveSheetView.AutoFilterColumn(1, dy.DisplayName);
FpSpread1.Sheets[0].AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced;
VB.NETCopy Code
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If (IsPostBack) Then
    Return
End If
FpSpread1.Sheets(0).RowCount = 5
FpSpread1.Sheets(0).Cells(0, 0, 2, 2).Value = 3
FpSpread1.Sheets(0).Cells(0, 0, 2, 2).BackColor = Drawing.Color.Red
FpSpread1.Sheets(0).Cells(4, 1).Text = DateTime.Now

Dim dy As New FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.AboveAverage)
Dim colorfilter As New FarPoint.Web.Spread.ColorFilterItem(False, Drawing.Color.Red)
Dim datefilter As New FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.LastMonth)
Dim rowFilter As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView)
Dim fd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom)
fd.Filters.Add(dy)
fd.Filters.Add(colorfilter)
fd.Filters.Add(datefilter)
rowFilter.ColumnDefinitions.Add(fd)
FpSpread1.ActiveSheetView.RowFilter = rowFilter
FpSpread1.ActiveSheetView.AutoFilterColumn(1, dy.DisplayName)
FpSpread1.Sheets(0).AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced
End Sub

Inheritance Hierarchy

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

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.