Spread 8.0 Documentation
DLL
Support Options

Glossary Item Box

DLL


To format a percent cell

  1. If you want to use the regional default character used to display the decimal character, call the SSSetTypePercent function.
    If you want to format the cell in any of the following ways, call the SSSetTypePercentEx function.
    • Display a leading zero in values between 1.0 and –1.0
    • Specify a custom decimal character
    • Specify the format of negative percent values
    Set the parameters for the functions as follows:
    1. Set the LeadingZero parameter to SS_LEADING_ZERO_NO to display values between 1.0 and –1.0 without a leading zero.
    2. Set the Decimal parameter to specify a custom decimal symbol.
    3. Set the NegCurrencyStyle to specify the format for negative values.
  2. Call the SSSetCellType or SSSetCellTypeRange function and set the CellType parameter to SS_TYPE_PERCENT.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.