Sheet Settings Imported

In This Topic

This table summarizes how the sheet settings are handled when Spread imports data from an Excel-formatted file. These properties are members of the FpSpread class unless otherwise noted.

Excel Setting	Related Spread Property	Remarks
Active sheet	ActiveSheet ActiveSheetIndex	Spread imports this setting from Excel.
Cell overflow	AllowCellOverflow	Spread sets the AllowCellOverflow property to True. (Cells can always overflow in Excel.)
Clipboard shortcut key support	AutoClipboard ClipboardOptions	Spread reads the value of this setting, and sets the AutoClipboard property. Excel always excludes headings from Clipboard operations. Excel stores this setting in the system registry.
Color	BackColor ForeColor	Spread imports this setting from Excel.
Drag and drop	AllowDragDrop	Excel stores this setting in the system registry. Spread reads the value of this setting, and sets the AllowDragDrop property.
Frozen panes		See the frozen rows and columns in Row and Column Settings Imported.
Grid lines		See the grid lines section in Row and Column Settings Imported.
Printing		Refer to the Print Settings Imported.
Scroll bars	HorizontalScrollBarPolicy VerticalScrollBarPolicy	Spread imports this setting from Excel.
Shapes and Camera Shapes	Shapes and Camera Shapes	Shapes are imported as shapes (BIFF8 only).
Split bar and Panes	Several properties related to viewports.	Spread imports panes with split bars. In Spread, panes are referred to as viewports.
Worksheets Worksheet names	Sheets SheetView.SheetName	Spread imports this setting from Excel.
Zoom	ZoomFactor	Spread imports this setting from Excel.

Custom Names

Spread enables cross-sheet references when importing Excel-formatted files. This means that Excel workbook level custom names are imported as Spread workbook level custom names.