FilterBarMode プロパティ

Visual Basic
C#

'Declaration
 
Public Property FilterBarMode As FilterBarMode

public FilterBarMode FilterBarMode {get; set;}

プロパティ値

フィルタバーモード。

次のサンプルコードは、FilterBarModeプロパティを設定します。

C#
Visual Basic

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

FilterBar クラス
 FilterBar メンバ