Visual Basic (Declaration) | |
---|---|
Public Class DateTimeCellType Inherits EditBaseCellType Implements FarPoint.Win.ISerializeSupport, IAutoCompleteSupport, ICellType, IDateTimeCellType, IEditFormula, IEditor, IFormatter, INotifyEditorValueChanged, IPdfSupport, IPropertyAllowedSupport, IReadOnlySupport, IRenderAlignment, IRenderer, IReuseEditorControl, IReuseEditorControl2, IStaticSupport, IWordWrapSupport, FarPoint.Win.Spread.IFormulaEditingSupport |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As DateTimeCellType |
This can be used to display Date or Time or both. In MS Excel, Date and Time formats are separate, but in Spread, the DateTimeCellType can be used to handle both dates and times.
By default, settings from the Windows Regional Settings or Regional Options provide the culture-specific formatting. You can set several format options for date and time using the properties in this class.
For more information about setting the cell type, refer to Setting a Date-Time Cell.
For more information about the behavior of contents in a cell of this type, refer to Understanding Cell Type Effects on Displaying Data.
System.Object
FarPoint.Win.Spread.CellType.BaseCellType
FarPoint.Win.Spread.CellType.EditBaseCellType
FarPoint.Win.Spread.CellType.DateTimeCellType
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
Reference
DateTimeCellType MembersFarPoint.Win.Spread.CellType Namespace
User-Task Documentation
Setting a Date-Time CellWorking with Editable Cell Types