Spread Windows Forms 6.0 Product Documentation
DateTimeFormat Enumeration
Example  See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : DateTimeFormat Enumeration


Glossary Item Box

Specifies the formatting for date and time.

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

MemberDescription
LongDateUses the long form for the date
LongDateWithTimeUses the long form for the date and time
ShortDateUses the abbreviated form for the date
ShortDateWithTimeUses the abbreviated form for the date and time
TimeOnlyUses the time only (no date)
UserDefinedUses 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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.