Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / FilterBarCellType Class / DateTimeFormatInfo Property
Example


In This Topic
    DateTimeFormatInfo Property
    In This Topic
    Gets or sets a DateTimeFormatInfo object that defines the format for displaying dates and times.
    Syntax
    'Declaration
     
    Public Property DateTimeFormatInfo As DateTimeFormatInfo
    'Usage
     
    Dim instance As FilterBarCellType
    Dim value As DateTimeFormatInfo
     
    instance.DateTimeFormatInfo = value
     
    value = instance.DateTimeFormatInfo
    public DateTimeFormatInfo DateTimeFormatInfo {get; set;}
    Example
    This example sets the DateTimeFormatInfo property.
    FarPoint.Win.Spread.CellType.FilterBarCellType ct = new FarPoint.Win.Spread.CellType.FilterBarCellType();
    ct.ShowDropDownMenuStrip = true;
    ct.ShowEditor = true;
    ct.ShowLabel = true;
    ct.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime;
    System.Globalization.DateTimeFormatInfo dtformat = new System.Globalization.DateTimeFormatInfo();
    dtformat.ShortDatePattern = "yy/MM/dd";
    dtformat.ShortTimePattern = "";
    dtformat.LongTimePattern = "";
    ct.DateTimeFormatInfo = dtformat;
    ct.AutoFormat = true;
    FarPoint.Win.Spread.CellType.FilterBarCellType ct1 = new FarPoint.Win.Spread.CellType.FilterBarCellType();
    ct1.ShowEditor = true;
    ct1.ShowLabel = true;
    ct1.FormatString = "dd";
    ct1.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime;
    ct1.AutoFormat = true;
    
    FarPoint.Win.Spread.CellType.FilterBarCellType ct2 = new FarPoint.Win.Spread.CellType.FilterBarCellType();
    ct2.ShowEditor = true;
    ct2.ShowLabel = true;
    System.Globalization.NumberFormatInfo num = new System.Globalization.NumberFormatInfo();
    num.CurrencySymbol = "$";
    num.CurrencyDecimalDigits = 3;
    ct2.NumberFormatInfo = num;
    ct2.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.Number;
    ct2.AutoFormat = true;
            
    fpSpread1.ActiveSheet.FilterBar.Cells[0].CellType = ct;
    fpSpread1.ActiveSheet.FilterBar.Cells[0].BackColor = Color.Red;
    fpSpread1.ActiveSheet.FilterBar.Cells[1].CellType = ct1;
    fpSpread1.ActiveSheet.FilterBar.Cells[1].BackColor = Color.Aqua;
    fpSpread1.ActiveSheet.FilterBar.Cells[2].CellType = ct2;
    fpSpread1.ActiveSheet.FilterBar.Cells[2].BackColor = Color.Yellow;
    fpSpread1.ActiveSheet.ColumnHeader.Columns[0].Label = "DateTime";
    fpSpread1.ActiveSheet.ColumnHeader.Columns[1].Label = "FormatString";
    fpSpread1.ActiveSheet.ColumnHeader.Columns[2].Label = "Number";
    fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
    fpSpread1.ActiveSheet.Cells[0, 1].CellType = new FarPoint.Win.Spread.CellType.DateTimeCellType();
    Dim ct As New FarPoint.Win.Spread.CellType.FilterBarCellType()
    ct.ShowDropDownMenuStrip = True
    ct.ShowEditor = True
    ct.ShowLabel = True
    ct.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime
    Dim dtformat As New System.Globalization.DateTimeFormatInfo()
    dtformat.ShortDatePattern = "yy/MM/dd"
    dtformat.ShortTimePattern = ""
    dtformat.LongTimePattern = ""
    ct.DateTimeFormatInfo = dtformat
    ct.AutoFormat = True
    Dim ct1 As New FarPoint.Win.Spread.CellType.FilterBarCellType()
    ct1.ShowEditor = True
    ct1.ShowLabel = True
    ct1.FormatString = "dd"
    ct1.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime
    ct1.AutoFormat = True
    
    Dim ct2 As New FarPoint.Win.Spread.CellType.FilterBarCellType()
    ct2.ShowEditor = True
    ct2.ShowLabel = True
    Dim num As New System.Globalization.NumberFormatInfo()
    num.CurrencySymbol = "$"
    num.CurrencyDecimalDigits = 3
    ct2.NumberFormatInfo = num
    ct2.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.Number
    ct2.AutoFormat = True
      
    FpSpread1.ActiveSheet.FilterBar.Cells(0).CellType = ct
    FpSpread1.ActiveSheet.FilterBar.Cells(0).BackColor = Color.Red
    FpSpread1.ActiveSheet.FilterBar.Cells(1).CellType = ct1
    FpSpread1.ActiveSheet.FilterBar.Cells(1).BackColor = Color.Aqua
    FpSpread1.ActiveSheet.FilterBar.Cells(2).CellType = ct2
    FpSpread1.ActiveSheet.FilterBar.Cells(2).BackColor = Color.Yellow
    FpSpread1.ActiveSheet.ColumnHeader.Columns(0).Label = "DateTime"
    FpSpread1.ActiveSheet.ColumnHeader.Columns(1).Label = "FormatString"
    FpSpread1.ActiveSheet.ColumnHeader.Columns(2).Label = "Number"
    FpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
    FpSpread1.ActiveSheet.Cells(0, 1).CellType = New FarPoint.Win.Spread.CellType.DateTimeCellType()
    See Also