Spread for ASP.NET 8.0 Product Documentation > Developer's Guide > Customizing the Appearance > Customizing the Appearance of the Sheet > 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.
Set the Visible property of the FpSpread component Sheets shortcut.
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 |