SSpread.TypeDateCentury Property

In the date cell, set whether to display the year in the Christian era in 4 digits.

Only valid for cells with the CellType property set to $CellTypeDate (date type). Before setting this property, use the Col , Row properties etc. to specify what you want to process.

Specify $TRUE for 4 -digit display and $FALSE for 2 -digit display . The initial value is the setting value of the OS .

When using two digits for the year , the base year is set with the TwoDigitYearMax property.

This property is subject to property inheritance of date type cells.

Example of use

Col = 3;
Row = 2;
CellType = $CellTypeDate;
TypeDateCentury = $FALSE;
TwoDigitYearMax = 2100; /* 2 digits are in the 2000s * /
Value = str(sysdate(), "YYYYMMDD");
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeDate;
TypeDateCentury = $ TRUE;
Value = str(sysdate(), "YYYYMMDD");
BlockMode = $FALSE;

Related item
CellType , TwoDigitYearMax properties