# Sheet Settings Imported

Learn how Spread handles sheet settings when importing data from an Excel-formatted file. Find out how properties are imported and handled by Spread.

## Content

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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.html) class unless otherwise noted.

| **Excel Setting** | **Related Spread Property** | **Remarks** |
| ------------- | ----------------------- | ------- |
| Active sheet | [ActiveSheet](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ActiveSheet.html) [ActiveSheetIndex](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ActiveSheetIndex.html) | Spread imports this setting from Excel. |
| Cell overflow | [AllowCellOverflow](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AllowCellOverflow.html) | Spread sets the AllowCellOverflow property to True. (Cells can always overflow in Excel.) |
| Clipboard shortcut key support | [AutoClipboard](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AutoClipboard.html) [ClipboardOptions](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ClipboardOptions.html) | 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AllowDragDrop.html) | 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](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-rowcol). |
| Grid lines |  | See the grid lines section in [Row and Column Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-rowcol). |
| Printing |  | Refer to the [Print Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-print). |
| Scroll bars | [HorizontalScrollBarPolicy](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.HorizontalScrollBarPolicy.html) [VerticalScrollBarPolicy](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.VerticalScrollBarPolicy.html) | 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.Sheets.html) SheetView.[SheetName](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.SheetName.html) | Spread imports this setting from Excel. |
| Zoom | [ZoomFactor](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ZoomFactor.html) | 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.

## See Also

[Workbook Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-workbk)
[Chart Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-chart)
[Row and Column Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-rowcol)
[Cell Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-cell)
[Border Styles Substituted](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-border)
[Formula Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-formulas)
[Print Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-print)