Spread.Sheets Documentation
Spread Settings Exported

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.