Component and Sheet Settings Exported
Spread has one or more spreadsheets in a way similar to Excel. The settings summarized in this topic are at the component (FpSpread) or sheet (Sheet) level.
Specific Spreadsheet Properties
Sheet Quantity
Custom Functions and Custom Names
Hierarchical Display
Shapes (Built-In and Custom)
Viewports
For additional settings related to printing of the sheet, refer to Print Settings Exported.
Specific Spreadsheet Properties
This table summarizes how the component-level and sheet-level settings are handled when Spread exports to an Excel‑formatted file. These properties are in the FpSpread class unless otherwise noted.
Spread Property | Excel Setting and Remarks |
|---|---|
Excel uses this setting. | |
The setting from Spread is ignored. Excel always allows cells to overflow. | |
The setting from Spread is ignored. Excel reads this setting from the system’s registry. | |
The setting from Spread is ignored. | |
The setting from Spread is ignored. Excel always allows edit overflow. | |
The setting from Spread is ignored. Excel always allows users to enter formulas. | |
Excel reads the value from the system’s registry. Excel excludes headings from Clipboard operations. | |
Excel ignores the Spread setting. This is specific to Spread. | |
Excel ignores the Spread setting. | |
Excel ignores the Spread setting. | |
Excel excludes headings from Clipboard operations. | |
Excel ignores the Spread setting. | |
Excel ignores the Spread setting. | |
Custom Function | A custom function is exported by Spread as any other function. In Excel, this is called a user-defined function. |
Custom Name | Excel assigns names to the entire workbook; Spread assigns a custom name to a sheet only. |
Excel ignores the Spread setting. This is for data binding, which Spread supports but Excel does not. | |
Excel ignores the Spread setting. This is for the editing control, which is specific to Spread. | |
Excel ignores the Spread settings. | |
See comments for ScrollBar properties. | |
Excel ignores the Spread setting. This is specific to Spread. | |
Excel ignores the Spread setting. This is specific to Spread. | |
Excel ignores the Spread setting. This is specific to Spread. | |
Excel ignores the Spread setting. This is specific to Spread. | |
Excel ignores the Spread setting. This is specific to Spread. | |
ScrollBarMaxAlign ScrollBarShowMax ScrollBarTrackPolicy ScrollTipPolicy | Excel ignores the Spread setting. This is specific to Spread. |
Excel ignores the Spread setting. This is specific to Spread. | |
Excel ignores the Spread setting. This is specific to Spread. | |
Excel ignores the Spread setting. This is specific to Spread. | |
Excel ignores the Spread setting. This is specific to Spread. | |
See comments for ScrollBar properties. | |
Excel uses this setting from Spread. |
Sheet 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.
Shapes (Built-In and Custom)
Built-in shapes and camera shapes in Spread can be exported to Excel. For more information on shapes, refer to Understanding the Built-in Shapes.
Viewports
Excel only handles one split bar in each direction (two panes by two panes). Spread can handle multiple split bars in each direction. If the spreadsheet has two or fewer viewports in either direction, it exports those as panes.