SSpread.TypeCurrencyShowSymbol Property

Set whether to display currency symbols in currency type cells.

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

Specify $TRUE if you want to display it, or $FALSE if you do not wish to display it. The initial value is $TRUE .

The thousands separator can be changed with the TypeCurrencySymbol property.

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

Use case

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

Related item
CellType , TypeCurrencySymbol property