Row and Column Settings Imported
This table summarizes how the row and column settings are handled when Spread imports data from an Excel file. These properties are members of the SheetView class unless otherwise noted.
Excel Setting | Related Spread Property | Remarks |
|---|---|---|
Active cell | Sets active cell in Spread as it was when file was saved in Excel. | |
Sets active cell in Spread as it was when file was saved in Excel. | ||
Cell blocks | These are ranges of cells. See Selections, in this section on Row and Column Settings Imported. | |
Column headers and Row headers | ColumnHeader ColumnHeaderHorizontalGridLine ColumnHeaderVerticalGridLine ColumnHeaderVisible RowHeader RowHeaderHorizontalGridLine RowHeaderVerticalGridLine RowHeaderVisible | Excel shows or hides both column and row headers; therefore, if both are displayed in Excel, both are displayed in Spread. Also, refer to the ColumnHeader class and RowHeader class. |
Hidden columnsHidden rows | Columns and rows hidden in Excel are hidden in Spread. These are columns or rows that are not displayed. | |
Row height | Row.Height | Spread imports the Excel setting. |
Column width | Column.Width | Spread imports the Excel setting. |
Frozen columns Frozen rows | Spread imports these settings from Excel. These are rows or columns that are non-scrollable. | |
Grid lines | HorizontalGridLine VerticalGridLine ColumnHeaderHorizontalGridLine ColumnHeaderVerticalGridLine RowHeaderHorizontalGridLine RowHeaderVerticalGridLine | Excel shows or hides both horizontal and vertical grid lines; therefore, if both are displayed in Excel, both are displayed in Spread. |
Print information | Refer to Print Settings Imported. And refer to the PrintInfo class. | |
Protected cells | Spread imports the Excel setting. Note that the default value for the Protect property in Excel is False—the opposite of the Spread Protect property default setting. See locked cells in the table of Cell Settings Imported. | |
Row headers and Column headers | See Column Headers and Row Headers in this table of Column and Row Settings Imported. | |
Selections | IsBlockSelected SelectionBackColor SelectionForeColor SelectionCount | Spread imports these settings from Excel. |
Sheet name | Spread imports these settings from Excel. | |
Starting column and row | Spread imports these settings from Excel. | |
Zoom factor | Spread imports these settings from Excel. |