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

Glossary Item Box

TypeCurrencyNegStyle Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the format for negative values in a currency cell. This property is available at run time only.

Syntax

C++

long CSpreadSheet::GetTypeCurrencyNegStyle( );
void CSpreadSheet::SetTypeCurrencyNegStyle(long value);

Visual Basic

[form.]fpSpread.TypeCurrencyNegStyle[ = setting%]

Remarks

The following settings are available:

Setting Description Constants
0 - Intl (Default) Uses the regional Currency Format setting in the Windows Control Panel TypeCurrencyNegStyleIntl
1 ($1.1) TypeCurrencyNegStyle1
2 –$1.1 TypeCurrencyNegStyle2
3 $–1.1 TypeCurrencyNegStyle3
4 $1.1– TypeCurrencyNegStyle4
5 (1.1$) TypeCurrencyNegStyle5
6 –1.1$ TypeCurrencyNegStyle6
7 1.1-$ TypeCurrencyNegStyle7
8 1.1$– TypeCurrencyNegStyle8
9 –1.1 $ TypeCurrencyNegStyle9
10 –$ 1.1 TypeCurrencyNegStyle10
11 1.1 $– TypeCurrencyNegStyle11
12 $ 1.1– TypeCurrencyNegStyle12
13 $ –1.1 TypeCurrencyNegStyle13
14 1.1– $ TypeCurrencyNegStyle14
15 ($ 1.1) TypeCurrencyNegStyle15
16 (1.1 $) TypeCurrencyNegStyle16

Notes:
  • In the preceding descriptions, the dollar sign ($) represents the currency symbol specified by the TypeCurrencySymbol property.
  • The control does not recognize changes made to the Windows regional settings or options until you restart your development environment or your application (or perform any operation that unloads and reloads the current control files). For more information about regional settings or options and Windows operating environments, see Variations in Windows Regional Settings or Options.

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

The TypeCurrencyNegStyle property does not have an effect unless the CellType property is set to 12 (Currency) for the specified cell or cells and there is a negative value in the cell or cells.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Currency menu, and then the Settings tab, and then select an item in the Negative Style combo box in the Cell Type Settings dialog box.

Data Type

Integer (Enumerated)

See Also

Variations in Windows Regional Settings or Options
Formatting a Currency Cell

CellType, Sheet, TypeCurrencyDecimal, TypeCurrencyDecPlaces, TypeCurrencyLeadingZero, TypeCurrencyMax, TypeCurrencyMin, TypeCurrencyPosStyle, TypeCurrencySeparator, TypeCurrencyShowSep, TypeCurrencyShowSymbol, TypeCurrencySymbol properties

DLL Correspondence

SSSetTypeCurrencyEx function

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