Spread for ASP.NET 13 Product Documentation
Spread for ASP.NET 13 Product Documentation / Import and Export Reference / Excel-Formatted File Export / Sheet Settings Exported
In This Topic
    Sheet Settings Exported
    In This Topic

    The following table summarizes how the sheet settings are handled when Spread exports to an Excel-formatted file.

    Spread Property How the Setting is Exported
    BackColor The background color is set for Excel using the same precedence that Spread uses (cell, row, column, spreadsheet). The background color for alternating rows is not exported, unless the ExcelSaveFlag.SaveAlternatingRowStyles option is used. (Refer to Colors Exported.)
    Font The font settings are applied to the cell, the row, the column, and the spreadsheet for Excel, using the same precedence Spread uses.
    FontBold The font settings are applied to the cell, the row, the column, and the spreadsheet for Excel, using the same precedence Spread uses..
    FontItalic The font settings are applied to the cell, the row, the column, and the spreadsheet for Excel, using the same precedence Spread uses.
    FontName The font settings are applied to the cell, the row, the column, and the spreadsheet for Excel, using the same precedence Spread uses.
    FontSize The font settings are applied to the cell, the row, the column, and the spreadsheet for Excel, using the same precedence Spread uses.
    FontStrikethru The font settings are applied to the cell, the row, the column, and the spreadsheet for Excel, using the same precedence Spread uses.
    FontUnderline The font settings are applied to the cell, the row, the column, and the spreadsheet for Excel, using the same precedence Spread uses.
    ForeColor The text color is set for Excel using the same precedence that Spread uses (cell, row, column, spreadsheet). The text color for alternating rows is not exported, unless the ExcelSaveFlag.SaveAlternatingRowStyles option is used. (Refer to Colors Exported.).
    GridColor Refer to Colors Exported.
    GridLines If GridLines is set to none, none are shown in Excel. If GridLines is set to Both, both horizontal and vertical grid lines are shown. Other settings are not exported.
    Protect The Protect property setting for the spreadsheet is exported. The default value for the Protect property in Spread is True, the opposite of the Excel Protect property default setting. The Protect setting works with the Locked setting for cells to determine whether users can change content. Refer to the Locked cells setting in Cell Settings Exported for more information.
    Visible The sheet is displayed or hidden in Excel according to this setting.

    Quantity

    Only the number of sheets that Excel can handle is exported.

    Custom Functions and Custom Names

    A custom function is exported as any other function. In Excel, this is called a user-defined function.

    Excel supports both worksheet level names and workbook level names. Spread assigns a custom name to the sheet level if cross-sheet references are disabled. Spread assigns a custom name to the workbook level if cross-sheet references are enabled.

    Hierarchical Display

    Only the top sheet is exported in a hierarchical display.

    A hierarchy on a sheet can have expandable and collapsible rows. Spread supports a hierarchy where each sheet (parent and child) has its own cell formulas, column settings, etc. There is no way to fully export a hierarchy to an Excel-formatted file from Spread, because Excel does not support a hierarchy of sheets. One option would be to copy all the cell data and formatting to a single sheet and then export that sheet.

    Border

    The border around the Spread component is not exported.

    PrintInfo Class

    See Print Settings Exported for more information about exporting the print settings.

    Images

    Images created with the SpreadImage class are exported as floating images.