Spread ASP.NET 17
Spread for ASP.NET 17 Product Documentation / Developer's Guide / Customizing the Appearance / Customizing the Appearance of the Sheet / Working with Multiple Sheets
In This Topic
    Working with Multiple Sheets
    In This Topic

    The component allows multiple sheets. Set the Count property to specify the number of sheets. For information on adding sheets with the designer, see the SheetView Collection Editor.

    Multiple sheets

    For information about the display of the sheet names in the sheet name buttons, refer to Displaying the Sheet Names.

    Formulas in a cell on one sheet can refer to a value or a cell on another sheet. For more information about formulas, refer to Managing Formulas.

    You can name the sheets. Use the SheetName property in the SheetView class to name the sheet programmatically.

    For information about adding a sheet, refer to Adding a Sheet.

    Using Code

    This example sets the number of sheets.

    C#
    Copy Code
    FpSpread1.Sheets.Count = 2;
    VB
    Copy Code
    FpSpread1.Sheets.Count = 2
    See Also