SSpread.TypeNumberMin Property

Set the lower limit that can be entered in the numeric cell.

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

The initial value is -9999999.99 .

The upper limit is specified by the TypeNumberMax property. The spin button displayed by the TypeSpin property allows you to increase or decrease the value within the specified range. When the TypeSpinWrap property is set to $ TRUE , the values ​​that have reached the upper and lower limits are wrapped.

This property is subject to property inheritance for numeric cells.

Precautions for specifying the range based on the lower and upper limits

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypeNumber;
TypeNumberMin = 0;
TypeNumberMax = 100;
Value = 0;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeNumber;
TypeNumberMin = -100;
TypeNumberMax = 100;
Value = 0;
BlockMode = $ FALSE;

Related item
CellType , TypeNumberMax , TypeSpin , TypeSpinWrap property