Spread Windows Forms 15.0
Spread Windows Forms 15.0 Product Documentation / Developer's Guide / Sheets / Showing or Hiding a Sheet
In This Topic
    Showing or Hiding a Sheet
    In This Topic

    If you have more than one sheet in the component, you can hide a sheet so that it is not displayed to the user. Even though it is not displayed, it is not removed from the component. There must be at least one sheet in the component. For information on adding a sheet, refer to Adding a Sheet.

    Hiding a sheet does not change the default sheet names provided for the other sheets. For example, a Spread 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.

    Using the Properties Window

    1. At design time, in the Properties window, select the Spread component.
    2. Select the Sheets property.
    3. Click the button to display the SheetView Collection Editor.
    4. In the Members list, select the sheet to hide.
    5. Select the Visible property in the property list, and then select false.
    6. Click OK to close the editor.

    Method to set

    Set the Sheets shortcut object Visible property for the sheet.


    This example code hides the second and fourth sheets in a Spread component that has eight sheets.

    Copy Code
    private void Form1_Load(object sender, System.EventArgs e)
      // Set the Spread to have eight sheets.
      fpSpread1.Sheets.Count = 8;
      // Hide the second and fourth sheets.
      fpSpread1.Sheets[1].Visible = false;
      fpSpread1.Sheets[3].Visible = false;
    Copy Code
    Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
      ' Set the Spread to have eight sheets.
      fpSpread1.Sheets.Count = 8
      ' Hide the second and fourth sheets.
      fpSpread1.Sheets(1).Visible = False
      fpSpread1.Sheets(3).Visible = False
    End Sub

    Using the Tab Strip Context Menu

    You can hide a sheet by using the tab strip's context menu and choosing 'Hide' option. The tab strip context menu can be enabled by setting the Editable option as true.

    Copy Code
    fpSpread1.TabStrip.Editable = true;

    Similarly, you can select 'Unhide' from tab strip context menu to unhide sheets. The 'Unhide' dialog listing all the hidden sheets is opened from which you can select the ones you want to unhide.

    Using the Spread Designer

    1. Select the sheet tab for the sheet for which you want to set properties.
    2. In the property list, select the Visible property.
    3. Select False.
    4. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.

    You can choose 'Hide' and 'Unhide' options from tab strip context menu in Spread Designer as well. However, these options can be disabled by checking the “Show hidden sheets” option in 'Preferences' dropdown list (unchecked by default). This will ensure that the hidden sheets are always shown.


    See Also