You can set the appearance of individual cells in the data area of the spreadsheet. These tasks relate to setting the appearance of individual cells:
- Working with the Active Cell
- Customizing the Colors of a Cell
- Aligning Cell Contents
- Customizing Cell Borders
- Customizing the Margins and Spacing of the Cell
- Creating and Applying a Custom Style for Cells
- Assigning a Cascading Style Sheet to a Cell
- Creating a Range of Cells
- Spanning Cells
- Allowing Cells to Merge Automatically
- Using Sparklines
When you work with cells, 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.
 |
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 with Cell Types.
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 with Cells.
For more information, refer to the Cell class.