DateTimeFormat Enumeration

Specifies the formatting for date and time.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum DateTimeFormat 
   Inherits System.Enum

'Usage
 
Dim instance As DateTimeFormat

public enum DateTimeFormat : System.Enum

Members

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

Example

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

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

Inheritance Hierarchy

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

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