Using the Style Element

The following table lists the attributes of the style element.

Attribute	API Reference	Type	Comment
backColor	style.backColor	string
backgroundImage	style.backgroundImage	string
backgroundImageLayout	spread.backgroundImageLayout(value)	GC.Spread.Sheets.ImageLayout
border	style.borderLeft, borderTop, borderRight, borderBottom	string	Setting the border attribute sets borderLeft, borderTop, borderRight, and borderBottom at the same time
borderBottom	style.borderBottom	string
borderLeft	style.borderLeft	string
borderRight	style.borderRight	string
borderTop	style.borderTop	string
font	style.font	string
foreColor	style.foreColor	string
formatter	style.formatter	string
hAlign	style.hAlign	GC.Spread.Sheets.HorizontalAlign
locked	style.locked	boolean
shrinkToFit	style.shrinkToFit	boolean
textIndent	style.textIndent	number
themeFont	style.themeFont	string
vAlign	style.vAlign	GC.Spread.Sheets.VerticalAlign
wordWrap	style.wordWrap	boolean

The following table lists the child elements of the style element.

Child Element	API Reference	Count	Type	Comments
dateValidator	style.validator	1	dateValidator
formulaValidator	style.validator	1	formulaValidator
formulaListValidator	style.validator	1	formulaListValidator
listValidator	style.validator	1	listValidator
numberValidator	style.validator	1	numberValidator
textLengthValidator	style.validator	1	textLengthValidator
ButtonCellType	style.cellType	1	GC.Spread.Sheets.CellTypes.Button	If you add more then one cell type to a style, the last cell type overrides the previous cell types
CheckBoxCellType	style.cellType	1	GC.Spread.Sheets.CellTypes.CheckBox	If you add more then one cell type to a style, the last cell type overrides the previous cell types
ComboBoxCellType	style.cellType	1	GC.Spread.Sheets.CellTypes.ComboBox	If you add more then one cell type to a style, the last cell type overrides the previous cell types
HyperLinkCellType	style.cellType	1	GC.Spread.Sheets.CellTypes.HyperLink	If you add more then one cell type to a style, the last cell type overrides the previous cell types
TextCellType	style.cellType	1	GC.Spread.Sheets.CellTypes.Text	If you add more then one cell type to a style, the last cell type overrides the previous cell types

The following example uses a style element.

<gc-spread-sheets id="ss" style="width:100%;height:500px;border:1px solid gray">
    <worksheets>
        <worksheet>
            <columns>
                <column>
                    <default-style formatter="#,##0.00">
                        <number-validator comparisonoperator="GreaterThan" value1="0"></number-validator>
                    </default-style>
                </column>
                <column>
                    <default-style>
                        <list-validator list="Japan,Germany,UK,Italy,US"></list-validator>
                    </default-style>
                </column>
                <column>
                    <default-style>
                        <button-cell-type text="click me"></button-cell-type>
                    </default-style>
                </column>
            </columns>
        </worksheet>
    </worksheets>
</gc-spread-sheets>