Spread Windows Forms 11.0 Product Documentation
Row and Column Settings Exported
Spread Windows Forms 11.0 Product Documentation > Import and Export Reference > Excel-Formatted Files Export > Row and Column Settings Exported

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.