Sheet Settings Imported
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 | BackColor ForeColor | 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 | 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.