Link Search Menu Expand Document
KLCV DEV MANUAL

SSpread.TypeSpinWrap Property

With the spin button displayed in the cell, set the operation when the set upper limit value and lower limit value are reached.

Only valid for cells with the following values ​​set in the CellType property.
$CellTypeCurrency
$CellTypeNumber
$CellTypePercent

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

Specify $TRUE if you want to wrap the value, or $FALSE if you do not want to change the value . The initial value is $FALSE .

The spin button is displayed when the TypeSpin property is set to $TRUE .

This property is subject to property inheritance for each data type cells .

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypeNumber;
TypeSpin = $ TRUE;
TypeSpinWrap = $ TRUE;
TypeNumberMin = 0;
TypeNumberMax = 10;
Value = 0;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeCurrency;
TypeSpin = $ TRUE;
TypeSpinInc = 100.0;
TypeSpinWrap = $ TRUE;
TypeCurrencyMin = 0;
TypeCurrencyMax = 500;
TypeCurrencyDecPlaces = 0;
Value = 0;
BlockMode = $ FALSE;

Related item
CellType , TypeSpin , TypeSpinInc property