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.
