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 |
|---|---|
Excel uses this setting that specifies the active cell | |
Excel uses this setting that specifies the active column and row. | |
Spread does not export these settings. Excel does not use them. | |
Excel does not support Spread skins. | |
Set the SaveAlternatingRowStyles flag (ExcelSaveFlags). | |
The setting for the first sheet is exported as a workbook setting with Excel 2003 or later. | |
This setting is not exported. Excel does not support this. | |
These settings are not exported. Excel does not support these. | |
This setting is not exported. | |
ColumnHeader ColumnHeaderAutoSortIndex ColumnHeaderHorizontalGridLine ColumnHeaderRowCount ColumnHeaderVerticalGridLine | These settings are not exported. Excel does not support these. |
Excel uses this setting that specifies whether the column header is visible. | |
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. | |
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. |
Frozen columns and rows in Spread are exported to Excel and are similarly frozen in Excel,. | |
Frozen columns and rows on the trailing side of the Spread are not exported to Excel because Excel does not have an equivalent feature. | |
This setting is not exported. Excel does not support this. | |
Excel uses these settings. | |
These settings are not exported. Excel does not support these. | |
These settings are not exported. Excel does not support these. | |
Excel uses these settings for calculation of formulas. | |
These settings are not exported. Excel does not support these. | |
Excel ignores the Spread setting. | |
Hierarchies in Spread are not exported to outlining in Excel. | |
Some print information is exported. See Print Settings Exported. | |
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. | |
These settings are not exported.Excel does not support these. | |
Excel ignores the Spread setting. | |
RowHeader RowHeaderColumnCount RowHeaderHorizontalGridLine RowHeaderVerticalGridLine RowHeaderVisible | Excel ignores the Spread setting. Excel does not support multiple row header columns. |
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. | |
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. |
This is exported by Spread as an Excel sheet name. | |
Excel ignores the Spread setting. | |
Excel ignores the Spread setting. | |
Cells (columns and rows) set as not visible are set as hidden rows and hidden columns in Excel. | |
Excel uses the Spread setting to set the column width for each individual column. | |
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.