SSpread.TypeMaxEditLen Property

Set the maximum number of characters that can be entered in a cell.

Only valid for cells with the CellType property.
$CellTypeEdit (character type)
$CellTypeComboBox (combo box type)

Before setting this property, use the Col , Row properties, and so on to specify what to do.

The initial value is 32000 (character) for the character cell and 150 (character) for the combo box cell .
Negative values are automatically corrected to 0 .
For character cells, specifying 0 prevents you from entering characters ( cancelled ) . For combo box cells, specifying 0 limits the number of characters.
Please note that the operation differs depending on the Cell Type .

This property is subject to property inheritance for character cells and combo box cells .

Notes on property inheritance of combo box type cells

Example of use

Col= 3;
Row = 2;
CellType = $ CellTypeComboBox;
TypeComboBoxEditable = $ TRUE;
TypeMaxEditLen = 20;
 
BlockMode = $ TRUE;
Col= 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeEdit;
TypeMaxEditLen = 50;
BlockMode = $ FALSE;
 