SSpread.TypeNegRed Property
Set whether to display negative numbers in red.
Only valid for cells with the CellType property.
$CellTypeCurrency
$CellTypeNumber
$CellTypePercent
$CellTypeScientific
Before setting this property, use the Col , Row properties, and so on to specify what to do.
Specify $TRUE to display negative numbers in red, otherwise $FALSE . The initial value is $FALSE .
This property is subject to property inheritance for data type cell.
Example of use
Col = 3;
Row = 2;
CellType = $CellTypeNumber;
TypeNegRed = $TRUE;
Value = -123;
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypePercent;
TypeNegRed = $TRUE;
Value = -0.123;
BlockMode = $FALSE;
Related item
CellType , TypeCurrencyNegStyle , TypeNumberNegStyle, TypePercentNegStyle property