Spread 8.0 Documentation
DLL
Support Options

Glossary Item Box

DLL


To create and customize a scientific notation cell

  1. If you want to display an ellipsis, change the alignment, specify the decimal character, or specify the number of decimal digits, call the SSSetTypeScientific function.
    Set the parameters for the function 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 lpszDecimal parameter to the decimal character.
    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 to show an ellipsis
      • whether to show a negative number in red
  2. Call the SSSetCellType or SSSetCellTypeRange function and set the CellType parameter to SS_TYPE_SCIENTIFIC.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.