Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Import and Export Reference / Excel-Formatted Files Export / Component and Sheet Settings Exported
In This Topic
    Component and Sheet Settings Exported
    In This Topic

    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.

    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.