Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AutoFilterMode Property
Example


In This Topic
    AutoFilterMode Property
    In This Topic
    Gets or sets the AutoFilterMode which indicates which filtering UI is used.
    Syntax
    'Declaration
     
    Public Property AutoFilterMode As AutoFilterMode
    'Usage
     
    Dim instance As SheetView
    Dim value As AutoFilterMode
     
    instance.AutoFilterMode = value
     
    value = instance.AutoFilterMode
    public AutoFilterMode AutoFilterMode {get; set;}
    Remarks
    Note: In versions earlier than V7, if you set the SheetView.RowFilter to a HideRowFilter, the label of the header cell in the filter column (specified through FilterColumnDefinition) changed to the "FilterBy" string (if the column is not filtered, the "(All)" string is displayed). In version 7, specify the AutoFilterMode (if your mode differs from the default mode FilterGadget) before you set a HideRowFilter to SheetView.
    Example
    This example sets the AutoFilterMode property.
    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
    See Also