MESCIUS SPREAD for ASP.NET 10.0J
DatePickerMode 列挙体

フィルタバーでのDatePickerコントロールの表示方法を指定します。
構文
'Declaration
 
Public Enum DatePickerMode 
   Inherits System.Enum
public enum DatePickerMode : System.Enum 
メンバ
メンバ説明
Auto列のデータの型に基づいてDatePickerコントロールを表示するかどうかを決定します。ドロップダウンボタンが表示されていない場合、日付ピッカーボタンは表示されません。
HideフィルタバーにDatePickerコントロールを表示しません。
ShowフィルタバーにDatePickerコントロールを表示します。
次のサンプルコードは、DatePickerMode列挙体を設定します。
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
継承階層

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.DatePickerMode

参照

FarPoint.Web.Spread 名前空間

 

 


© MESCIUS inc. All rights reserved.