SSpread.TypeTimeMax Property

In the time cell, set the upper limit of the date that can be entered.

Only valid for cells with the CellType property set to $ CellTypeTime . Before setting this property, use the Col , Row properties, and so on to specify what to do.

Specify in HHMMSS format. The initial value is “235959” .

The lower limit is specified by the TypeTimeMin property. The spin button displayed by the TypeSpin property allows you to increase or decrease the value within the specified range. When the TypeSpinWrap property is set to $ TRUE , the values ​​that have reached the upper and lower limits are wrapped.

This property is subject to property inheritance for time cells .

Precautions when specifying the range by the lower limit value and upper limit value

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypeTime;
TypeTimeMin = "080000";
TypeTimeMax = "205959";
Value = str (sysdate (), "HHMISS");
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeTime;
TypeTimeMin = "060000";
TypeTimeMax = "225959";
Value = str (sysdate (), "HHMISS");
BlockMode = $ FALSE;

Related item
CellType , TypeTimeMin , TypeSpin , TypeSpinWrap properties