SSpread.TypeSpinInc Property

Sets the amount of change due to a single click of the spin button displayed in the cell .

Only valid for cells with the following values ​​set in the CellType property.
$CellTypeCurrency (currency type)
$CellTypeNumber (number type)
$CellTypePercent (percent type)

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

When the cursor is in the integer part, the value of the integer part of the number set in this property increases or decreases. When the cursor is in the fractional part, the value of the decimal part of the number set in this property increases or decreases. The initial value is 1.1 (integer increment is 1 and fractional increment is 0.1 ).

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;
TypeSpinInc = 2.2;
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;
TypeCurrencyDecPlaces = 0;
Value = 0;
BlockMode = $ FALSE;

Related item
CellType , TypeSpin , TypeSpinWrap property