This table summarizes how the Sheet settings are handled when Spread.Sheets exports to an Excel-formatted file. These functions are in the GC.Spread.Sheets.Worksheet class unless otherwise noted.

Sheet Setting	Excel Setting and Remarks
name	Excel uses this setting.
defaults : rowHeight, columnWidth, columnHeaderRowHeight, rowHeaderColumnWidth	Excel only use the default.colWidth setting, but loads other settings to the column or row header.
columns	Excel uses this setting.
rows	Excel uses this setting.
autoGenerateColumns	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
dataSource	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
frozenRowCount or frozenColumnCount	Excel uses this setting.
frozenTrailingRowCount or frozenTrailingColumnCount	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
rowCount	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
columnCount	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
data	Excel loads the data from Spread.Sheets.
sparkline	Excel uses this setting.
spans	Excel uses this setting.
selections	Excel uses this setting.
selectionBackColor	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
selectionBorderColor	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
activeRowIndex	Excel uses this setting.
activeColumnIndex	Excel uses this setting.
gridline	Excel uses this setting, but if the vertical or horizontal grid line is hidden, then both are exported as hidden in Excel.
allowCellOverflow	Excel ignores the Sheet setting. allowCellOverflow is always true in Excel.
zoomFactor	Excel uses this setting.
theme	Excel uses the first sheet theme as the current theme and ignores other sheet theme settings.
showRowOutline or showColumnOutline	Excel ignores the Sheet setting. Excel uses the range group that is shown.
rowOutlines or columnOutlines	Excel uses this setting.
rowFilter	Excel uses this setting.
conditional formats	Excel uses this setting.
sheetTabColor	Excel uses this setting.
frozenlineColor	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
rowHeaderAutoText(Index) or colHeaderAutoText(Index)	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
rowHeaderVisible or colHeaderVisible	Excel uses this setting.
row header column count	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
column header row count	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
clipboardOptions	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
isProtected	Excel uses this setting.
borderColor	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
borderWidth	Excel ignores the Sheet setting. This is specific to Spread.Sheets.
table	Excel uses this setting.
named styles	Excel uses this setting.