FilterBarCellType コンストラクタ(Boolean)

FilterBarCellTypeクラスの新しいインスタンスを初期化します。

構文

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal dropDownButton As Boolean _
)

public FilterBarCellType( 
   bool dropDownButton
)

パラメータ

dropDownButton: ドロップダウンボタンの場合はtrue。

例

次のサンプルコードは、フィルタバー型セルを作成します。

C#
Visual Basic

protected void Page_Load(object sender, EventArgs e)
{
    if (this.IsPostBack) return;
    FarPoint.Web.Spread.DateTimeCellType dt = new FarPoint.Web.Spread.DateTimeCellType();
    System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
    dtf.LongDatePattern = "D";
    dtf.ShortDatePattern = "M/d/yyyy";
    dt.DateTimeFormat = dtf;
    FpSpread1.Sheets[0].Cells[0, 0, 0, 2].CellType = dt;
    FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;
    
    FarPoint.Web.Spread.FilterBarCellType fbcell = new FarPoint.Web.Spread.FilterBarCellType(true);
    fbcell.DatePickerMode = FarPoint.Web.Spread.DatePickerMode.Auto;
    
    FpSpread1.Sheets[0].RowCount = 6;
    FpSpread1.Sheets[0].ColumnCount = 6;
    //Customize "Cells" in Filter Bar
    FarPoint.Web.Spread.SheetView sheetView = FpSpread1.ActiveSheetView;
    sheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar;  
    sheetView.FilterBar.Cells[0].CellType = fbcell;
    sheetView.FilterBar.Cells[0].BackColor = System.Drawing.Color.Aqua;
}

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load
    If IsPostBack Then
        Return
    End If
    Dim dt As New FarPoint.Web.Spread.DateTimeCellType()
    Dim dtf As New System.Globalization.DateTimeFormatInfo()
    dtf.LongDatePattern = "D"
    dtf.ShortDatePattern = "M/d/yyyy"
    dt.DateTimeFormat = dtf
    FpSpread1.Sheets(0).Cells(0, 0, 0, 2).CellType = dt
    FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now
    
    Dim fbcell As New FarPoint.Web.Spread.FilterBarCellType(True)
    fbcell.DatePickerMode = FarPoint.Web.Spread.DatePickerMode.Auto
    
    FpSpread1.Sheets(0).RowCount = 6
    FpSpread1.Sheets(0).ColumnCount = 6
    'Customize "Cells" in Filter Bar
    Dim sheetView As FarPoint.Web.Spread.SheetView = FpSpread1.ActiveSheetView
    sheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
    sheetView.FilterBar.Cells(0).CellType = fbcell
    sheetView.FilterBar.Cells(0).BackColor = System.Drawing.Color.Aqua
End Sub

参照

FilterBarCellType クラス
 FilterBarCellType メンバ
 オーバーロード一覧