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
ActiveSheet	Excel uses this setting.
AllowCellOverflow	The setting from Spread is ignored. Excel always allows cells to overflow.
AllowDragDrop	The setting from Spread is ignored. Excel reads this setting from the system’s registry.
AllowDragFill	The setting from Spread is ignored.
AllowEditOverflow	The setting from Spread is ignored. Excel always allows edit overflow.
AllowUserFormulas	The setting from Spread is ignored. Excel always allows users to enter formulas.
AutoClipboard	Excel reads the value from the system’s registry. Excel excludes headings from Clipboard operations.
BorderStyle	Excel ignores the Spread setting. This is specific to Spread.
ButtonDrawMode	Excel ignores the Spread setting.
CellNoteIndicatorVisible	Excel ignores the Spread setting.
ClipboardOptions	Excel excludes headings from Clipboard operations.
ColumnSplitBoxAlignment ColumnSplitBoxAlignment	Excel ignores the Spread setting.
Cursor	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.
DataMember DataSource	Excel ignores the Spread setting. This is for data binding, which Spread supports but Excel does not.
EditingControl EditMode EditModePermanent EditModeReplace	Excel ignores the Spread setting. This is for the editing control, which is specific to Spread.
GridLines GridLineColor	Excel ignores the Spread settings.
HorizontalScrollBarPolicy	See comments for ScrollBar properties.
LeftTab	Excel ignores the Spread setting. This is specific to Spread.
MoveActiveOnFocus	Excel ignores the Spread setting. This is specific to Spread.
NamedStyle	Excel ignores the Spread setting. This is specific to Spread.
RetainSelectionBlock	Excel ignores the Spread setting. This is specific to Spread.
RowSplitBoxAlignment RowSplitBoxPolicy	Excel ignores the Spread setting. This is specific to Spread.
ScrollBarMaxAlign ScrollBarShowMax ScrollBarTrackPolicy ScrollTipPolicy	Excel ignores the Spread setting. This is specific to Spread.
SelectionBlockOptions SelectionRenderer	Excel ignores the Spread setting. This is specific to Spread.
TabStrip TabStripPolicy TabStripRatio	Excel ignores the Spread setting. This is specific to Spread.
Tag	Excel ignores the Spread setting. This is specific to Spread.
TextTipAppearance	Excel ignores the Spread setting. This is specific to Spread.
VerticalScrollBarPolicy	See comments for ScrollBar properties.
ZoomFactor	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.