TypeCurrencySeparator Property

Applies To

fpSpread control

Description

Sets or returns the separator character used to separate groups of thousands digits in currency cells (for example, the comma in "$1,000"). This property is available only at run time.

Syntax

C++

CString CSpreadSheet::GetTypeCurrencySeparator( );
void CSpreadSheet::SetTypeCurrencySeparator(LPCTSTR value);

Visual Basic

[form.]fpSpread.TypeCurrencySeparator[ = text$]

Remarks

The default value for the TypeCurrencySeparator character is a Null value, which means to display the separator character specified by the regional Currency Digital Grouping Symbol setting in the Windows Control Panel.

Note: 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.

You can designate more than one character as the separator.

A currency cell will not display the specified separator unless the TypeCurrencyShowSep property is set to True for that cell.

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

The TypeCurrencySeparator property does not have an effect unless the CellType property is set to 12 (Currency) for the specified cell or cells and the TypeCurrencyShowSep property is set to True.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Currency menu, and then the Settings tab, and then type a symbol in the Symbol edit box next to Show Separator in the Cell Type Settings dialog box.

Data Type

String

DLL Correspondence

SSSetTypeCurrencyEx function