Collapse All Expand All

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.

 

 

---

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.