SSpread.TypeSpin Property

Set whether to display the spin button in the cell.

Only valid for cells with the following values ​​set in the CellType property.
$CellTypeDate (date type)
$CellTypeTime (time type)
$CellTypeCurrency (currency type)
$CellTypeNumber (numerical type)
$CellTypePercent (percent type)

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

Specify $TRUE if want the spin button to appear, or else, $FALSE if don’t want the button to appear. The initial value is $FALSE .

The spin button is displayed when the cell is in input mode ( EditMode property is $ TRUE ). The user can increase or decrease the value by clicking a button.

You can specify the TypeSpinInc, TypeSpinWrap properties for currency, number, and percentage cells . The TypeSpinInc property sets the amount of change in the value with a single click, and the TypeSpinWrap property sets the behavior when the upper and lower limits of the cell are reached.

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

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypeDate;
TypeSpin = $ TRUE;
Value = str (sysdate (), "YYYYMMDD");
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeNumber;
TypeSpin = $ TRUE;
Value = 0;
BlockMode = $ FALSE;

Related item
CellType , TypeSpinInc , TypeSpinWrap property