DateTimeFormat Enumeration

Visual Basic
C#

'Declaration
 
Public Enum DateTimeFormat 
   Inherits System.Enum

'Usage
 
Dim instance As DateTimeFormat

public enum DateTimeFormat : System.Enum

Member	Description
LongDate	Uses the long form for the date
LongDateWithTime	Uses the long form for the date and time
ShortDate	Uses the abbreviated form for the date
ShortDateWithTime	Uses the abbreviated form for the date and time
TimeOnly	Uses the time only (no date)
UserDefined	Uses the user-defined date and time format

This examples specifies that the format for a date-time cell should be an abbreviated date with the time included.

C#

FarPoint.Win.Spread.CellType.DateTimeCellType dattimct = new FarPoint.Win.Spread.CellType.DateTimeCellType();
System.DateTime spectime = new System.DateTime(2003, 1, 7, 10, 10, 5);
dattimct.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = dattimct;
fpSpread1.ActiveSheet.Cells[0, 0].Value = spectime;
fpSpread1.ActiveSheet.Columns[0].Width = 200;

Visual Basic

Dim dattimct As New FarPoint.Win.Spread.CellType.DateTimeCellType()
Dim spectime As New System.DateTime(2003, 1, 7, 10, 10, 5)
dattimct.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime
fpSpread1.ActiveSheet.Cells(0, 0).CellType = dattimct
fpSpread1.ActiveSheet.Cells(0, 0).Value = spectime
fpSpread1.ActiveSheet.Columns(0).Width = 200

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.CellType.DateTimeFormat

Reference

FarPoint.Win.Spread.CellType Namespace
DateTimeFormat Property (DateTimeCellType Class)
DateTimeFormat Property (GeneralCellType Class)

User-Task Documentation

Setting a Date-Time Cell
Setting a General Cell