# Spread Settings Exported

## Content

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** |
|---|---|
| [name](/spreadjs/api/v16/classes/GC.Spread.Sheets.Workbook#name) | 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. |
| [startSheetIndex](/spreadjs/api/v16/classes/GC.Spread.Sheets.Workbook#startSheetIndex) | 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. |