Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / DateTimeCellType Class / DateTimeCellType Constructor / DateTimeCellType Constructor()
Example


In This Topic
    DateTimeCellType Constructor()
    In This Topic
    Creates a new date-time cell.
    Syntax
    'Declaration
     
    Public Function New()
    'Usage
     
    Dim instance As New DateTimeCellType()
    public DateTimeCellType()
    Example
    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;
    dt.MaximumValue = new Date(2020, 12, 31);
    dt.MinimumValue = new Date(1950, 1, 1);
    FpSpread1.ActiveSheetView.Cells[0, 0].CellType = dt;
    FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;
    
    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
    dt.MaximumValue = New Date(2020, 12, 31)
    dt.MinimumValue = New Date(1950, 1, 1)
    FpSpread1.ActiveSheetView.Cells(0, 0).CellType = dt
    FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now
    See Also