This table summarizes how component-level items are handled when Spread.Sheets 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 | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.sheetCount | Excel uses this setting. |
activeSheetIndex | Excel uses this setting. |
options.tabStripRatio | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.tabStripVisible | Not supported at this time. |
options.tabEditable | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.newTabVisible | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.referenceStyle | Excel uses this setting. |
options.allowUserEditFormula | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
startSheetIndex | Excel uses this setting. |
options.allowUndo | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.allowUserZoom | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.allowUserResize | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.allowUserDragDrop | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.allowUserDragFill | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.highlightInvalidData | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.autoFitType | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.showScrollTip | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.showResizeTip | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.showDragDropTip | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.showDragFillTip | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.showHorizontalScrollbar | Excel uses this setting. |
options.showVerticalScrollbar | Excel uses this setting. |
options.backColor | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.backgroundImage | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.backgroundImageLayout | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
options.grayAreaBackColor | Excel ignores the Spread setting. This is specific to Spread.Sheets. |
named styles | Excel uses this setting. |
names | Excel uses this setting. |