Row and Column Settings Exported

In This Topic

Spread supports rows and columns as separate objects from sheets (discussed in Component and Sheet Settings Exported) and cells (discussed in Cell Settings Exported). The settings summarized in this topic are at the row (Row object) or column (Column object) level.

Specific Row or Column Properties

This table summarizes how the row and column settings are handled when Spread exports to an Excel‑formatted file. In most cases Excel uses the Spread setting. (In RowHeadersShow, Excel uses Show headers.) These properties are in the SheetView class unless otherwise noted.

Spread Property	Excel Setting and Remarks
ActiveCell	Excel uses this setting that specifies the active cell
ActiveColumn ActiveRow	Excel uses this setting that specifies the active column and row.
ActiveColumnIndex ActiveRowIndex	Spread does not export these settings. Excel does not use them.
ActiveSkin	Excel does not support Spread skins.
AlternatingRows	Set the SaveAlternatingRowStyles flag (ExcelSaveFlags).
AutoCalculation	The setting for the first sheet is exported as a workbook setting with Excel 2003 or later.
AutoGenerateColumns	This setting is not exported. Excel does not support this.
AutoSortColumn ColumnAutoSorted	These settings are not exported. Excel does not support these.
ColumnCount	This setting is not exported.
ColumnHeader ColumnHeaderAutoSortIndex ColumnHeaderHorizontalGridLine ColumnHeaderRowCount ColumnHeaderVerticalGridLine	These settings are not exported. Excel does not support these.
ColumnHeaderVisible	Excel uses this setting that specifies whether the column header is visible.
ColumnHeaderAutoText ColumnHeaderAutoTextIndex	Excel ignores the Spread setting. Excel by default displays letters for column headers, unless the reference style is set to R1C1, in which case the column headers display numbers.
Columns	Excel uses the Spread settings for width, etc.
DataAutoCellTypes DataAutoHeadings DataAutoSizeColumns DataMember DataSource	These data-binding settings are not exported. Excel does not support these. Excel does not handle databinding as Spread does.
FrozenColumnCount FrozenRowCount	Frozen columns and rows in Spread are exported to Excel and are similarly frozen in Excel,.
FrozenTrailingColumnCount FrozenTrailingRowCount	Frozen columns and rows on the trailing side of the Spread are not exported to Excel because Excel does not have an equivalent feature.
GrayAreaBackColor	This setting is not exported. Excel does not support this.
HorizontalGridLine VerticalGridLine	Excel uses these settings.
IsBlockSelected	These settings are not exported. Excel does not support these.
LockBackColor LockForeColor	These settings are not exported. Excel does not support these.
Iteration MaximumChange MaximumIterations	Excel uses these settings for calculation of formulas.
DefaultStyle DefaultStyleName NamedStyles ReferenceStyle	These settings are not exported. Excel does not support these.
OperationMode	Excel ignores the Spread setting.
ChildRelationCount Parent ParentRelationName ParentRowIndex	Hierarchies in Spread are not exported to outlining in Excel.
PrintInfo	Some print information is exported. See Print Settings Exported.
Protect	Spreadsheets exported from Spread export the Lock property setting for each cell and export the Protect property setting for the spreadsheet. Note that the default value for the Protect property in Spread is True—the opposite of the Excel Protect default setting—and the default value of the Lock property is False for all cells in Spread. For information on the Locked setting (at the cell level) refer to Cell Settings Exported.
RestrictColumns RestrictRows	These settings are not exported.Excel does not support these.
RowCount	Excel ignores the Spread setting.
RowHeader RowHeaderColumnCount RowHeaderHorizontalGridLine RowHeaderVerticalGridLine RowHeaderVisible	Excel ignores the Spread setting. Excel does not support multiple row header columns.
RowHeaderAutoText RowHeaderAutoTextIndex	Excel ignores the Spread setting. Excel by default displays numbers and this cannot be changed. If you have provided custom text for your row headers in Spread, it is not exported to Excel. Excel does not support custom row headers.
Rows	Excel uses the Spread settings (such as height for example).
SelectionBackColor SelectionForeColor SelectionStyle SelectionCount	Excel ignores the Spread setting.
SheetCornerHorizontalGridLine SheetCornerStyle SheetCornerStyleName SheetCornerVerticalGridLine	These settings are not exported by Spread. Excel does not support these.
SheetName	This is exported by Spread as an Excel sheet name.
StartingColumnNumber StartingRowNumber	Excel ignores the Spread setting.
Tag	Excel ignores the Spread setting.
Visible	Cells (columns and rows) set as not visible are set as hidden rows and hidden columns in Excel.
Width	Excel uses the Spread setting to set the column width for each individual column.
Height	Excel uses the Spread setting to set the row height for each individual row.

Row or Column Quantity

Since Spread supports up to two billion rows and two billion columns on any sheet, and Excel supports less than this, only the number of rows and columns that Excel can handle is exported.