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
- Working with Editable Cell Types
- Working with Graphical
- 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
For other ways to set the appearance of the cell, refer to Customizing the Appearance of a Cell. For other ways to set the user interaction at the cell level, refer to Customizing Interaction in Cells.
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.
Return to the overall list of tasks in the Developer's Guide.