SSpread.TypeTimeSeparator Property

To set the hour, minute, and second delimiters in the time cell.

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.

For the delimiter , specify the Unicode character code as a numerical value. If you want to use a colon, set it to 58 ( 0x3A , ‘:’ ). Do not specify illegal characters that cannot be displayed correctly, such as control characters and special characters.

If 63 ( 0x3F , ‘?’ ) Is set, “hour, minute, second” will be the delimiter. If set to 0 , the OS setting value will be set. The initial value is the OS setting value.

This property is subject to property inheritance for time cells .

use case

Col = 3;
Row = 2;
CellType = $CellTypeTime;
TypeTimeSeconds = $TRUE;
TypeTimeSeparator = 0x3F; /* '?' */
Value = str(sysdate(), "HHMISS");
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeTime;
TypeTimeSeparator = 0x2D; /* '-' */
Value = str(sysdate(), "HHMISS");
BlockMode = $FALSE;