Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetDateTimeSystem Enum

Enumerates available date/time formats for the Spreadsheet and Report Designer controls.

#Declaration

Delphi
TdxSpreadSheetDateTimeSystem = (
    dts1900,
    dts1904,
    dtsDefault
);

#Members

Name
dts1900
dts1904
dtsDefault

#Remarks

Options include:

Value Description
dts1900 This format is based on a system where an integer value is the number of days elapsed since January 1, 1900. For instance, the serial number of July 5, 1998 is 35981.
dts1904 This format is based on a system where an integer value is the number of days elapsed since January 1, 1904. For instance, the serial number of July 5, 1998 is 34519.
dtsDefault The default date/time format used by the Spreadsheet and Report Designer controls. The control’s OptionsView.ActualDateTimeSystem property returns dts1900 if the default format is selected.

The Spreadsheet/Report Designer control’s OptionsView.ActualDateTimeSystem and OptionsView.DateTimeSystem properties reference the TdxSpreadSheetDateTimeSystem type.

See Also