Link Search Menu Expand Document

SSpread.TypeCurrencyPosStyle Property

Format a positive number in a currency cell.

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

Specify the following values. The initial value is $TypeCurrencyPosStyleIntl.

Constant Value Explanation
$TypeCurrencyPosStyleIntl 0 Follow OS settings
$TypeCurrencyPosStyle1 1 \1.1
$TypeCurrencyPosStyle2 2 1.1\
$TypeCurrencyPosStyle3 3 \ 1.1
$TypeCurrencyPosStyle4 4 1.1 \

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

Use case

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

Related item
CellType property