When you work with cells in the data area of the spreadsheet, you can manipulate the objects using the short cuts in code (Cell and Cells classes) or you can directly manipulate the model. Most developers who are not changing anything drastically find it easy to manipulate the shortcut objects.
These tasks relate to setting the appearance of individual cells in the data area of the spreadsheet:
- Coloring a Cell
- Setting a Background Image to a Cell
- Aligning Cell Contents
- Resizing a Cell to Fit the Data
- Customizing Cell Borders
- Creating a Span of Cells
- Allowing Cells to Merge Automatically
- Allowing Cell Data to Overflow
- Creating and Applying a Style for Cells
- Using Sparklines
Note: We use the word "appearance" in the general sense of the look and feel of the cell, not simply the settings in the Appearance class, which contains only a few settings and is used for the appearance of several parts of the interface. Most of the appearance settings for a cell are in the StyleInfo class.
Remember that settings applied to a particular cell override the settings that are set at the column or row level. Refer to Object Parentage.
Other cell-level appearance settings are set by the cell type. For more information on settings related to cell types, refer to Customizing Interaction with Cell Types. You can edit properties of the Cells classes in the Properties window (in Spread Designer or in Visual Studio .NET). For more information on the Cells, Columns, and Rows Editor that is available from the Properties window, refer to the explanation of this editor in the Spread Designer Guide.
For information on header cells, refer to Customizing the Appearance of Headers.
For tasks that relate to setting the user interaction at the cell level, refer to Customizing Interaction in Cells.
For information on customizing the appearance of cells using the Spread Designer, refer to the Spread Designer Guide.
For more information on the Cell and Cells objects, refer to the Assembly Reference.
For more information on models, refer to Understanding the Underlying Models.
Return to the overall list of tasks in Customizing Row, Column, and Cell Appearance.