The following tables list the members exposed by DateTimeCellType.
Public Constructors
| Name | Description | |
|---|---|---|
 | DateTimeCellType Constructor | Overloaded. |
Public Fields
| Name | Description | |
|---|---|---|
  | IncompleteValue | Gets the value returned from the editor if the editing value is partial and not empty. |
Public Properties
| Name | Description | |
|---|---|---|
 | AcceptsArrowKeys | Gets or sets how arrow keys are processed by the edit control. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| AllowArrowKeysMoveActiveCell | Gets or sets whether to allow arrow keys to move the active cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| AMString | Gets or sets the string to indicate morning for 12-hour time format. |
| AutoCompleteCustomSource | Gets or sets a custom string collection when the AutoCompleteSource property is set to CustomSource. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| AutoCompleteMode | Gets or sets how automatic completion works. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| AutoCompleteSource | Gets or sets the source of complete strings used for automatic completion. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| AutoFillAutoCompleteCustomSource | Gets or sets whether the AutoCompleteCustomSource is automatically filled with data from other cells in the column. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| BackgroundImage | Gets or sets the background image for the cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| ButtonAlign | Gets or sets where the buttons are displayed in the cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| Calendar | Gets or sets the calendar for formatting date values. |
| CalendarDayBackColor | Gets or sets the background color of the pop-up calendar in the date-time cell. |
| CalendarDayFont | Gets or sets the text font of the pop-up calendar in the date-time cell. |
| CalendarDayForeColor | Gets or sets the text color of the pop-up calendar in the date-time cell. |
| CalendarMonthBackColor | Gets or sets the background color of the month part of the pop-up calendar in the date-time cell. |
| CalendarMonthFont | Gets or sets the text font of the month part of the pop-up calendar in the date-time cell. |
| CalendarMonthForeColor | Gets or sets the text color of the month part of the pop-up calendar in the date-time cell. |
| CalendarMonthHeaderDock | Gets or sets how to dock the month header of the pop-up calendar in the date-time cell. |
| CalendarMonthHeaderHeight | Gets or sets the height of the month header of the pop-up calendar in the date-time cell. |
| CalendarMonthHeaderStyle | Gets or sets the style of the month header of the pop-up calendar in the date-time cell. |
| CalendarShowSurroundingDays | Gets or sets whether to show the surrounding days in the pop-up calendar in the date-time cell. |
| CalendarSingleLineHeader | Gets or sets the single line header of the pop-up calendar in the date-time cell. |
| CalendarSurroundingDaysColor | Gets or sets the color of the surrounding days of the pop-up calendar in the date-time cell. |
| CalendarWeekdayBackColor | Gets or sets the background color of the weekday part of the pop-up calendar in the date-time cell. |
| CalendarWeekdayFont | Gets or sets the text font of the weekday part of the pop-up calendar in the date-time cell. |
| CalendarWeekdayForeColor | Gets or sets the text color of the weekday part of the pop-up calendar in the date-time cell. |
| CalendarWeekdayHeaderDock | Gets or sets how to dock the weekday header of the pop-up calendar in the date-time cell. |
| CalendarWeekdayHeaderHeight | Gets or sets the height of the weekday header of the pop-up calendar in the date-time cell. |
| CalendarYearBackColor | Gets or sets the background color of the year part of the pop-up calendar in the date-time cell. |
| CalendarYearFont | Gets or sets the text font of the year part of the pop-up calendar in the date-time cell. |
| CalendarYearForeColor | Gets or sets the text color of the year part of the pop-up calendar in the date-time cell. |
| CalendarYearHeaderDock | Gets or sets how to dock the year header of the pop-up calendar in the date-time cell. |
| CalendarYearHeaderHeight | Gets or sets the height of the year header of the pop-up calendar in the date-time cell. |
| CalendarYearHeaderStyle | Gets or sets the style of the year header of the pop-up calendar in the date-time cell. |
| DateDefault | Gets or sets the default date for the control. |
| DateSeparator | Gets or sets the string that separates the portions of a date value. |
| DateTimeFormat | Gets or sets the format for displaying dates and times. |
| DayNames | Gets or sets alternate day names for the control (use with UserDefinedFormat). |
| DropDownButton | Gets or sets whether a drop-down button is displayed in the cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| EditorValue | Gets or sets what value is written to the underlying data model. |
| EnableSubEditor | Gets or sets whether the SubEditor is available. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| FocusPosition | Gets or sets the initial cursor position. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| MaximumDate | Gets or sets the maximum date value allowed for user entry. |
| MaximumTime | Gets or sets the maximum time value allowed for user entry. |
| MinimumDate | Gets or sets the minimum date value allowed for user entry. |
| MinimumTime | Gets or sets the minimum time value allowed for user entry. |
| MonthNames | Gets or sets alternate month names for the control (use with UserDefinedFormat). |
| NullDisplay | Gets or sets the text to display for null values. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| PMString | Gets or sets the string to indicate afternoon and evening for 12-hour time format. |
| ReadOnly | Gets or sets whether the cell is read-only (and thus cannot be modified). (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| ShortDayNames | Gets or sets alternate short day names for the control (use with UserDefinedFormat). |
| ShortMonthNames | Gets or sets alternate short month names for the control (use with UserDefinedFormat). |
| ShrinkToFit | Gets or sets whether to shrink the text to fit the cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| SimpleEdit | Gets or sets whether the celltype ignores invalid character input while editing. |
| SpinButton | Gets or sets whether a spin button is displayed while editing. |
| Static | Gets or sets whether the cell is static, which prohibits user interaction. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| StringTrim | Gets or sets how to trim characters that do not fit in the cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| SubEditor | Gets or sets the subeditor. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| TextOrientation | Gets or sets how text orients itself when painting the cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| TextRotationAngle | Gets or sets the rotation angle of the text for the cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| TimeDefault | Gets or sets the default time used in the control. |
| TimeSeparator | Gets or sets the string that separates the portions of a time value. |
| TwoDigitYearMax | Gets or sets the last year of a 100-year range that can be represented by a 2-digit year. |
| UserDefinedFormat | Gets or sets the format used when the date-time format is user-defined. |
| WordWrap | Gets or sets whether text that is too long to fit in the cell wraps to additional lines. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
Protected Properties
| Name | Description | |
|---|---|---|
 | ExtraRendererSettings | Gets the conditional formatting settings. (Inherited from FarPoint.Win.Spread.CellType.BaseCellType) |
Public Methods
| Name | Description | |
|---|---|---|
 | CanBeOverflown | Determines whether data from another cell can overflow into this cell (whether this cell can be overflowed into). (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| CancelEditing | Cancels the editing of a cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| CanOverflow | Determines whether the cell can overflow into adjacent cells. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| Clone | Overridden. Creates and returns a date-time cell. |
| Deserialize | Overridden. Loads the object from XML. |
| Format | Overridden. Formats the specified data into the format of the cell type and returns it as a string. |
| GetEditorControl | Overloaded. Overridden. Gets the edit control for this cell type with the specified appearance and scaling. |
| GetEditorValue | Overridden. Gets the unformatted value in the editor control. |
| GetErrorIconBound | (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| GetHorizontalAlignment | Gets the horizontal alignment based on the value. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| GetPreferredSize | Overloaded. Overridden. Gets the preferred (maximum required) size of the cell for the editor control. |
| GetReservedCursor | Gets the cursor reserved for this cell type. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| GetReusableEditorControl | Implementation of IReuseEditorControl.GetEditorControl for use by cell types. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| GetVerticalAlignment | Gets the vertical alignment based on the value. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| IsPropertySupported | Gets whether the cell type supports the named property. (Inherited from FarPoint.Win.Spread.CellType.BaseCellType) |
| IsReservedKey | Determines whether the specified key has special meaning to the editor control. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| IsReservedLocation | Determines whether the specified cursor location has special meaning to the editor control. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| IsReusable | Checks if this celltype is reusable. |
| IsValid | Overridden. Determines whether the specified value can be converted to a date-time value and is between the minimum and maximum allowed values. |
| PaintCell | Overloaded. Paints (prints) the cell to PDF. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| Parse | Overridden. Parses the specified string to the data type of the cell type and returns it as an object. |
| Serialize | Overridden. Saves the object to XML. |
| SetCalendarFormat | Sets the format to be used for the pop-up calendar header. |
| SetCalendarText | Overloaded. Sets the various text elements for the pop-up calendar, including the day and month names and the button text. |
| SetCurrentCulture | Gets or sets the current culture. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| SetEditorValue | Overridden. Sets the value of the editor control. |
| ShowSubEditor | Shows the subeditor control associated with the cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| StartEditing | Starts the editing of a cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| StopEditing | Stops the editing of a cell. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
Protected Methods
| Name | Description | |
|---|---|---|
 | FireEditorValueChanged | Fires the EditorValueChanged event if there are any delegates attached. (Inherited from FarPoint.Win.Spread.CellType.BaseCellType) |
| GetAMStringDesignator | Gets the AM string for formatting time values. |
| GetDateSeparatorString | Gets the date separator string for formatting date values. |
| GetDayNames | Gets the long day names for formatting date values. |
| GetLongDateFormat | Gets the long date format for formatting date values. |
| GetMonthNames | Gets the long month names for formatting date values. |
| GetNewFormat | Gets the new format for formatting date values or time values or both. |
| GetPMStringDesignator | Gets the PM string for formatting time values. |
| GetShortDateFormat | Gets the short date format for formatting date values. |
| GetShortDayNames | Gets the short day names for formatting date values. |
| GetShortMonthNames | Gets the short month names for formatting date values. |
| GetTextRectangle | Gets the rectangle in which text is drawn. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| GetTimeFormat | Gets the time format for formatting time values. |
| GetTimeSeparatorString | Gets the time separator string for formatting time values. |
| IsCaretInTheBeginning | Gets whether the caret is in the beginning. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| IsCaretInTheEnd | Gets whether the caret is at the end. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| IsCaretInTheFirstLine | Gets whether the caret is in the first line. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| IsCaretInTheLastLine | Gets whether the caret is in the last line. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| PaintEnhancedConditionalFormat | Paints the enhanced conditional format. (Inherited from FarPoint.Win.Spread.CellType.BaseCellType) |
| SetNewFormat | Sets the new format (returned by GetNewFormat) into the internal cell formatter. |
| ToHorizontalAlignment | Converts a FarPoint.Win.Spread.CellHorizontalAlignment value to the corresponding FarPoint.Win.HorizontalAlignment value. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
| ToVerticalAlignment | Converts a FarPoint.Win.Spread.CellVerticalAlignment value to the corresponding FarPoint.Win.VerticalAlignment value. (Inherited from FarPoint.Win.Spread.CellType.EditBaseCellType) |
Public Events
| Name | Description | |
|---|---|---|
 | EditingCanceled | Occurs when editing (the editor control) has been canceled by the user. (Inherited from FarPoint.Win.Spread.CellType.BaseCellType) |
| EditingStopped | Occurs when editing in the the editor control has been stopped by the user. (Inherited from FarPoint.Win.Spread.CellType.BaseCellType) |
| EditorValueChanged | Occurs when the value in the editor control has been changed by the user. (Inherited from FarPoint.Win.Spread.CellType.BaseCellType) |
See Also
Reference
DateTimeCellType ClassFarPoint.Win.Spread.CellType Namespace
User-Task Documentation
Setting a Date-Time CellWorking with Editable Cell Types