Spread Windows Forms 11.0 Product Documentation
DateTimeFormat Property (GeneralCellType)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > GeneralCellType Class : DateTimeFormat Property
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

Reference

GeneralCellType Class
GeneralCellType Members