Customizing the Individual Sheet Appearance

You can have multiple sheets within a workbook. Each sheet is a separate spreadsheet and can have its own appearance and settings for user interaction. Each sheet has a unique name and sheet name tab for easy navigation between sheets.

These tasks relate to setting the appearance of the individual sheets inside the Spread component:

• Setting the Background Colors for a Sheet
• Coloring a Cell
• Setting a Background Image for a Sheet
• Setting a Background Image to a Cell

Other tasks that relate to the sheet appearance, but are part of the appearance of the Spread component include:

• Customizing the Outline of the Component
• Customizing the Sheet Name Tabs
• Working with Hierarchical Data Display
• Creating and Applying a Style for Cells

When you work with sheets, you can manipulate the objects using the short cuts in code, (SheetView and SheetViewCollection classes) or you can directly work with the model. Most developers who are not changing anything drastically find it easy to work with the short cut objects. For more information on models, refer to Understanding the Underlying Models.

Settings applied to a particular row or column or cell can override the settings that are set at the sheet level. Refer to Object Parentage.

For more details on the objects involved, refer to the SheetView class and SheetViewCollection class.

See Also

Customizing the Sheet Appearance

Customizing the Dimensions of the Component

Customizing the Appearance of a Cell

Customizing the Overall Component Appearance

Creating and Applying a Style for Cells

Using Conditional Formatting of Cells

Customizing the Display of the Pointer

Customizing the User Interface Images

Using XP Themes with the Component

Customizing the Renderers

Handling Right-to-Left Layouts

Customizing Painting of Parts of the Component

Text Rendering with GDI

Applying Theme to Customize the Appearance