You can create a GcNumber cell with the Spread Designer. This saves time when creating a cell. Open the Spread Designer. Select a cell or cells in the design area. Under the Home menu, select GcNumber in the CellType section. 
Cell Types Use the General tab in the Cell Type dialog to specify general behavior for the GcNumber cell. 
General Tab The following table lists the options for the General tab:
Option
Description
RecommendedValue
The RecommendedValue option can be used to provide a hint to the user.
MaxMinBehavior
The MaxMinBehavior option can be used to specify how to handle a value when the value is outside of the minimum or maximum range.
EditMode
The EditMode option can be used to specify insert or overwrite modes.
ClipContent
The ClipContent option specifies whether to include literals in clipboard content.
AcceptsCrLf
The AcceptsCrLf option specifies how to process CrLf characters when copying, cutting, or pasting a string.
ValueSign
The ValueSign option determines what types of values are accepted such as only positive or negative values.
AllowDeleteToNull
The AllowDeleteToNull option specifies whether to allow a null value.
ReadOnly
You can specify whether the user can enter values with the ReadOnly option.
UseNegativeColor
You can display negative colors with the UseNegativeColor option.
FocusPosition
You can use the FocusPosition option to control the initial cursor position when the cell gets focus.
AcceptsArrowKeys
You can specify how arrow keys are handled with the AcceptsArrowKeys option.
ExitOnLastChar
The ExitOnLastChar option specifies whether to move to the next cell when the last character is typed.
You can use the Fields tab to specify formatting and patterns when you are editing the cell. The fields apply to different areas of the cell such as integer and decimal areas. 
Fields Tab 
Edit Mode You can create display fields with the DisplayFields tab. Display fields are areas of the cell such as the decimal separator or decimal section of the number. You can set colors, fonts, patterns, and other properties for the display field. The value in the cell is displayed in the order that you list the display field options. For example, NumberIntegerPartDisplayFieldInfo is listed before NumberDecimalSeparatorDisplayFieldInfo in the following image. This means that the integer part of the number is displayed before the decimal separator. You can add, insert, or clone the display fields. You can also delete, clear, or move the fields up or down in the list. 
Display Fields Use the DropDown tab to specify options for the drop-down button for the cell and the drop-down calculator. The Spin section applies to side buttons if you add side buttons to the cell. 
DropDown Tab The following table lists the options for the DropDown tab:
Option
Description
ClosingAnimation
This option specifies how to handle animation when closing the drop-down window.
OpeningAnimation
This option specifies how to handle animation when opening the drop-down window.
Width
This option specifies the width of the drop-down window.
Height
This option specifies the height of the drop-down window.
Direction
This option specifies the drop-down direction.
AllowResize
This option specifies whether the user can change the size of the drop-down window with a size grip.
AutoDropDown
This option specifies whether the drop-down window is automatically shown when the control gets focus.
AllowDrop
This option specifies whether to allow a drop-down action.
ShowShadow
This option specifies whether to show a shadow on the drop-down dialog.
SpinMode
This option specifies whether to change the value, field, or a digit of the value.
IncrementValue
This option specifies how much to increment or decrement the value.
Increment
This option specifies how much to increment or decrement the field or digit.
AllowSpin
This option specifies whether the spin behavior is enabled.
Wrap
This option specifies whether the spin behavior can wrap when reaching a maximum or minimum limit.
SpinOnKeys
This option specifies whether the user can cause a spin action using a key (for example, changing the value using the up or down arrow key).
You can use the SideButton tab to add side buttons to the cell and specify options for the side buttons. You can specify SpinUp or SpinDown with the Behavior option. You can add, insert, or clone the side buttons. You can also delete, clear, or move the buttons up or down in the list. 
Side Button Tab You can use the DropDownCalculator tab to specify the appearance for the calculator and the calculator buttons. 
DropDownCalculator You can use the Background tab to display an image and set the image properties in the cell. 
Background Tab Use the Apply and OK buttons to apply the cell changes to the designer.
MESCIUS inc.