# Understanding How Cell Type Affects Model Data

Learn how cell types affect data storage in models with this comprehensive guide.

## Content

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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.CurrencyCellType.html) | Decimal |
| [DateTimeCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.DateTimeCellType.html) | Date-Time Object |
| [GcCharMaskCellType](/spreadnet/api/latest/online-win/GrapeCity.Win.PluginInputMan/GrapeCity.Win.Spread.InputMan.CellType.GcCharMaskCellType.html) | String |
| [GcDateTimeCellType](/spreadnet/api/latest/online-win/GrapeCity.Win.PluginInputMan/GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType.html) | Date-Time Object |
| [GcMaskCellType](/spreadnet/api/latest/online-win/GrapeCity.Win.PluginInputMan/GrapeCity.Win.Spread.InputMan.CellType.GcMaskCellType.html) | String |
| [GcNumberCellType](/spreadnet/api/latest/online-win/GrapeCity.Win.PluginInputMan/GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType.html) | Double |
| [GcTextBoxCellType](/spreadnet/api/latest/online-win/GrapeCity.Win.PluginInputMan/GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType.html) | String |
| [GcTimeSpanCellType](/spreadnet/api/latest/online-win/GrapeCity.Win.PluginInputMan/GrapeCity.Win.Spread.InputMan.CellType.GcTimeSpanCellType.html) | TimeSpan Object |
| [GeneralCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.GeneralCellType.html) | Depends whether Date-Time, Boolean, or String |
| [MaskCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.MaskCellType.html) | String |
| [NumberCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.NumberCellType.html) | Double |
| [PercentCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.PercentCellType.html) | Double |
| [RegularExpressionCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.RegularExpressionCellType.html) | String |
| [TextCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.TextCellType.html) | 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.BarCodeCellType.html) | Value of barcode |
| [ButtonCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.ButtonCellType.html) two-state | Integer |
| [ButtonCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.ButtonCellType.html) one-state | Null |
| [CheckBoxCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.CheckBoxCellType.html) three-state | Integer (0 = false, 1= true, 2 = indeterminate) |
| [CheckBoxCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.CheckBoxCellType.html) two-state | Boolean |
| [ColorPickerCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.BarCodeCellType.html) | Null |
| [ComboBoxCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.ComboBoxCellType.html) and [MultiColumnComboBoxCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType.html) | Depends on value of **EditorValue** property. String, if EditorValue = String or item data. Integer, if EditorValue = index |
| [GcComboBoxCellType](/spreadnet/api/latest/online-win/GrapeCity.Win.PluginInputMan/GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType.html) | Depends on value of **EditorValue** property. String, if EditorValue = String or item data. Integer, if EditorValue = index |
| [HyperLinkCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.HyperLinkCellType.html) | Array of Boolean values (whether each link is clicked or unclicked) |
| [ImageCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.ImageCellType.html) | System.Drawing.Color or Null |
| [ListBoxCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.ListBoxCellType.html) | Array |
| [MultiOptionCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.MultiOptionCellType.html) | Depends on value of **EditorValue** property. String, if EditorValue = String or item data, Integer, if EditorValue = index |
| [ProgressCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.ProgressCellType.html) | Double |
| [RichTextCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.RichTextCellType.html) | String |
| [SliderCellType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.SliderCellType.html) | Integer |

## See Also

[Cell Types](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes)
[Understanding Cell Type Basics](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes/spwin-celltypeoview)
[Understanding How Cell Types Work](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes/spwin-celltypedata)
[Understanding How Cell Types Display and Format Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes/spwin-datacelltextvalue)
[Working with Editable Cell Types](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes/spwin-seteditcelltypes)
[Working with Graphical Cell Types](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes/spwin-setgraphcelltypes)
[Understanding Additional Features of Cell Types](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes/spwin-celltypecustomize)