SSpread.TypePicMask Property
Format the mask input in the mask cell.
Only valid for cells with the CellType property set to $CellTypePicture.
Before setting this property, use the Col , Row properties, and so on to specify what to do.
The character types that can be entered and their digit positions are set using the following definition characters. Only the character type corresponding to the definition character can be entered at the position where the definition character is set.
| Definition character | Character types that can be input |
|---|---|
| X | All characters (half-width and full-width) |
| 9 | Half-width numbers and decimal points |
| A | Half-width alphabet characters |
| N | Half-width alphabetic characters, half-width numbers and decimal point |
| U | Half-width uppercase letters |
| L | Half-width lowercase letters |
| H | Half - width hexadecimal numbers ( 0-9 , a - f , A - F ) |
| & | Full- width characters (*) , half-width spaces * Characters other than half-width alphanumericals, half-width symbols, and half-width kana |
If you specify a character other than the above, that character is fixedly displayed and the input to that digit position is skipped. If you want to pin the above definition characters themselves, you can escape them with a / (slash) in front of them ( / A , / X , / & , etc.). If you overlap the slashes ( // ), the slashes themselves will be fixed.
The initial value is a blank character string.
The TypePicDefaultText property allows you to set the character to be displayed as the initial value at the position of the definition character.
This property is subject to property inheritance for masked cells .
Use case
Col = 3;
Row = 2;
CellType = $CellTypePic;
TypePicMask = "999-9999";
TypePicDefaultText = "000-0000";
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypePic;
TypePicMask = "U99.99.99～U99.99.99";
TypePicDefaultText = "#__.__.__～#__.__.__";
BlockMode = $FALSE;
Related item
CellType, TypePicDefaultText properties.