Spread for ASP.NET 12 Product Documentation
Sheet Settings Imported
Spread for ASP.NET 12 Product Documentation > Import and Export Reference > Excel-Formatted File Import > Sheet Settings Imported

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.

Images

Floating images are imported.