Spread Windows Forms 10.0 Product Documentation
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.

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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback