-
Spread Windows Forms 18 Product Documentation
- Getting Started
-
Developer's Guide
- Understanding the Product
- Working with the Component
- Spreadsheet Objects
- Ribbon Control
-
Sheets
- Working with the Active Sheet
- Working with Multiple Sheets
- Customizing the Sheet Name Tabs
- Navigating Sheet Tabs
- Adding a Sheet
- Adding ChartSheet
- Removing a Sheet
- Showing or Hiding a Sheet
- Moving a Sheet
- Selecting Multiple Sheets
- Copying and Inserting a Sheet
- Protecting a Worksheet
- Form Controls
- Adding a Title and Subtitle to a Sheet
- Placing Child Controls on a Sheet
- Displaying a Footer for Columns or Groups
- Adding a Tag to a Sheet
- Working with 1-Based Indexing
- Customizing Clipboard Operation Options
- Rows and Columns
- Headers
- Cells
- Cell Types
- Data Binding
- Customizing the Sheet Appearance
- Customizing Interaction in Cells
- Tables
- Understanding the Underlying Models
- Customizing Row or Column Interaction
- Formulas in Cells
- Sparklines
- Keyboard Interaction
- Events from User Actions
- File Operations
- Storing Excel Summary and View
- Printing
- Chart Control
- Customizing Drawing
- Touch Support with the Component
- Spread Designer Guide
- Assembly Reference
- Import and Export Reference
- Version Comparison Reference
Working with the Active Sheet
The active sheet is the sheet that currently receives any user interaction and displays on top of other sheets. You can specify the active sheet programmatically by using the ActiveSheet property of the FpSpread object. You can also specify the index of the active sheet by using the ActiveSheetIndex property.
Usually, the active sheet is displayed on top of other sheets.
Method to use
You can use ActiveSheet as a shortcut object for the active sheet when specifying properties of the sheet.
Example
The following example set properties of the active sheet and assign the active sheet to sheet number 2.
// Create three sheets in the component.
fpSpread1.Sheets.Count = 3;
// Set third sheet (in zero-based index) be set to active sheet.
fpSpread1.ActiveSheetIndex = 2;
// Set some properties of the active sheet.
fpSpread1.ActiveSheet.ColumnCount = 8;
fpSpread1.InterfaceRenderer = NULL;
fpSpread1.ActiveSheet.GrayAreaBackColor = Color.Purple;' Create three sheets in the component.
fpSpread1.Sheets.Count = 3
' Set third sheet (in zero-based index) be set to active sheet.
fpSpread1.ActiveSheetIndex = 2
' Set some properties of the active sheet.
fpSpread1.ActiveSheet.ColumnCount = 8
fpSpread1.InterfaceRenderer = Nothing
fpSpread1.ActiveSheet.GrayAreaBackColor = Color.PurpleSee Also
Adding a Title and Subtitle to a Sheet
Placing Child Controls on a Sheet