SSpread.TypeCurrencyNegStyle Property
Format a negative 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 $TypeCurrencyNegStyleIntl .
| Ｃonstant | Ｖalue | Ｅxplanation |
|---|---|---|
| $TypeCurrencyNegStyleIntl | 0 | Follow OS settings |
| $TypeCurrencyNegStyle1 | 1 | (\ 1.1) |
| $TypeCurrencyNegStyle2 | 2 | -\1.1 |
| $TypeCurrencyNegStyle3 | 3 | \-1.1 |
| $TypeCurrencyNegStyle4 | 4 | \ 1.1- |
| $TypeCurrencyNegStyle5 | 5 | (1.1 \) |
| $TypeCurrencyNegStyle6 | 6 | -1.1 \ |
| $TypeCurrencyNegStyle7 | 7 | 1.1-\ |
| $TypeCurrencyNegStyle8 | 8 | 1.1\- |
| $TypeCurrencyNegStyle9 | 9 | -1.1\ |
| $TypeCurrencyNegStyle10 | 10 | -\ 1.1 |
| $TypeCurrencyNegStyle11 | 11 | 1.1 \- |
| $TypeCurrencyNegStyle12 | 12 | \1.1- |
| $TypeCurrencyNegStyle13 | 13 | \ -1.1 |
| $TypeCurrencyNegStyle14 | 14 | 1.1- \ |
| $TypeCurrencyNegStyle15 | 15 | (\ 1.1) |
| $TypeCurrencyNegStyle16 | 16 | (1.1 \) |
You can display negative numbers in red by setting the TypeNegRed property to $TRUE .
This property is subject to property inheritance of currency type cells.
Use case
Col = 3;
Row = 2;
CellType = $ CellTypeCurrency;
TypeCurrencyNegStyle = $TypeCurrencyNegStyle1;
Value = -1.23;
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeCurrency;
TypeCurrencyNegStyle = $ TypeCurrencyNegStyle3;
Value = -4.56;
BlockMode = $ FALSE;
Related item
CellType , TypeNegRed property