Cell types define the type of information that appears in a cell, how that information is displayed, and how the user can interact with it. There are two different groups of cell types that can be set for cells in a sheet: ones that are simply related to formatting of text in a cell and ones that display a control or graphic. Spread includes built-in cell types and allows you define custom cell types. Cell types can be assigned to individual cells or entire rows or columns.

These tasks of working with cell types are organized into these broad categories:

• Understanding How Cell Types Work
  • Understanding Cell Type Basics
  • Understanding How Cell Types Display Data
  • Understanding How Cell Type Affects Model Data
• Working with Editable Cell Types
  • Setting a Currency Cell
  • Setting a Date-Time Cell
  • Setting a GcDateTime Cell
  • Setting a GcTextBox Cell
  • Setting a General Cell
  • Setting a Mask Cell
  • Setting a Number Cell
  • Setting a Percent Cell
  • Setting a Regular Expression Cell
  • Setting a Text Cell
• Working with Graphical Cell Types
  • Setting a Barcode Cell
  • Setting a Button Cell
  • Setting a Check Box Cell
  • Setting a Color Picker Cell
  • Setting a Combo Box Cell
  • Setting a Hyperlink Cell
  • Setting an Image Cell
  • Setting a List Box Cell
  • Setting a Multiple-Column Combo Box Cell
  • Setting a Multiple Option Cell
  • Setting a Progress Indicator Cell
  • Setting a Rich Text Cell
  • Setting a Slider Cell
• Understanding Additional Features of Cell Types
  • Displaying Spin Buttons
  • Allowing a Combo Box Cell to Handle a Double Click
  • Limiting Values for a Numeric Cell
  • Customizing the Pop-Up Date-Time Control
  • Customizing the Pop-Up Calculator Control
  • Customizing Automatic Completion (Type Ahead)
  • Working with a SubEditor
  • Creating a Custom Cell Type

Note that some graphical elements in certain cell types are affected by XP themes (visual styles). Setting the VisualStyles property of the Spread component to "off" can allow visual customizations of those graphical cell types to work as expected. For more information, refer to Using XP Themes with the Component.

For detailed information on classes behind the various built-in cell types, refer to the FarPoint.Win.Spread.CellType namespace.

For information on setting cell types using the Spread Designer, refer to the Spread Designer Guide.

See Also