Spread Windows Forms 6.0 Product Documentation
NumberCellType Class
Members  See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : NumberCellType Class


Glossary Item Box

Represents a numeric cell with formatting that you can specify.

Object Model

NumberCellType ClassPicture ClassISubEditor Interface

Syntax

Remarks

For more information about setting the cell type, refer to Setting a Number Cell.

Number cells support 15 significant digits of precision. This is a total of all digits, including the ones to the left (integer digits) and to the right (fractional digits). For example, when you have 5 fractional digits, you limit the number of integer digits to 10 digits. The maximum number of digits to the right of the decimal that you must have to maintain precision is 7.

There is the possibility of floating point errors with the Double data type. For more accurate precision of large numbers or numbers with large fractional portions, consider using a currency cell (CurrencyCellType class) which uses the Decimal data type and is not prone to floating point errors.

For more information about the behavior of contents in a cell, refer to Understanding Cell Type Effects on Displaying Data.

Inheritance Hierarchy

System.Object
   FarPoint.Win.Spread.CellType.BaseCellType
      FarPoint.Win.Spread.CellType.EditBaseCellType
         FarPoint.Win.Spread.CellType.NumberCellType

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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