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