Spread for ASP.NET 10 Product Documentation
Sheet Settings Exported

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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback