'Declaration Public Class NumberCellType Inherits EditBaseCellType Implements FarPoint.Win.ISerializeSupport, IAutoCompleteSupport, ICellType, IEditFormula, IEditor, IEditorVerticaAlignSupport, IErrorIconSupport, IFormatter, INotifyEditorValueChanged, IPdfSupport, IPropertyAllowedSupport, IReadOnlySupport, IRenderAlignment, IRenderer, IReuseEditorControl, IReuseEditorControl2, IShrinkToFitSupport, IStaticSupport, IStringTrimmingSupport, ITextOrientationSupport, ITextOrientationSupport2, IWordWrapSupport, FarPoint.Win.Spread.IAllowArrowKeysMoveActiveCell, FarPoint.Win.Spread.IEnhancedPdfRenderer, FarPoint.Win.Spread.IEnhancedRenderer, FarPoint.Win.Spread.IFormulaEditingSupport
'Usage Dim instance As NumberCellType
public class NumberCellType : EditBaseCellType, FarPoint.Win.ISerializeSupport, IAutoCompleteSupport, ICellType, IEditFormula, IEditor, IEditorVerticaAlignSupport, IErrorIconSupport, IFormatter, INotifyEditorValueChanged, IPdfSupport, IPropertyAllowedSupport, IReadOnlySupport, IRenderAlignment, IRenderer, IReuseEditorControl, IReuseEditorControl2, IShrinkToFitSupport, IStaticSupport, IStringTrimmingSupport, ITextOrientationSupport, ITextOrientationSupport2, IWordWrapSupport, FarPoint.Win.Spread.IAllowArrowKeysMoveActiveCell, FarPoint.Win.Spread.IEnhancedPdfRenderer, FarPoint.Win.Spread.IEnhancedRenderer, FarPoint.Win.Spread.IFormulaEditingSupport
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.
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.
System.Object
FarPoint.Win.Spread.CellType.BaseCellType
FarPoint.Win.Spread.CellType.EditBaseCellType
FarPoint.Win.Spread.CellType.NumberCellType
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10