TypeScientificDecimal Property

Applies To

fpSpread control

Description

Sets or returns the decimal character displayed in scientific notation in scientific cells. This property is available at run time only.

Syntax

C++

CString CSpreadSheet::GetTypeScientificDecimal( );
void CSpreadSheet::SetTypeScientificDecimal(LPCTSTR value);

Visual Basic

[form.]fpSpread.TypeScientificDecimal[ = text$]

Remarks

The default value for the TypeScientificDecimal property is a Null string, which means to display the decimal character specified by the regional Numbers Decimal Symbol setting in the Windows Control Panel.

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.

You can designate only one character as the decimal character.

To use the TypeScientificDecimal 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 TypeScientificDecimal property for a cell or cells, any subsequent scientific cells you create will use the same TypeScientificDecimal setting unless you reset it for those cells.

The TypeScientificDecimal property does not have an effect unless the CellType property is set to 15 (Scientific).

Specify the number of digits the cell displays to the right of the decimal point using the TypeScientificDecPlaces property.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Scientific menu, and then the Settings tab, and then type a symbol in the Decimal Symbol edit box in the Cell Type Settings dialog box.

Data Type

String

DLL Correspondence

SSSetTypeScientific function