- GC
- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
- GC.Spread.Sheets
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.DataCharts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.DataRange
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Sheets.GanttSheet
- Collaboration
- GC.Spread.Excel
GC.Spread.Sheets.CellTypes.ComboBox
Class: ComboBox
Hierarchy
-
↳
ComboBox
Table of contents
Constructors
Properties
Methods
- activateEditor
- allowFloat
- createEditorElement
- dataBinding
- deactivateEditor
- editable
- editorValueType
- focus
- format
- fromJSON
- getAutoFitHeight
- getAutoFitWidth
- getEditorValue
- getHitInfo
- isEditingValueChanged
- isImeAware
- isReservedKey
- itemHeight
- items
- maxDropDownItems
- paint
- paintContent
- parse
- processKeyDown
- processKeyUp
- processMouseDown
- processMouseEnter
- processMouseLeave
- processMouseMove
- processMouseUp
- selectAll
- setEditorValue
- toJSON
- updateEditor
- updateEditorContainer
- updateImeMode
Constructors
constructor
• new ComboBox()
Represents an editable combo box cell.
example
//This example creates a combo box cell.
var cellType2 = new GC.Spread.Sheets.CellTypes.ComboBox();
cellType2.items(["a","b","c"]);
activeSheet.getCell(2, 2).cellType(cellType2);
Overrides
Properties
typeName
• typeName: string
Represents the type name string used for supporting serialization.
Inherited from
Methods
activateEditor
▸ activateEditor(editorContext, cellStyle, cellRect, context?): void
Activates the editor, including setting properties or attributes for the editor and binding events for the editor.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
cellStyle |
Style |
The cell's actual style. |
cellRect |
Rect |
The cell's layout information. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
allowFloat
▸ allowFloat(value?): any
Gets or sets whether the combo box's dropdown is allowed to overflow outside of Spread.
example
//This example sets the allowFloat method.
var items2 = ["a", "ab", "abc", "apple", "boy", "cat", "dog"];
var comboBoxCellType = new GC.Spread.Sheets.CellTypes.ComboBox().items(items2);
comboBoxCellType.allowFloat(false);
activeSheet.getCell(1, 3).cellType(comboBoxCellType);
Parameters
| Name | Type |
|---|---|
value? |
boolean |
Returns
any
If no value is set, returns the combo box's dropdown is allowed to overflow outside of Spread; otherwise, returns the combo box cellType.
createEditorElement
▸ createEditorElement(context?): HTMLElement
Creates a DOM element then returns it.
Parameters
| Name | Type | Description |
|---|---|---|
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
HTMLElement
Returns a DOM element.
Inherited from
dataBinding
▸ dataBinding(value?): IDataBinding | ComboBox
Gets or sets the data binding of the ComboBox cell type.
example
//This example shows binding a table name to the ComboBox cell type.
var tableName = { dataSource: "productName", text: "productName", value: "productId" };
var cellType = new GC.Spread.Sheets.CellTypes.ComboBox();
cellType.dataBinding(tableName);
activeSheet.getCell(1, 3).cellType(cellType);
example
//This example shows binding a formula to the ComboBox cell type.
var formula = { dataSource: '=SORT(UNIQUE(QUERY("Products", {"productName","productId"})))', text: 0, value: 1 };
var cellType2 = new GC.Spread.Sheets.CellTypes.ComboBox();
cellType2.dataBinding(formula);
activeSheet.getCell(10, 3).cellType(cellType2);
Parameters
| Name | Type |
|---|---|
value? |
IDataBinding |
Returns
If no value is set, returns the combo box's data binding; otherwise, returns the combo box cellType.
deactivateEditor
▸ deactivateEditor(editorContext, context?): void
Deactivates the editor, such as unbinding events for editor.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
editable
▸ editable(value?): any
Gets or sets whether the combo box is editable.
example
//This example sets the editable method.
var items2 = ["a", "ab", "abc", "apple", "boy", "cat", "dog"];
var eComboBoxCellType = new GC.Spread.Sheets.CellTypes.ComboBox().items(items2).editable(true);
activeSheet.getCell(1, 3).cellType(eComboBoxCellType);
activeSheet.setColumnWidth(0,120);
activeSheet.setColumnWidth(2,120);
Parameters
| Name | Type | Description |
|---|---|---|
value? |
boolean |
Whether the combo box is editable. |
Returns
any
If no value is set, returns whether the combo box is editable; otherwise, returns the combo box cellType.
editorValueType
▸ editorValueType(value?): any
Gets or sets the value that is written to the underlying data model.
example
//This example gets the type.
var cellType2 = new GC.Spread.Sheets.CellTypes.ComboBox();
cellType2.items(["a","b","c"]);
activeSheet.getCell(2, 2).cellType(cellType2);
alert(cellType2.editorValueType());
Parameters
| Name | Type | Description |
|---|---|---|
value? |
EditorValueType |
The type of editor value. |
Returns
any
If no value is set, returns the type of editor value; otherwise, returns the combo box cellType.
focus
▸ focus(editorContext, context?): void
Focuses the editor DOM element.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
format
▸ format(value, format, formattedData?, context?): string
Formats a value with the specified format to a string.
Parameters
| Name | Type | Description |
|---|---|---|
value |
any |
The object value to format. |
format |
string | GeneralFormatter |
The format. |
formattedData? |
FormattedData |
the formatted data. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
string
Returns the formatted string.
Inherited from
fromJSON
▸ fromJSON(settings): void
Loads the object state from the specified JSON string.
Parameters
| Name | Type | Description |
|---|---|---|
settings |
any |
The cell type data from deserialization. |
Returns
void
Inherited from
getAutoFitHeight
▸ getAutoFitHeight(value, text, cellStyle, zoomFactor, context?): number
Gets a cell's height that can be used to handle the row's automatic fit.
Parameters
| Name | Type | Description |
|---|---|---|
value |
any |
The cell's value. |
text |
string |
The cell's text. |
cellStyle |
Style |
The cell's actual value. |
zoomFactor |
number |
The current sheet's zoom factor. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
number
Returns the cell's height that can be used to handle the row's automatic fit.
Inherited from
getAutoFitWidth
▸ getAutoFitWidth(value, text, cellStyle, zoomFactor, context?): number
Gets a cell's width that can be used to handle the column's automatic fit.
Parameters
| Name | Type | Description |
|---|---|---|
value |
any |
The cell's value. |
text |
string |
The cell's text. |
cellStyle |
Style |
The cell's actual value. |
zoomFactor |
number |
The current sheet's zoom factor. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
number
Returns the cell's width that can be used to handle the column's automatic fit.
Inherited from
getEditorValue
▸ getEditorValue(editorContext, context?): any
Gets the editor's value.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
any
Returns the editor's value.
Inherited from
getHitInfo
▸ getHitInfo(x, y, cellStyle, cellRect, context?): IHitTestCellTypeHitInfo
Gets the cell type's hit information.
Parameters
| Name | Type | Description |
|---|---|---|
x |
number |
x-coordinate of pointer's current location relative to the canvas. |
y |
number |
y-coordinate of pointer's current location relative to the canvas. |
cellStyle |
Style |
The current cell's actual style. |
cellRect |
Rect |
The current cell's layout information. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
Returns an object that contains the x, y, row, col, cellRect, and sheetArea parameters, and a value to indicate isReservedLocation.
isReservedLocation is true if the hit test is in a special area that the cell type needs to handle; otherwise, false.
Inherited from
isEditingValueChanged
▸ isEditingValueChanged(oldValue, newValue, context?): boolean
Whether the editing value has changed.
Parameters
| Name | Type | Description |
|---|---|---|
oldValue |
any |
Old editing value. |
newValue |
any |
New editing value. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
true if oldValue equals newValue; otherwise, false.
Inherited from
isImeAware
▸ isImeAware(context?): boolean
Whether this cell type is aware of IME.
Parameters
| Name | Type | Description |
|---|---|---|
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
true if the cell type is aware of IME; otherwise, false.
Inherited from
isReservedKey
▸ isReservedKey(e, context?): boolean
Whether the cell type handles the keyboard event itself.
Parameters
| Name | Type | Description |
|---|---|---|
e |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
Returns true if the cell type handles the keyboard event itself; otherwise, false.
Inherited from
itemHeight
▸ itemHeight(value?): any
Gets or sets the height of each item.
example
//This example sets the item height.
var cellType2 = new GC.Spread.Sheets.CellTypes.ComboBox();
cellType2.items(["a","b","c"]);
cellType2.itemHeight(30);
activeSheet.getCell(2, 2).cellType(cellType2);
Parameters
| Name | Type | Description |
|---|---|---|
value? |
number |
The height of each item. |
Returns
any
If no value is set, returns the height of each item; otherwise, returns the combo box cellType.
items
▸ items(items?): any
Gets or sets the items for the drop-down list in the combo box.
example
//This example creates a combo box cell.
var cellType2 = new GC.Spread.Sheets.CellTypes.ComboBox();
cellType2.items(["a","b","c"]);
activeSheet.getCell(2, 2).cellType(cellType2);
Parameters
| Name | Type | Description |
|---|---|---|
items? |
any[] |
The items for the combo box. |
Returns
any
If no value is set, returns the items array; otherwise, returns the combo box cellType.
maxDropDownItems
▸ maxDropDownItems(value?): any
Gets or sets the maximum item count of the drop-down list per page.
example
//This example shows three items in the list at a time.
var cellType2 = new GC.Spread.Sheets.CellTypes.ComboBox();
cellType2.items(["a", "b", "c", "d", "e", "f", "g", "h"]);
cellType2.maxDropDownItems(3);
activeSheet.getCell(2, 2).cellType(cellType2);
});
Parameters
| Name | Type | Description |
|---|---|---|
value? |
number |
The maximum item count of the drop-down list per page. |
Returns
any
If no value is set, returns the maximum item count of the drop-down list per page; otherwise, returns the combo box cellType.
paint
▸ paint(ctx, value, x, y, w, h, style, context?): void
Paints a cell on the canvas.
Parameters
| Name | Type | Description |
|---|---|---|
ctx |
CanvasRenderingContext2D |
The canvas's two-dimensional context. |
value |
any |
The cell's value. |
x |
number |
x-coordinate relative to the canvas. |
y |
number |
y-coordinate relative to the canvas. |
w |
number |
The cell's width. |
h |
number |
The cell's height. |
style |
Style |
The cell's actual style. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
paintContent
▸ paintContent(ctx, value, x, y, w, h, style, context?): void
Paints the cell content area on the canvas.
Parameters
| Name | Type | Description |
|---|---|---|
ctx |
CanvasRenderingContext2D |
The canvas's two-dimensional context. |
value |
any |
The cell's value. |
x |
number |
x-coordinate relative to the canvas. |
y |
number |
y-coordinate relative to the canvas. |
w |
number |
The cell content area's width. |
h |
number |
The cell content area's height. |
style |
Style |
The cell's actual style. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
parse
▸ parse(text, formatStr, context?): any
Parses the text with the specified format string to an object.
Parameters
| Name | Type | Description |
|---|---|---|
text |
string |
The parse text string. |
formatStr |
string |
The parse format string. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
any
The parsed object.
Inherited from
processKeyDown
▸ processKeyDown(event, context?): boolean
Processes key down in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
event |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processKeyUp
▸ processKeyUp(event, context?): boolean
Processes key up in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
event |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseDown
▸ processMouseDown(hitInfo): boolean
Processes mouse down in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseEnter
▸ processMouseEnter(hitInfo): boolean
Processes mouse enter in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseLeave
▸ processMouseLeave(hitInfo): boolean
Processes mouse leave in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseMove
▸ processMouseMove(hitInfo): boolean
Processes mouse move in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseUp
▸ processMouseUp(hitInfo): boolean
Processes mouse up in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
selectAll
▸ selectAll(editorContext, context?): void
Selects all the text in the editor DOM element.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
setEditorValue
▸ setEditorValue(editorContext, value, context?): void
Sets the editor's value.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
value |
any |
The value returned from the active cell. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
toJSON
▸ toJSON(): any
Saves the object state to a JSON string.
Returns
any
The cell type data.
Inherited from
updateEditor
▸ updateEditor(editorContext, cellStyle, cellRect, context?): Rect
Updates the editor's size.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
cellStyle |
Style |
The cell's actual style. |
cellRect |
Rect |
The cell's layout information. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
Returns the new size for cell wrapper element, it should contain two properties 'width' and 'height'.
Inherited from
updateEditorContainer
▸ updateEditorContainer(editorContext, editorBounds, cellStyle): void
Updates the cell wrapper element size.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
editorBounds |
Rect |
The cell wrapper element's new size. |
cellStyle |
Style |
The cell's actual style. |
Returns
void
Inherited from
updateImeMode
▸ updateImeMode(editorContext, imeMode, context?): void
Updates the editor's ime-mode.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
imeMode |
ImeMode |
The ime-mode from cell's actual style. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void