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 |