Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / AutoFilterMode Enumeration
Example Example


In This Topic
    AutoFilterMode Enumeration
    In This Topic
    Provides data for the FarPoint.Win.Spread.SheetView.AutoFilterMode property.
    Syntax
    'Declaration
     
    Public Enum AutoFilterMode 
       Inherits System.Enum
    'Usage
     
    Dim instance As AutoFilterMode
    public enum AutoFilterMode : System.Enum 
    Members
    MemberDescription
    EnhancedDisplays a menu to work with the automatic filter
    FilterBarDisplays a filter bar to work with the automatic filter
    FilterGadgetDisplays a filter gadget to work with the automatic filter
    Example
    This example uses the AutoFilterMode enumeration.
    protected void Page_Load(object sender, System.EventArgs e)
    {
    if (this.IsPostBack) return;
    FpSpread1.Sheets[0].Cells[0, 0, 2, 2].Value = 3;
    FarPoint.Web.Spread.DynamicFilterItem dy = new FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.AboveAverage);
    FarPoint.Web.Spread.IRowFilter 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);
    rowFilter.ColumnDefinitions.Add(fd);
    FpSpread1.ActiveSheetView.RowFilter = rowFilter;
    FpSpread1.ActiveSheetView.AutoFilterColumn(1, dy.DisplayName);
    FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced;
    }
    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).Cells(0, 0, 2, 2).Value = 3
    Dim dy As New FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.AboveAverage)
    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)
    rowFilter.ColumnDefinitions.Add(fd)
    FpSpread1.ActiveSheetView.RowFilter = rowFilter
    FpSpread1.ActiveSheetView.AutoFilterColumn(1, dy.DisplayName)
    FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced
    End Sub
    Inheritance Hierarchy

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

    See Also