TdxSpreadSheetDateTimeSystem Enum

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

Declaration

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.