[]
        
(Showing Draft Content)

Cell Settings Exported

This table summarizes how the Cell settings are handled when SpreadJS 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 SpreadJS.

cellType

Excel ignores this setting. This is specific to SpreadJS.

backgroundImage

Excel ignores this setting. This is specific to SpreadJS.

backgroundImageLayout

Excel ignores this setting. This is specific to SpreadJS.

backColor

Excel uses this setting.

borderLeft,borderTop,borderRight, orborderBottom

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

textIndent

Excel uses this setting.

themeFont

Excel uses this setting.

validator

Excel uses this setting.

wordWrap

Excel uses this setting.