Understanding How Cell Type Affects Model Data

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