Spread for ASP.NET 9.0 Product Documentation
FilterBarMode Property
Example 


Gets or sets the filter bar mode.
Syntax
'Declaration
 
Public Property FilterBarMode As FilterBarMode
'Usage
 
Dim instance As FilterBar
Dim value As FilterBarMode
 
instance.FilterBarMode = value
 
value = instance.FilterBarMode
public FilterBarMode FilterBarMode {get; set;}

Property Value

The filter bar mode.
Example
This example sets the FilterBarMode property.
protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack) return;
            for (int i = 0; i < FpSpread1.ActiveSheetView.RowCount; i++)
                for (int j = 0; j < FpSpread1.ActiveSheetView.ColumnCount; j++)
                {
                    FpSpread1.ActiveSheetView.Cells[i, j].Value = i + j;
                }

            FarPoint.Web.Spread.FilterBarCellType fbc = new FarPoint.Web.Spread.FilterBarCellType();
            fbc.MenuType = FarPoint.Web.Spread.FilterMenuType.Auto;
            FpSpread1.ActiveSheetView.FilterBar.DefaultStyle.CellType = fbc;
            FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar;
            FpSpread1.ActiveSheetView.FilterBar.FilterBarMode = FarPoint.Web.Spread.FilterBarMode.Dynamic;
        }
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If (IsPostBack) Then
            Return
        End If        
        For i As Integer = 0 To FpSpread1.ActiveSheetView.RowCount - 1
            For j As Integer = 0 To FpSpread1.ActiveSheetView.ColumnCount - 1
                FpSpread1.ActiveSheetView.Cells(i, j).Value = i + j
            Next
        Next
        Dim fbc As New FarPoint.Web.Spread.FilterBarCellType()
        fbc.MenuType = FarPoint.Web.Spread.FilterMenuType.Auto
        FpSpread1.ActiveSheetView.FilterBar.DefaultStyle.CellType = fbc
        FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
        FpSpread1.ActiveSheetView.FilterBar.FilterBarMode = FarPoint.Web.Spread.FilterBarMode.Dynamic
    End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FilterBar Class
FilterBar Members

 

 


Copyright © GrapeCity, inc. All rights reserved.