FarPoint.Win.Spread
DateTimeFormat Enumeration
Example  See Also 
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : DateTimeFormat Enumeration


Specifies the formatting for date and time.

Syntax

Visual Basic (Declaration) 
Public Enum DateTimeFormat 
   Inherits Enum
Visual Basic (Usage)Copy Code
Dim instance As DateTimeFormat
C# 
public enum DateTimeFormat : Enum

Members

MemberDescription
ShortDate Uses the abbreviated form for the date
LongDate Uses the long form for the date
ShortDateWithTime Uses the abbreviated form for the date and time
LongDateWithTime Uses the long 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.
C#Copy Code
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 BasicCopy Code
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

See Also