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 entire sheet inside the Spread component:
- Setting the Background Colors for a Sheet
- Setting a Background Image for a Sheet
- Displaying Grid Lines on a Sheet
- Adding a Title and Subtitle to a Sheet
- Displaying a Footer for Columns or Groups
- Applying a Skin to a Sheet
- Creating a Custom Skin for a Sheet
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 of the Component
- 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 manipulate the model. Most developers who are not changing anything drastically find it easy to manipulate 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 sheet level. Refer to Object Parentage.
For tasks that relate to setting the user interaction at the sheet level, refer to Customizing Interaction with a Sheet.
For more details on the objects involved, refer to the SheetView class and SheetViewCollection class.