Spread Windows Forms 14.0
Spread Windows Forms 14.0 Product Documentation / Import and Export Reference / Excel-Formatted Files Export / Row and Column Settings Exported
In This Topic
    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.

    See Also