Collapse All Expand All

This table summarizes how the Cell settings are handled when Spread.Sheets exports to an Excel-formatted file. These functions are in the GC.Spread.Sheets.CellRange class unless otherwise noted.

Cell Setting	Excel Setting and Remarks
value or text	Excel uses this setting.
bindingPath	Excel ignores this setting. This is specific to Spread.Sheets.
cellType	Excel ignores this setting. This is specific to Spread.Sheets.
backgroundImage	Excel ignores this setting. This is specific to Spread.Sheets.
backgroundImageLayout	Excel ignores this setting. This is specific to Spread.Sheets.
backColor	Excel uses this setting.
borderLeft, borderTop, borderRight, or borderBottom	Excel uses this setting.
foreColor	Excel uses this setting.
hAlign (text horizontal alignment)	Excel uses this setting.
vAlign (text vertical alignment)	Excel uses this setting.
font	Excel uses this setting.
formatter	Excel uses this setting.
formula	Excel uses this setting.
locked	Excel uses this setting.
shrinkToFit	Excel uses this setting.
tabStop	Excel ignores this setting. This is specific to Spread.Sheets.
textIndent	Excel uses this setting.
themeFont	Excel uses this setting.
validator	Excel uses this setting.
wordWrap	Excel uses this setting.

 

 

---

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.