SSpread.TypeEditCharSet Property

Set the type of characters that can be entered in a cell in a text cell.

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

Specify the following values. The initial value is $TypeEditCharSetASCII .

Constant	Value	Explanation
$TypeEditCharSetASCII	0	All characters
$TypeEditCharSetAlpha	1	A to Z , a to z , half-width space
$TypeEditCharSetAlphanumeric	2	A to Z , a to z , 0 to 9 , half-width space, period ( . ), comma ( , ), minus ( - )
$TypeEditCharSetNumeric	3	0 to 9 , period ( . ), minus ( - )
$TypeEditCharSetKanjiOnly	4	Full-width characters (*) , half-width spaces
$TypeEditCharSetKanjiOnlyIME	5	Full- width characters (*) , half-width spaces ( IME automatic ON / OFF )
$TypeEditCharSetAllIME	6	All characters ( IME auto ON/OFF )

*Full-width characters: Characters other than half-width alphanumeric characters, half-width symbols, and half-width kana

It applies to all input data, including user input, pasting from the clipboard, and setting values from scripts.
It does not apply to the data already set in the cell when you change this property.

$TypeEditCharSetKanjiOnlyIME and $TypeEditCharSetAllIME control IME. IME is automatically turned on when the target cell becomes the active cell . IME is automatically turned off when the target cell is no longer the active cell.

This property is subject to property inheritance for character cells.

Use case

Col = 3;
Row = 2;
CellType = $CellTypeEdit;
TypeEditCharSet = $TypeEditCharSetAlpha;
Text = "sample";
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeEdit;
TypeEditCharSet = $TypeEditCharSetAllIME;
Text = " Ah ";
BlockMode = $FALSE;