Editable Property (ComboBoxCellType)

Visual Basic
C#

'Declaration
 
Public Property Editable As Boolean

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

public bool Editable {get; set;}

Property Value

Boolean: true if editable by the end user; false otherwise

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 can not type in a value directly into the cell.

If set to true, you should turn off AutoSearch, otherwise the control replaces any text entered as soon as a match with the automatic search is found.

This example sets up a cell on the first sheet with a combo box with the first six months of the year and specifies the size of the portion displayed.

C#

FarPoint.Win.Spread.CellType.ComboBoxCellType cmbocell = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
cmbocell.Items = (new String[] {"January", "February", "March", "April", "May", "June"});
cmbocell.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
cmbocell.AutoSearch = FarPoint.Win.AutoSearch.SingleCharacter;
cmbocell.Editable = true;
cmbocell.ListAlignment = FarPoint.Win.ListAlignment.Left;
cmbocell.ListOffset = 20;
cmbocell.ListWidth = 0;
cmbocell.MaxDrop = 4;
fpSpread1.Sheets[1].Cells[2,2].CellType = cmbocell;

Visual Basic

Dim cmbocell As New FarPoint.Win.Spread.CellType.ComboBoxCellType()
cmbocell.Items = (new String() {"January", "February", "March", "April", "May", "June"})
cmbocell.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows
cmbocell.AutoSearch = FarPoint.Win.AutoSearch.SingleCharacter
cmbocell.Editable = True
cmbocell.ListAlignment = FarPoint.Win.ListAlignment.Left
cmbocell.ListOffset = 20
cmbocell.ListWidth = 0
cmbocell.MaxDrop = 4
fpSpread1.Sheets(1).Cells(2,2).CellType = cmbocell

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

ComboBoxCellType Class
ComboBoxCellType Members

User-Task Documentation

Setting a Combo Box Cell