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. |