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

Glossary Item Box

Creating Currency Cells


Overview

Currency cells display numbers in monetary formats and offer a variety of formatting options, as shown in the following figure:

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

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

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

TypeCurrencyDecimal TypeCurrencySeparator TypeSpin
TypeCurrencyDecPlaces TypeCurrencyShowSep TypeSpinInc
TypeCurrencyLeadingZero TypeCurrencyShowSymbol TypeSpinWrap
TypeCurrencyMax TypeCurrencySymbol TypeTextOrient
TypeCurrencyMin TypeEllipses TypeVAlign
TypeCurrencyNegStyle TypeHAlign
TypeCurrencyPosStyle TypeNegRed

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