The following table summarizes how the sheet settings are handled when Spread imports data from an Excel-formatted file.
| Setting | How the Setting is Imported |
|---|---|
| Scroll bars | ScrollBars property is set to same setting as in Excel. |
| Column and row headers | Excel shows or hides both column and row headers; therefore, if both are displayed in Excel, both are displayed in Spread (ColumnHeadersVisible and RowHeadersVisible properties are both set to True). |
| Grid lines | Excel shows or hides both horizontal and vertical grid lines; therefore, if both are displayed in Excel, both are displayed in Spread (GridLines.Both); if both are hidden in Excel, both are hidden in Spread (GridLines.None). |
| Protect | Spreadsheets imported from Excel import the Protect property setting. Note that the default value for the Protect property in Excel is False, the opposite of the Spread Protect property default setting. The Protect setting works with the Locked setting for cells to determine whether users can change content. Refer to the Locked cells setting in Cell Settings Imported for more information. |
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 Excel-Formatted File Import overview.