TypeCurrencyPosStyle Property
Applies To
fpSpread control
Description
Sets or returns the format for positive values in a currency cell. This property is available at run time only.
Syntax
long CSpreadSheet::GetTypeCurrencyPosStyle( );
void CSpreadSheet::SetTypeCurrencyPosStyle(long value);
[form.]fpSpread.TypeCurrencyPosStyle[ = setting%]
Remarks
The following settings are available:
Setting | Description | Constants |
---|---|---|
0 - Intl | (Default) Uses the regional Currency Format setting in the Windows Control Panel | TypeCurrencyPosStyleIntl |
1 | $1.1 | TypeCurrencyPosStyle1 |
2 | 1.1$ | TypeCurrencyPosStyle2 |
3 | $ 1.1 | TypeCurrencyPosStyle3 |
4 | 1.1 $ | TypeCurrencyPosStyle4 |
Notes:
|
To use the TypeCurrencyPosStyle 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 TypeCurrencyPosStyle property for a cell or cells, any subsequent currency cells you create will use the same TypeCurrencyPosStyle setting unless you reset it for those cells.
The TypeCurrencyPosStyle property does not have an effect unless the CellType property is set to 12 (Currency) for the specified cell or cells and the cells contain positive values.
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 Positive 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, TypeCurrencyNegStyle, TypeCurrencySeparator, TypeCurrencyShowSep, TypeCurrencyShowSymbol, TypeCurrencySymbol properties
DLL Correspondence
SSSetTypeCurrencyEx function