GrapeCity.Documents.Excel.EditorValueType

EditorValueType Enum

Specifies what is written to the data model when a user selects an item from a cell type that supports multiple choices.

Use this enum to control whether the selected item's display text, zero-based index, or underlying item value is stored. This enum is commonly used with ComboBoxCellType.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum EditorValueType

Public Enum EditorValueType

Examples

ComboBoxCellType cellType = new ComboBoxCellType();
ComboBoxCellItem item1 = new ComboBoxCellItem();
item1.Text = "United States";
item1.Value = "US";
cellType.Items.Add(item1);
ComboBoxCellItem item2 = new ComboBoxCellItem();
item2.Text = "China";
item2.Value = "CN";
cellType.Items.Add(item2);
cellType.EditorValueType = EditorValueType.Value;
worksheet.Range["A1"].CellType = cellType;
worksheet.Range["A1"].Value = "CN";

Fields

Name	Description
Index	Writes the index of the selected item to the model.
Text	Writes the text value of the selected item to the model.
Value	Writes the corresponding data value of the selected item to the model.