TypeSpin Property
Applies To
fpSpread control
Description
Sets or returns whether a spin button is displayed in a currency, date, number, percent, or time cell. This property is available at run time only.
Syntax
BOOL CSpreadSheet::GetTypeSpin( );
void CSpreadSheet::SetTypeSpin(BOOL value);
[form.]fpSpread.TypeSpin[ = boolean%]
Remarks
The default value for the TypeSpin property is False.
Spin buttons in cells allow users to press the buttons to increment or decrement values to the maximum and minimum allowed values for the cell. The spin button is displayed only if edit mode is on.
In currency, number, and percent cells, you can let the value wrap from maximum to minimum and vice versa when the cell reaches the maximum or minimum value by setting the TypeSpinWrap property to True. You can also specify the increment by which the value changes in currency, number, and percent cells by setting the TypeSpinInc property.
To use the TypeSpin property, specify the sheet with which you want to work by setting the Sheet property. Then specify the cell or cells to which to apply the property, as described in Using Column and Row Properties. Once you set the TypeSpin property for a currency, date, number, percent, or time cell or cells, any subsequent currency, date, number, percent, or time cells you create will use the same TypeSpin setting unless you reset it for those cells.
The TypeSpin property does not have an effect unless the CellType property is set to 0 (Date), 6 (Time), 12 (Currency), 13 (Number), or 14 (Percent) for the specified cell or cells.
Spread Designer
Choose the Cell menu, the Cell Type menu, the Date or Time menu, and then the Settings tab, and then select the Display Spin Button check box in the Cell Type Settings dialog box. Choose the Cell menu, the Cell Type menu, the Currency, Number, or Percent menu, and then the Settings tab, and then select the Display check box in the Spin Button group box in the Cell Type Settings dialog box.
Data Type
Integer (Boolean)
See Also
Formatting a Currency Cell
Formatting a Date Cell
Formatting a Number Cell
Formatting a Percent Cell
Creating and Customizing a Time Cell
CellType, Sheet, TypeCurrencyMax, TypeCurrencyMin, TypeNumberMax, TypeNumberMin, TypePercentMax, TypePercentMin, TypeSpinInc, TypeSpinWrap properties
DLL Correspondence
SSSetTypeDate, SSSetTypeCurrencyEx, SSSetTypeNumberEx, SSSetTypePercentEx, SSSetTypeTime functions