- 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
Spread Settings Exported
This table summarizes how component-level items are handled when SpreadJS exports to an Excel-formatted file. These functions are in the GC.Spread.Sheets.Workbook class unless otherwise noted.
Spread Setting | Excel Setting and Remarks |
|---|---|
Excel ignores the Spread setting. This is specific to SpreadJS. | |
options.sheetCount | Excel uses this setting. |
activeSheetIndex | Excel uses this setting. |
options.tabStripRatio | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.tabStripVisible | Not supported at this time. |
options.tabEditable | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.newTabVisible | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.referenceStyle | Excel uses this setting. |
options.allowUserEditFormula | Excel ignores the Spread setting. This is specific to SpreadJS. |
Excel uses this setting. | |
options.allowUndo | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.allowUserZoom | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.allowUserResize | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.allowUserDragDrop | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.allowUserDragFill | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.highlightInvalidData | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.autoFitType | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.showScrollTip | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.showResizeTip | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.showDragDropTip | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.showDragFillTip | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.showHorizontalScrollbar | Excel uses this setting. |
options.showVerticalScrollbar | Excel uses this setting. |
options.backColor | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.backgroundImage | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.backgroundImageLayout | Excel ignores the Spread setting. This is specific to SpreadJS. |
options.grayAreaBackColor | Excel ignores the Spread setting. This is specific to SpreadJS. |
named styles | Excel uses this setting. Apply flags set to named styles are exported to Excel. |
names | Excel uses this setting. |