TypeSpinWrap Property

Applies To

fpSpread control

Description

Sets or returns whether the value of the spin button in a currency, number, or percent cell wraps when the maximum or minimum values are reached. This property is available at run time only.

Syntax

C++

BOOL CSpreadSheet::GetTypeSpinWrap( );
void CSpreadSheet::SetTypeSpinWrap(BOOL value);

Visual Basic

[form.]fpSpread.TypeSpinWrap[ = boolean%]

Remarks

The default value for the TypeSpinWrap property is False.

You can have the currency, number, or percent cell display a spin button that lets users increment the value to the minimum or maximum value allowed in the cell. To have the cell display a spin button, set the TypeSpin property for the cell to True. The spin button can wrap the value from the maximum to the minimum or vice versa if you set this property to True. You can specify by how many increments the value changes when the user presses the spin button by setting the TypeSpinInc property.

To use the TypeSpinWrap 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 TypeSpinWrap property for a currency, number, or percent cell or cells, any subsequent currency, number, or percent cells you create will use the same TypeSpinWrap setting unless you reset it for those cells.

The TypeSpinWrap property does not have an effect unless the CellType property is set to 12 (Currency), 13, (Number), or 14 (Percent) and the TypeSpin property is set to True for the specified cell or cells.

Use the TypeCurrencyMax, TypeCurrencyMin, TypeNumberMax, TypeNumberMin, TypePercentMax, and TypePercentMin properties to specify the maximum and minimum allowed values for the cell.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Currency, Number, or Percent menu, and then the Settings tab, and then select the Wrap Spin check box in the Spin Button group box in the Cell Type Settings dialog box.

Data Type

Integer (Boolean)

DLL Correspondence

SSSetTypeCurrencyEx, SSSetTypeNumberEx, SSSetTypePercentEx functions