Spread Windows Forms 7.0 Product Documentation
Understanding How Cell Type Affects Model Data
Support Options
Spread Windows Forms 7.0 Product Documentation > Developer's Guide > Customizing Interaction with Cell Types > Understanding How Cell Types Work > Understanding How Cell Type Affects Model Data

Glossary Item Box

The cell type affects how the values are stored in the model.

The following table lists the editable cell types and the data type of the value in the cell that is written to the data model.

Editable Cell Type Data Type Written to Model

CurrencyCellType

Decimal

DateTimeCellType

Date-Time Object

GeneralCellType

Depends whether Date-Time, Boolean, or String

MaskCellType

String

NumberCellType

Double

PercentCellType

Double

RegularExpressionCellType

String

TextCellType

String

The following table lists the graphical cell types and the data type of the value in the cell that is written to the data model.

Graphical Cell Type Data Type Written to Model

BarCodeCellType

Value of barcode

ButtonCellType two-state

Integer

ButtonCellType one-state

Null

CheckBoxCellType three-state

Integer (0 = false, 1= true, 2 = indeterminate)

CheckBoxCellType two-state

Boolean

ColorPickerCellType

ComboBoxCellType and MultiColumnComboBoxCellType

Depends on value of EditorValue property. String, if EditorValue = String or item data, Integer, if EditorValue = index

HyperLinkCellType

Array of Boolean values (whether each link is clicked or not)

ImageCellType

Null

ListBoxCellType

Array

MultiOptionCellType

Depends on value of EditorValue property. String, if EditorValue = String or item data, Integer, if EditorValue = index

ProgressCellType

Double

RichTextCellType

String

SliderCellType

Integer

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