Spread 8.0 Documentation
TypeSpin Property
Support Options
ActiveX Reference > ActiveX Properties > TypeSpin Property

Glossary Item Box

TypeSpin Property


See Also    DLL    Example

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

C++

BOOL CSpreadSheet::GetTypeSpin( );
void CSpreadSheet::SetTypeSpin(BOOL value);

Visual Basic

[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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.