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


In This Topic
    DateTimeFormat Property (GeneralCellType)
    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 GeneralCellType
    Dim value As DateTimeFormatInfo
     
    instance.DateTimeFormat = value
     
    value = instance.DateTimeFormat
    public virtual DateTimeFormatInfo DateTimeFormat {get; set;}

    Property Value

    DateTimeFormatInfo object containing the format for date and time values
    Example
    This example specifies the format string used to format the date value.
    FarPoint.Win.Spread.CellType.GeneralCellType genlcell = new FarPoint.Win.Spread.CellType.GeneralCellType();
    System.Globalization.DateTimeFormatInfo dtinfo; 
    dtinfo = System.Globalization.DateTimeFormatInfo.CurrentInfo;
    genlcell.DateTimeFormat = dtinfo;
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = genlcell;
    fpSpread1.ActiveSheet.Cells[0, 0].Value = DateTime.Now;
    Dim genlcell As New FarPoint.Win.Spread.CellType.GeneralCellType()
    Dim dtinfo As New System.Globalization.DateTimeFormatInfo()
    genlcell.DateTimeFormat = dtinfo.CurrentInfo
    FpSpread1.ActiveSheet.Cells(0, 0).CellType = genlcell
    FpSpread1.ActiveSheet.Cells(0, 0).Value = DateTime.Now
    See Also