Row and Column Settings Imported

In This Topic

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	ActiveCell	Sets active cell in Spread as it was when file was saved in Excel.
	ActiveColumn ActiveColumnIndex ActiveRow ActiveRowIndex	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	Visible	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	FrozenColumnCount FrozenRowCount	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	PrintInfo	Refer to Print Settings Imported. And refer to the PrintInfo class.
Protected cells	Protect	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	SheetName	Spread imports these settings from Excel.
Starting column and row	StartingColumnNumber StartingRowNumber	Spread imports these settings from Excel.
Zoom factor	ZoomFactor	Spread imports these settings from Excel.