Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum DateTimeFormat Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As DateTimeFormat | |
| C# | |
|---|---|
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.
| 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 Basic | Copy 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
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