ColumnEdit Property | Spread Windows Forms 13.0 Product Documentation

ColumnEdit Property

In This Topic

Gets or sets which list column (by index) serves as the edit portion of the combo box.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ColumnEdit As Integer

'Usage
 
Dim instance As MultiColumnComboBoxCellType
Dim value As Integer
 
instance.ColumnEdit = value
 
value = instance.ColumnEdit

public int ColumnEdit {get; set;}

Property Value

Integer column index

Example

This example creates a cell of this type, sets properties of this cell type, and assigns this cell type to a cell.

FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mcb = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType();
mcb.BackgroundImage = null;
mcb.DataSourceList = ds;
mcb.DataColumn = 2;
mcb.ColumnEdit = 2;
mcb.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Left;
mcb.ListAlignment = FarPoint.Win.ListAlignment.Right;
mcb.ListWidth = 500;
mcb.ListOffset = 5;
mcb.MaxDrop = 5;
mcb.StringTrim = StringTrimming.EllipsisCharacter;
mcb.SubEditor = null;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = mcb;

Visual Basic

Dim mcb As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType()
mcb.BackgroundImage = Nothing
mcb.DataSourceList = ds
mcb.DataColumn = 2
mcb.ColumnEdit = 2
mcb.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows
mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Left
mcb.ListAlignment = FarPoint.Win.ListAlignment.Right
mcb.ListWidth = 500
mcb.ListOffset = 5
mcb.MaxDrop = 5
mcb.StringTrim = StringTrimming.EllipsisCharacter
mcb.SubEditor = Nothing
FpSpread1.ActiveSheet.Cells(0, 0).CellType = mcb

Reference

MultiColumnComboBoxCellType Class
MultiColumnComboBoxCellType Members

Product Support Forum | Print this page