SSpread.TypeCurrencySymbol Property

Set the currency symbol in a currency type cell.

Only valid for cells with the CellType property set to $CellTypeCurrency (currrency type). Before setting this property, use the Col , Row properties etc. to specify what you want to do.

The initial value is a blank string ( according to OS settings).

Show / hide the currency symbol with the TypeCurrencyShowSymbol property. Set the decimal separator in the TypeCurrencyDecimal property and the thousands separator in the TypeCurrencySeparator property.

This property is subject to property inheritance of currency type cells.

Example of use

Col = 3;
Row = 2;
CellType = $CellTypeCurrency;
TypeCurrencySymbol = "$";
Value = 1.23;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeCurrency;
TypeCurrencySymbol = "￡";
Value = 4.56;
BlockMode = $FALSE;

Related item
CellType , TypeCurrencyDecimal , TypeCurrencySeparator , TypeCurrencyShowSymbol properties