Cell.IsDisplayedAsDateTime Property

Indicates whether a numeric value contained in the cell is displayed as a date and time value.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

bool IsDisplayedAsDateTime { get; }

ReadOnly Property IsDisplayedAsDateTime As Boolean

Property Value

true , if a date and time format is applied to the cell; otherwise, false.

|

Remarks

A date and time format is automatically applied to a cell in the following cases.

• A cell’s CellRange.Value property is set to a DateTime object.
• A cell’s CellRange.Value property is set to an object returned by the CellValue.FromDateTime method.
• A date and time value or a formula that returns a date and time value is entered into a cell via the SpreadsheetControl’s UI.

To apply a date and time format to a cell explicitly, assign the corresponding format code to the Formatting.NumberFormat property of the cell object. For details, see the How to: Specify Number or Date Format for Cell Content example.

See Also

Cell Data Types

Dates and Times in Cells

Cell Interface

Cell Members

DevExpress.Spreadsheet Namespace