Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FilterBarCellType Class / DatePickerMode Property
Example


In This Topic
    DatePickerMode Property
    In This Topic
    Gets or sets a value that indicates how to display the DatePicker control.
    Syntax
    'Declaration
     
    Public Property DatePickerMode As DatePickerMode
    'Usage
     
    Dim instance As FilterBarCellType
    Dim value As DatePickerMode
     
    instance.DatePickerMode = value
     
    value = instance.DatePickerMode
    public DatePickerMode DatePickerMode {get; set;}
    Example
    This example sets the DatePickerMode property.
    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
    See Also