FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > MultiColumnComboBoxCellType Class > MultiColumnComboBoxCellType Constructor : MultiColumnComboBoxCellType Constructor(MultiColumnComboBoxCellType) |
'Declaration Public Function New( _ ByVal g As MultiColumnComboBoxCellType _ )
'Usage Dim g As MultiColumnComboBoxCellType Dim instance As New MultiColumnComboBoxCellType(g)
public MultiColumnComboBoxCellType( MultiColumnComboBoxCellType g )
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 mcb = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType(); mcb.DataSourceList = ds; fpSpread1.ActiveSheet.Cells[0, 0].CellType = mcb; FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mcb1 = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType(mcb); fpSpread1.ActiveSheet.Cells[0, 1].CellType = mcb1;
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 mcb As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType() mcb.DataSourceList = ds FpSpread1.ActiveSheet.Cells(0, 0).CellType = mcb Dim mcb1 As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType(mcb) FpSpread1.ActiveSheet.Cells(0, 1).CellType = mcb1
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