[]
        
(Showing Draft Content)

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 code sample uses the item element.

<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