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 |
Spread imports this setting from Excel. |
|
|
Cell overflow |
Spread sets the AllowCellOverflow property to True. (Cells can always overflow in Excel.) |
|
|
Clipboard shortcut key support |
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 |
BackColorForeColor |
Spread imports this setting from Excel. |
|
Drag and drop |
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 |
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 |
SheetView.SheetName |
Spread imports this setting from Excel. |
|
Zoom |
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.
Return to the overview of Excel-Formatted Files Import.