Showing or Hiding a Sheet

You can hide a sheet so that it is not displayed to the user while still keeping it in the component.

Hiding a sheet does not change the default sheet names provided to the other sheets. For example, a component with three sheets would by default name them Sheet1, Sheet2, and Sheet3. If you hide the second sheet, the names for the remaining sheets are Sheet1 and Sheet3.

Hiding a sheet does not remove it and does not affect formulas on that sheet or references to that sheet. For more information on removing the sheet completely, refer to Removing a Sheet. Use the Visible property of the FpSpread component to show or hide the sheet.

Using the Properties Window

At design time, in the Properties window, select the Sheets property for the FpSpread component.
Click the button to display the SheetView Collection Editor.
In the Members list, select the sheet to hide.
Select the Visible property in the property list and set to false.
Click OK to close the editor.

Using a Shortcut

Set the Visible property of the FpSpread component Sheets shortcut.

Example

This example code hides the second sheet from a component that has two or more sheets.

C#	Copy Code
// Hide the second sheet. FpSpread1.Sheets[1].Visible = false;

VB	Copy Code
' Hide the second sheet. FpSpread1.Sheets[1].Visible = False