Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / GeneralCellType Class / IsDateFormat Property
Example


In This Topic
    IsDateFormat Property (GeneralCellType)
    In This Topic
    Gets or sets whether the format string being used is a date-time format string.
    Syntax
    'Declaration
     
    Public Overridable Property IsDateFormat As Boolean
    'Usage
     
    Dim instance As GeneralCellType
    Dim value As Boolean
     
    instance.IsDateFormat = value
     
    value = instance.IsDateFormat
    public virtual bool IsDateFormat {get; set;}

    Property Value

    True if the GeneralFormatter class's SetFormatString method was called with the isDateFormat parameter set to true; false otherwise
    true if date-time; false otherwise
    Example
    System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
    dtf.LongDatePattern = "D";
    dtf.ShortDatePattern = "M/d/yyyy";
    FarPoint.Web.Spread.GeneralCellType g = new FarPoint.Web.Spread.GeneralCellType();
    g.DateTimeFormat = dtf;
    g.FormatString = dtf.ShortDatePattern
    g.IsDateFormat = true;
    FpSpread1.ActiveSheetView.Cells[0, 0].CellType = g;
    FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;
    
    Dim dtf As New System.Globalization.DateTimeFormatInfo
    Dim b As Boolean
    dtf.LongDatePattern = "D"
    dtf.ShortDatePattern = "M/d/yyyy"
    Dim g As New FarPoint.Web.Spread.GeneralCellType
    g.DateTimeFormat = dtf
    g.FormatString = dtf.ShortDatePattern
    g.IsDateFormat = True
    FpSpread1.ActiveSheetView.Cells(0, 0).CellType = g
    FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now
    See Also