Spread 8.0 Documentation
DLL
Support Options

Glossary Item Box

DLL


To create and customize a number cell

  1. If you want to display a leading zero in values between 1.0 and –1.0, to display spin buttons, to specify the format characters used to display the thousands separator and the decimal character, or to specify the negative style, call the SSSetTypeNumberEx function.
    If you want to display the separator character and use the regional default characters used to display the thousands separator and the decimal character, call the SSSetTypeNumber 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_NUMBER.
Copyright © GrapeCity, inc. All rights reserved.