GrapeCity.Documents.Excel.ComboBoxCellType

ComboBoxCellType Class

Represents an editable combo box cell.

A combo box cell type displays a drop-down list of items that users can select from. Items are added via ComboBoxCellItem objects. The combo box can be configured as editable or read-only, and the value written to the data model can be controlled via EditorValueType.

Inheritance

object

BaseCellType

ComboBoxCellType

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public class ComboBoxCellType : BaseCellType

Public Class ComboBoxCellType
    Inherits BaseCellType

Examples

ComboBoxCellType cellType = new ComboBoxCellType();
cellType.EditorValueType = EditorValueType.Value;

ComboBoxCellItem item = new ComboBoxCellItem();
item.Value = "US";
item.Text = "United States";
cellType.Items.Add(item);

worksheet.Range["C5"].CellType = cellType;
worksheet.Range["C5"].Value = "US";

Constructors

Name	Description
ComboBoxCellType()	Initializes a new instance of the ComboBoxCellType class.

Properties

Name	Description
Editable	Gets or sets whether the combo box is editable.
EditorValueType	Gets or sets the value that is written to the underlying data model.
ItemHeight	Gets or sets the height of each item.
Items	Gets the items for the drop-down list in the combo box.
MaxDropDownItems	Gets or sets the maximum item count of the drop-down list per page.