SSpread.TypeEditCharCase Property

Set whether text cells are automatically converted to uppercase or lowercase.

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

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

Constant	Value	Explanation
$ TypeEditCharCaseSetLower	0	Convert to lowercase
$TypeEditCharCaseSetNone	1	No conversion
$ TypeEditCharCaseSetUpper	2	Convert to uppercase

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.

This property is subject to property inheritance for character cells.

Use case

Col = 3;
Row = 2;
CellType = $ CellTypeEdit;
TypeEditCharCase = $ TypeEditCharCaseSetLower;
Text = "abcDEF";
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeEdit;
TypeEditCharCase = $ TypeEditCharCaseSetUpper;
Text = "abcDEF";
BlockMode = $FALSE;