Sheet Settings Exported

This table summarizes how sheet settings are handled when SpreadJS exports a worksheet to an Excel-formatted file. Unless otherwise noted, these settings belong to the GC.Spread.Sheets.Worksheet class.

Settings Supported by Excel

Sheet Setting	Excel Setting and Remarks
activeColumnIndex	Excel uses this setting.
activeRowIndex	Excel uses this setting.
columns	Excel uses this setting.
conditional formats	Excel uses this setting.
data	Excel loads the data from SpreadJS.
frozenRowCount or frozenColumnCount	Excel uses this setting.
isProtected	Excel uses this setting.
name	Excel uses this setting.
named styles	Excel uses this setting.
rowFilter	Excel uses this setting.
rowHeaderVisible or colHeaderVisible	Excel uses this setting.
rowOutlines or columnOutlines	Excel uses this setting.
rows	Excel uses this setting.
selections	Excel uses this setting.
sheetTabColor	Excel uses this setting.
showZeros	Excel uses this setting.
sparkline	Excel uses this setting.
spans	Excel uses this setting.
table	Excel uses this setting.
zoomFactor	Excel uses this setting.

Settings Supported with Limitations

Sheet Setting	Excel Setting and Remarks
backgroundImage	Excel uses the worksheet background image and preserves the layout setting. The `paintOrder` setting is not preserved because Excel does not support drawing worksheet background images above content.
defaults: rowHeight, columnWidth, columnHeaderRowHeight, rowHeaderColumnWidth	Excel uses only the `defaults.columnWidth` setting. The other settings are loaded into the corresponding column or row headers.
gridline	Excel uses this setting. However, if either vertical or horizontal gridlines are hidden, both are exported as hidden in Excel.
theme	Excel uses the first sheet theme as the current theme and ignores the theme settings of other sheets.

Settings Ignored by Excel

Sheet Setting	Excel Setting and Remarks
allowCellOverflow	Excel ignores this Sheet setting. `allowCellOverflow` is always `true` in Excel.
autoGenerateColumns	Excel ignores this Sheet setting. It is specific to SpreadJS.
borderColor	Excel ignores this Sheet setting. It is specific to SpreadJS.
borderWidth	Excel ignores this Sheet setting. It is specific to SpreadJS.
clipboardOptions	Excel ignores this Sheet setting. It is specific to SpreadJS.
columnCount	Excel ignores this Sheet setting. It is specific to SpreadJS.
column header row count	Excel ignores this Sheet setting. It is specific to SpreadJS.
dataSource	Excel ignores this Sheet setting. It is specific to SpreadJS.
frozenlineColor	Excel ignores this Sheet setting. It is specific to SpreadJS.
frozenTrailingRowCount or frozenTrailingColumnCount	Excel ignores this Sheet setting. It is specific to SpreadJS.
rowCount	Excel ignores this Sheet setting. It is specific to SpreadJS.
row header column count	Excel ignores this Sheet setting. It is specific to SpreadJS.
rowHeaderAutoText(Index) or colHeaderAutoText(Index)	Excel ignores this Sheet setting. It is specific to SpreadJS.
selectionBackColor	Excel ignores this Sheet setting. It is specific to SpreadJS.
selectionBorderColor	Excel ignores this Sheet setting. It is specific to SpreadJS.
showRowOutline or showColumnOutline	Excel ignores this Sheet setting. Excel uses the displayed range group instead.