Spread for ASP.NET 9.0 Product Documentation
DateTimeFormat Property (DateTimeCellType)
Example 


Gets or sets a DateTimeFormatInfo that defines the format for displaying dates and times.
Syntax
'Declaration
 
Public Overrides Property DateTimeFormat As DateTimeFormatInfo
'Usage
 
Dim instance As DateTimeCellType
Dim value As DateTimeFormatInfo
 
instance.DateTimeFormat = value
 
value = instance.DateTimeFormat
public override DateTimeFormatInfo DateTimeFormat {get; set;}

Property Value

DateTimeFormatInfo object containing the format for date-time values
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
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

DateTimeCellType Class
DateTimeCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.