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


In This Topic
    DateTimeFormat Property (FilterBarCellType)
    In This Topic
    Gets or sets a DateTimeFormatInfo object that defines the format for displaying dates and times.
    Syntax
    'Declaration
     
    Public Overridable Property DateTimeFormat As DateTimeFormatInfo
    'Usage
     
    Dim instance As FilterBarCellType
    Dim value As DateTimeFormatInfo
     
    instance.DateTimeFormat = value
     
    value = instance.DateTimeFormat
    public virtual DateTimeFormatInfo DateTimeFormat {get; set;}
    Example
    This example uses the DateTimeFormat property.
    FarPoint.Web.Spread.FilterBarCellType ct = new FarPoint.Web.Spread.FilterBarCellType();
    ct.MenuType = FarPoint.Web.Spread.FilterMenuType.Date;            
    System.Globalization.DateTimeFormatInfo dtformat = new System.Globalization.DateTimeFormatInfo();
    dtformat.ShortDatePattern = "yy/MM/dd";
    dtformat.ShortTimePattern = "";
    dtformat.LongTimePattern = "";
    ct.DateTimeFormat = dtformat;
    ct.DatePickerMode = FarPoint.Web.Spread.DatePickerMode.Auto;
    
    FarPoint.Web.Spread.FilterBarCellType ct1 = new FarPoint.Web.Spread.FilterBarCellType();
    ct1.FormatString = "dd";
    ct1.MenuType = FarPoint.Web.Spread.FilterMenuType.Date;
               
    FarPoint.Web.Spread.FilterBarCellType ct2 = new FarPoint.Web.Spread.FilterBarCellType();   
    ct2.MenuType = FarPoint.Web.Spread.FilterMenuType.Number;
    
    FpSpread1.ActiveSheetView.FilterBar.Cells[0].CellType = ct;
    FpSpread1.ActiveSheetView.FilterBar.Cells[0].BackColor = System.Drawing.Color.Red;
    FpSpread1.ActiveSheetView.FilterBar.Cells[1].CellType = ct1;
    FpSpread1.ActiveSheetView.FilterBar.Cells[1].BackColor = System.Drawing.Color.Aqua;
    FpSpread1.ActiveSheetView.FilterBar.Cells[2].CellType = ct2;
    FpSpread1.ActiveSheetView.FilterBar.Cells[2].BackColor = System.Drawing.Color.Yellow;
               
    FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar;
    FpSpread1.ActiveSheetView.Cells[0, 0].CellType = new FarPoint.Web.Spread.DateTimeCellType();
    FpSpread1.ActiveSheetView.Cells[0, 1].CellType = new FarPoint.Web.Spread.DateTimeCellType();
    FpSpread1.ActiveSheetView.Cells[0, 2].CellType = new FarPoint.Web.Spread.CurrencyCellType();
    FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;
    FpSpread1.ActiveSheetView.Cells[0, 1].Value = DateTime.Today;
    FpSpread1.ActiveSheetView.Cells[0, 2].Value = 33.34;
    Dim ct As New FarPoint.Web.Spread.FilterBarCellType()
    ct.MenuType = FarPoint.Web.Spread.FilterMenuType.Date
    Dim dtformat As New System.Globalization.DateTimeFormatInfo()
    dtformat.ShortDatePattern = "yy/MM/dd"
    dtformat.ShortTimePattern = ""
    dtformat.LongTimePattern = ""
    ct.DateTimeFormat = dtformat
    ct.DatePickerMode = FarPoint.Web.Spread.DatePickerMode.Auto
    
    Dim ct1 As New FarPoint.Web.Spread.FilterBarCellType()
    ct1.FormatString = "dd"
    ct1.MenuType = FarPoint.Web.Spread.FilterMenuType.Date
    
    Dim ct2 As New FarPoint.Web.Spread.FilterBarCellType()
    ct2.MenuType = FarPoint.Web.Spread.FilterMenuType.Number
    
    FpSpread1.ActiveSheetView.FilterBar.Cells(0).CellType = ct
    FpSpread1.ActiveSheetView.FilterBar.Cells(0).BackColor = System.Drawing.Color.Red
    FpSpread1.ActiveSheetView.FilterBar.Cells(1).CellType = ct1
    FpSpread1.ActiveSheetView.FilterBar.Cells(1).BackColor = System.Drawing.Color.Aqua
    FpSpread1.ActiveSheetView.FilterBar.Cells(2).CellType = ct2
    FpSpread1.ActiveSheetView.FilterBar.Cells(2).BackColor = System.Drawing.Color.Yellow
    FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
    FpSpread1.ActiveSheetView.Cells(0, 0).CellType = New FarPoint.Web.Spread.DateTimeCellType()
    FpSpread1.ActiveSheetView.Cells(0, 1).CellType = New FarPoint.Web.Spread.DateTimeCellType()
    FpSpread1.ActiveSheetView.Cells(0, 2).CellType = New FarPoint.Web.Spread.CurrencyCellType()
    FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now
    FpSpread1.ActiveSheetView.Cells(0, 1).Value = DateTime.Today
    FpSpread1.ActiveSheetView.Cells(0, 2).Value = 33.34
    See Also