TypeNumberNegStyle Property
Applies To
fpSpread control
Description
Sets or returns the format for negative values in a number cell. This property is available at run time only.
Syntax
long CSpreadSheet::GetTypeNumberNegStyle( );
void CSpreadSheet::SetTypeNumberNegStyle(long value);
[form.]fpSpread.TypeNumberNegStyle[ = setting%]
Remarks
The following settings are available:
Setting | Description | Constants |
---|---|---|
0 - Intl | (Default) Uses the regional Number Format setting in the Windows Control Panel | TypeNumberNegStyleIntl |
1 | (1.1) | TypeNumberNegStyle1 |
2 | –1.1 | TypeNumberNegStyle2 |
3 | – 1.1 | TypeNumberNegStyle3 |
4 | 1.1– | TypeNumberNegStyle4 |
5 | 1.1 – | TypeNumberNegStyle5 |
Note: The control does not recognize changes made to the Windows regional settings or options until you restart your development environment or your application (or perform any operation that unloads and reloads the current control files). For more information about regional settings or options and Windows operating environments, see Variations in Windows Regional Settings or Options. |
To use the TypeNumberNegStyle 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. Once you set the TypeNumberNegStyle property for a cell or cells, any subsequent number cells you create will use the same TypeNumberNegStyle setting unless you reset it for those cells.
The TypeNumberNegStyle property does not have an effect unless the CellType property is set to 13 (Number) for the specified cell or cells.
Spread Designer
Choose the Cell menu, the Cell Type menu, the Number menu, and then the Settings tab, and then select an item in the Negative Style drop-down list box in the Cell Type Settings dialog box.
Data Type
Integer (Enumerated)
See Also
Variations in Windows Regional Settings or Options
Formatting a Number Cell
CellType, Sheet, TypeNumberDecimal, TypeNumberDecPlaces, TypeNumberLeadingZero, TypeNumberMax, TypeNumberMin, TypeNumberSeparator, TypeNumberShowSep properties
DLL Correspondence
SSSetTypeNumberEx function