Link Search Menu Expand Document

SSpread.TypePercentMin Property

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

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

The initial value is -9999.99 .

The upper limit is specified by the TypePercentMax 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 percentage cells.

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

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypePercent;
TypePercentMin = 0;
TypePercentMax = 100;
Value = 0;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypePercent;
TypePercentMin = -100;
TypePercentMax = 100;
Value = 0;
BlockMode = $ FALSE;

Related item
CellType, TypePercentMax, TypeSpin, TypeSpinWrap properties.