Spread 8.0 Documentation
DLL
Support Options

Glossary Item Box

DLL


To create and customize a currency cell

  1. If you want to display a currency symbol and a leading zero in values between 1.0 and –1.0, to display spin buttons, to specify the format characters used to display currency, the thousands separator, and the decimal character, or to specify the positive and negative style, call the SSSetTypeCurrencyEx function. For more information, see Formatting a Currency Cell.
    If you want to display the separator character and use the default characters used to display currency, the thousands separator, and the decimal character, call the SSSetTypeCurrency function. Set the parameters for the functions as follows:
    1. Set the Max parameter to specify the maximum value for the cell.
    2. Set the Min parameter to specify the minimum value for the cell.
    3. Set the Right parameter to specify the number of digits allowed to the right of the decimal symbol.

      Note: The total number of digits to the left and right of the decimal symbol cannot total more than 14.

    4. Set the ShowSep parameter to TRUE to display the separator character used to separate groups of thousands digits (for example, the comma in "$1,000").
    5. Set the Style parameter to specify:
      • how data is horizontally and vertically aligned in the cell
      • how text is oriented in the cell
      • whether negative numbers display in red
  2. Call the SSSetCellType or SSSetCellTypeRange function and set the CellType parameter to SS_TYPE_CURRENCY.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.