Link Search Menu Expand Document

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