Spread.Sheets Documentation
Using the Cell Elements

The cell elements are CheckBoxCellType, TextCellType, ButtonCellType, ComboBoxCellType, and HyperLinkCellType.

The text cell type has no attributes or child elements.

The CheckBoxCellType element has no child elements. The following table lists the attributes of the CheckBoxCellType element.

Attribute API Reference Type
caption GC.Spread.Sheets.CellTypes.CheckBox.caption(value) string
isThreeState GC.Spread.Sheets.CellTypes.CheckBox.isThreeState(value) Boolean
textAlign GC.Spread.Sheets.CellTypes.CheckBox.textAlign(value) GC.Spread.Sheets.CellTypes.CheckBoxTextAlign
textFalse GC.Spread.Sheets.CellTypes.CheckBox.textFalse(value) string
textIndeterminate GC.Spread.Sheets.CellTypes.CheckBox.textIndeterminate(value) string
textTrue GC.Spread.Sheets.CellTypes.CheckBox.textTrue(value) string

The ButtonCellType element has no child elements. The following table lists the attributes of the ButtonCellType element.

Attribute API Reference Type
buttonBackColor GC.Spread.Sheets.CellTypes.Button.buttonBackColor(value) string
marginBottom GC.Spread.Sheets.CellTypes.Button.marginBottom(value) number
marginLeft GC.Spread.Sheets.CellTypes.Button.marginLeft(value) number
marginRight GC.Spread.Sheets.CellTypes.Button.marginRight(value) number
marginTop GC.Spread.Sheets.CellTypes.Button.marginTop(value) number
text GC.Spread.Sheets.CellTypes.Button.text(value) string

The ComboBoxCellType element has the following attribute.

Attribute API Reference Type
editorValueType GC.Spread.Sheets.CellTypes.ComboBox.editorValueType(value) GC.Spread.Sheets.CellTypes.EditorValueType

The ComboBoxCellType element has the following child element.

Child Element API Reference Count Type
item GC.Spread.Sheets.CellTypes.items any item.value:string, item.text:string

The following example uses the item element.

JavaScript
Copy Code
<column>
    <default-style>
        <combobox-cell-type EditorValueType="Value">
            <item value="11" text="aa"></item>
            <item value="22" text="bb"></item>
            <item value="33" text="cc"></item>
            <item value="44" text="dd"></item>
        </combobox-cell-type>
    </default-style>
</column>

The HyperLinkCellType element has no child elements. The following table lists the attributes of the HyperLinkCellType element.

Attribute API Reference Type
linkColor GC.Spread.Sheets.CellTypes.HyperLink.linkColor(value) string
linkToolTip GC.Spread.Sheets.CellTypes.HyperLink.linkToolTip(value) string
text GC.Spread.Sheets.CellTypes.HyperLink.text(value) number
visitedLinkColor GC.Spread.Sheets.CellTypes.HyperLink.visitedLinkColor(value) number

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.