TypeNegRed Property
Applies To
fpSpread control
Description
Sets or returns whether a negative number in a cell displays in red. This property is available at run time only.
Syntax
BOOL CSpreadSheet::GetTypeNegRed( );
void CSpreadSheet::SetTypeNegRed(BOOL value);
[form.]fpSpread.TypeNegRed[ = boolean%]
Remarks
The default value for the TypeNegRed property is False. If the TypeNegRed property is set to True, the sheet will display negative numbers as red in currency, number, and percent cells.
To use the TypeNegRed property, specify the sheet with which you want to work by setting the Sheet property. Then specify the cell or cells to which to apply the property, as described in Using Column and Row Properties.
For currency and number cells, you can also specify the style of negative numbers using the TypeCurrencyNegStyle and TypeNumberNegStyle properties.
The TypeNegRed property does not have an effect unless the CellType property is set to 12 (Currency), 13 (Number), or 14 (Percent) for the specified cell or cells and there is a negative number in the cell.
Spread Designer
Choose the Cell menu, the Cell Type menu, the Currency, Number, or Percent menu, and then the Settings tab, and then select the Show Negative in Red check box in the Cell Type Settings dialog box.
Data Type
Integer (Boolean)
See Also
Formatting a Currency Cell
Formatting a Number Cell
Formatting a Percent Cell
CellType, Sheet, TypeCurrencyNegStyle, TypeNumberNegStyle, TypePercentNegStyle properties
DLL Correspondence
SSSetTypeCurrencyEx, SSSetTypeNumberEx, SSSetTypePercentEx functions