PowerTools SPREAD for ASP.NET 8.0J
FilterBarMode プロパティ

フィルタバーモードを取得または設定します。
構文
'Declaration
 
Public Property FilterBarMode As FilterBarMode
public FilterBarMode FilterBarMode {get; set;}

プロパティ値

フィルタバーモード。
次のサンプルコードは、FilterBarModeプロパティを設定します。
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 メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.