DateTimeCellType Class

Represents a date-time cell.

Object Model

Syntax

Visual Basic
C#

'Declaration
 
Public Class DateTimeCellType 
   Inherits EditBaseCellType
   Implements FarPoint.Win.ISerializeSupport, IAutoCompleteSupport, ICellType, IDateTimeCellType, IEditFormula, IEditor, IEditorVerticaAlignSupport, IErrorIconSupport, IFormatter, INotifyEditorValueChanged, IPdfSupport, IPropertyAllowedSupport, IReadOnlySupport, IRenderAlignment, IRenderer, IReuseEditorControl, IReuseEditorControl2, IShrinkToFitSupport, IStaticSupport, IStringTrimmingSupport, ITextOrientationSupport, ITextOrientationSupport2, IWordWrapSupport, FarPoint.Win.Spread.IAllowArrowKeysMoveActiveCell, FarPoint.Win.Spread.IEnhancedPdfRenderer, FarPoint.Win.Spread.IEnhancedRenderer, FarPoint.Win.Spread.IFormulaEditingSupport

'Usage
 
Dim instance As DateTimeCellType

public class DateTimeCellType : EditBaseCellType, FarPoint.Win.ISerializeSupport, IAutoCompleteSupport, ICellType, IDateTimeCellType, IEditFormula, IEditor, IEditorVerticaAlignSupport, IErrorIconSupport, IFormatter, INotifyEditorValueChanged, IPdfSupport, IPropertyAllowedSupport, IReadOnlySupport, IRenderAlignment, IRenderer, IReuseEditorControl, IReuseEditorControl2, IShrinkToFitSupport, IStaticSupport, IStringTrimmingSupport, ITextOrientationSupport, ITextOrientationSupport2, IWordWrapSupport, FarPoint.Win.Spread.IAllowArrowKeysMoveActiveCell, FarPoint.Win.Spread.IEnhancedPdfRenderer, FarPoint.Win.Spread.IEnhancedRenderer, FarPoint.Win.Spread.IFormulaEditingSupport

Remarks

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.

Inheritance Hierarchy

System.Object
   FarPoint.Win.Spread.CellType.BaseCellType
      FarPoint.Win.Spread.CellType.EditBaseCellType
         FarPoint.Win.Spread.CellType.DateTimeCellType

Reference

DateTimeCellType Members
FarPoint.Win.Spread.CellType Namespace

User-Task Documentation

Setting a Date-Time Cell
Working with Editable Cell Types