TypePercentDecPlaces Property

---

See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the number of digits allowed to the right of the decimal character in a percent cell. This property is available at run time only.

Syntax

short CSpreadSheet::GetTypePercentDecPlaces( );
void CSpreadSheet::SetTypePercentDecPlaces(short value);

[form.]fpSpread.TypePercentDecPlaces[ = value%]

Remarks

The default value for the TypePercentDecPlaces property is two decimal places. The maximum total number of numerals in the cell is 14.

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

The TypePercentDecPlaces property does not have an effect unless the CellType property is set to 14 (Percent) for the specified cell or cells.

You can specify a different character to display as the decimal character by setting the TypePercentDecimal property.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Percent menu, and then the Settings tab, and then type a number in the Decimal Places edit box in the Cell Type Settings dialog box.

Data Type

Integer

See Also

Creating and Customizing Percent Cells

CellType, Sheet, TypePercentDecimal, TypePercentLeadingZero, TypePercentMax, TypePercentMin, TypePercentNegStyle properties

DLL Correspondence

SSSetTypePercent function