NumberCellType Class

Represents a numeric cell with formatting that you can specify.

Inheritance

object

BaseCellType

EditBaseCellType

NumberCellType

Namespace: FarPoint.Win.Spread.CellType

Assembly: FarPoint.Win.Spread.dll

Syntax

public class NumberCellType : EditBaseCellType, ICellType, IEditor, ICloneable, IPropertyAllowedSupport, INotifyEditorValueChanged, IEnhancedPdfRenderer, IPdfSupport, IAllowArrowKeysMoveActiveCell, IErrorIconSupport, IEditorVerticaAlignSupport, ICellType, ICloneable<ICellType>, INumFmtSupportCellType, ISerializeSupport, IEditFormula, IRenderAlignment, IReadOnlySupport, IStaticSupport, IWordWrapSupport, IDisposable, IFormulaEditingSupport, IAutoCompleteSupport, IShrinkToFitSupport, IFormatter, IStringTrimmingSupport, ITextOrientationSupport2, ITextOrientationSupport, IEnhancedRenderer, IRenderer, IDisplayFormulaSupport, ISerializable, IFormulaEditor, IReuseEditorControl2, IReuseEditorControl

Public Class NumberCellType
    Inherits EditBaseCellType
    Implements ICellType, IEditor, ICloneable, IPropertyAllowedSupport, INotifyEditorValueChanged, IEnhancedPdfRenderer, IPdfSupport, IAllowArrowKeysMoveActiveCell, IErrorIconSupport, IEditorVerticaAlignSupport, ICellType, ICloneable(Of ICellType), INumFmtSupportCellType, ISerializeSupport, IEditFormula, IRenderAlignment, IReadOnlySupport, IStaticSupport, IWordWrapSupport, IDisposable, IFormulaEditingSupport, IAutoCompleteSupport, IShrinkToFitSupport, IFormatter, IStringTrimmingSupport, ITextOrientationSupport2, ITextOrientationSupport, IEnhancedRenderer, IRenderer, IDisplayFormulaSupport, ISerializable, IFormulaEditor, IReuseEditorControl2, IReuseEditorControl

Constructors

Name	Description
NumberCellType()	Creates a new numeric cell with default settings.
NumberCellType(NumberCellType)	Creates a new copy from the specified cell type ("Copy constructor").
NumberCellType(SerializationInfo, StreamingContext)	Creates a new numeric cell from serialization.

Properties

Name	Description
AllowUserFormulas	Gets or sets whether to allow the user to enter formulas in a cell in the component.
DecimalPlaces	Gets or sets the number of decimal places.
DecimalSeparator	Gets or sets the decimal character.
FixedPoint	Gets or sets whether to display zeros as placeholders in the decimal portion of the number for a fixed-point numeric display.
FractionConvertWholeNumbers	Gets or sets whether to convert whole numbers to fractions when values are displayed as fractions.
FractionCustomFormat	Gets or sets how values are displayed as fractions with custom formatting.
FractionDenominatorDigits	Gets or sets the number of digits when values are displayed as fractions.
FractionDenominatorPrecision	Gets or sets the precision when values are displayed as fractions.
FractionMode	Gets or sets whether values are represented as fractions.
FractionRenderOnly	Gets or sets whether to allow fractions in edit mode when values are displayed as fractions.
LeadingZero	Gets or sets whether leading zeros are displayed.
MaximumValue	Gets or sets the maximum value allowed for user input.
MinimumValue	Gets or sets the minimum value allowed for user entry.
NegativeFormat	Gets or sets how the value is formatted for negative values.
NegativeRed	Gets or sets whether negative numeric values are displayed in red.
OverflowCharacter	Gets or sets the character used to replace the value if it does not fit the width of the display.
Separator	Gets or sets the string used to separate thousands in a numeric value.
ShowSeparator	Gets or sets whether to display the thousands separator string.
SpinButton	Gets or sets whether a spin button is displayed when editing.
SpinDecimalIncrement	Gets or sets the amount by which the value increments when using the spin buttons and the cursor is in the decimal portion.
SpinIntegerIncrement	Gets or sets the amount by which the value increments when using the spin buttons and the cursor is in the integer portion.
SpinWrap	Gets or sets whether the value wraps when the minimum or maximum is reached.

Methods

Name	Description
Clone()	Creates and returns a numeric cell.
Deserialize(XmlNodeReader)	Loads the object from XML.
Format(object)	Formats the specified data into the format of the cell type and returns it as a string.
GetEditorControl(Appearance, float)	Gets the edit control for this cell type with the specified appearance and scaling.
GetEditorControl(Control, Appearance, float)	Gets the edit control for this cell type with the specified appearance and scaling.
GetNewFormat()	Gets the format string for formatting the numeric value.
GetObjectData(SerializationInfo, StreamingContext)	Serializes the cell type.
GetPreferredSize(Graphics, Size, Appearance, object, float)	Gets the preferred (maximum required) size of the cell for the editor control.
GetSeparatorCharacter()	Gets the separator character for formatting the numeric value.
InitializeEditorControl(Control, Appearance, float)	Initializes the editor control.
IsReusable(Control)	Checks if this celltype is reusable.
IsValid(object)	Determines whether the specified value can be converted to a double-precision, floating point value and is between the minimum and maximum allowed values.
PaintCell(Graphics, Rectangle, Appearance, object, bool, bool, float)	Overrides the PaintCell to provide fraction support.
Parse(string)	Parses the specified string to the data type of the cell type and returns it as an object.
Serialize(XmlTextWriter)	Saves the object to XML.
SetCalculatorText(string, string)	Sets the text for the pop-up calculator.
SetEditorValue(object)	Sets the value of the editor control.