DatePickerMode Enumeration

Specifies how to display the DatePicker control in the filter bar.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum DatePickerMode 
   Inherits System.Enum

'Usage
 
Dim instance As DatePickerMode

public enum DatePickerMode : System.Enum

Members

Member	Description
Auto	Shows or hides the DatePicker control based on the type of data in the column. If the drop-down button is not displayed, the date picker button is not displayed.
Hide	Hides the DatePicker control in the filter bar.
Show	Shows the DatePicker control in the filter bar.

Example

This example sets the DatePickerMode enumeration.

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;
}

VB.NET

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

Inheritance Hierarchy

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

Reference

FarPoint.Web.Spread Namespace