Skip to main content
A newer version of this page is available. .
.NET Framework 4.5.2+
Row

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.v19.1.Core.dll

Declaration

bool IsDisplayedAsDateTime { get; }

Property Value

Type Description
Boolean

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 Range.Value property is set to a DateTime object.
  • A cell’s Range.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