Spread 8.0 Documentation
TypeNegRed Property
Support Options
ActiveX Reference > ActiveX Properties > TypeNegRed Property

Glossary Item Box

TypeNegRed Property


See Also    DLL    Example

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

C++

BOOL CSpreadSheet::GetTypeNegRed( );
void CSpreadSheet::SetTypeNegRed(BOOL value);

Visual Basic

[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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.