- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
Sheet Settings Exported
This table summarizes how the Sheet settings are handled when SpreadJS 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 SpreadJS. |
dataSource | Excel ignores the Sheet setting. This is specific to SpreadJS. |
frozenRowCount or frozenColumnCount | Excel uses this setting. |
frozenTrailingRowCount or frozenTrailingColumnCount | Excel ignores the Sheet setting. This is specific to SpreadJS. |
rowCount | Excel ignores the Sheet setting. This is specific to SpreadJS. |
columnCount | Excel ignores the Sheet setting. This is specific to SpreadJS. |
data | Excel loads the data from SpreadJS. |
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 SpreadJS. |
selectionBorderColor | Excel ignores the Sheet setting. This is specific to SpreadJS. |
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 SpreadJS. |
rowHeaderAutoText(Index) or colHeaderAutoText(Index) | Excel ignores the Sheet setting. This is specific to SpreadJS. |
rowHeaderVisible or colHeaderVisible | Excel uses this setting. |
row header column count | Excel ignores the Sheet setting. This is specific to SpreadJS. |
column header row count | Excel ignores the Sheet setting. This is specific to SpreadJS. |
clipboardOptions | Excel ignores the Sheet setting. This is specific to SpreadJS. |
isProtected | Excel uses this setting. |
borderColor | Excel ignores the Sheet setting. This is specific to SpreadJS. |
borderWidth | Excel ignores the Sheet setting. This is specific to SpreadJS. |
table | Excel uses this setting. |
named styles | Excel uses this setting. |
showZeros | Excel uses this setting. |