Spread 8.0 Documentation
Creating Scientific Notation Cells
Support Options
User's Guide > Setting Up the Control > Setting the Cell Type > Creating Scientific Notation Cells

Glossary Item Box

Creating Scientific Notation Cells


Overview

Scientific cells display numbers in scientific notation and offer a variety of formatting options, as shown in the following figure:

You can customize the scientific cell's formatting, as well as characteristics such as the maximum and minimum values, and data alignment and orientation.

If you want to create a cell whose numeric value is expressed as currency, as a number, or as a percent, see Creating Currency Cells, Creating Number Cells, or Creating Percent Cells.

For a description of how scientific cells validate data, see Data Validation.

In summary, you can use the following properties to customize scientific notation cells. The italicized properties are unique to this cell type. For more information on remembered properties, refer to Cell Type Settings Remembered.

TypeEllipses TypeScientificDecPlaces TypeTextOrient
TypeHAlign TypeScientificMax TypeVAlign
TypeScientificDecimal TypeScientificMin

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.