Editable Property (MultiColumnComboBoxCellType)

Gets or sets whether you can type into the edit portion of the multi-column combo box.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Editable As Boolean

'Usage
 
Dim instance As MultiColumnComboBoxCellType
Dim value As Boolean
 
instance.Editable = value
 
value = instance.Editable

public bool Editable {get; set;}

Remarks

If set to true, the end user can enter information in the cell by typing. If set to false, the end user can only interact with the drop-down list and cannot type in a value directly into the cell.

Example

This example sets the Editable property.

DataSet ds = new DataSet();
DataTable emp = new DataTable("Employees");
DataTable div = new DataTable("Division");
emp.Columns.Add("LastName");
emp.Columns.Add("FirstName");
emp.Rows.Add(new Object[] { "Jones", "Marianne" });
emp.Rows.Add(new Object[] { "Fieldes", "Anna" });
div.Columns.Add("Section");
div.Columns.Add("Specialty");
div.Rows.Add(new Object[] { "Finance", "Taxes" });
div.Rows.Add(new Object[] { "Mergers", "Legal" });
ds.Tables.AddRange(new DataTable[] { emp, div });

FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mcombo = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType();
mcombo.Editable = true;
mcombo.DataSourceList = ds;
mcombo.AutoSearch = FarPoint.Win.AutoSearch.MultipleCharacter;
fpSpread1.Sheets[0].Cells[1, 1].CellType = mcombo;

VB.NET

Dim ds As New DataSet()
Dim emp As New DataTable("Employees")
Dim div As New DataTable("Division")
emp.Columns.Add("LastName")
emp.Columns.Add("FirstName")
emp.Rows.Add(New Object() {"Jones", "Marianne"})
emp.Rows.Add(New Object() {"Fieldes", "Anna"})
div.Columns.Add("Section")
div.Columns.Add("Specialty")
div.Rows.Add(New Object() {"Finance", "Taxes"})
div.Rows.Add(New Object() {"Mergers", "Legal"})
ds.Tables.AddRange(New DataTable() {emp, div})

Dim mcombo As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType()
mcombo.Editable = True
mcombo.DataSourceList = ds
mcombo.AutoSearch = FarPoint.Win.AutoSearch.MultipleCharacter
FpSpread1.Sheets(0).Cells(1, 1).CellType = mcombo

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

MultiColumnComboBoxCellType Class
MultiColumnComboBoxCellType Members