FarPoint.Web.Spread.ListBoxCellType lb = new FarPoint.Web.Spread.ListBoxCellType(); FarPoint.Web.Spread.ListItem[] items = new FarPoint.Web.Spread.ListItem[2]; FarPoint.Web.Spread.ListItem item = new FarPoint.Web.Spread.ListItem(); item.Text = "A"; item.Value = "1"; items[0] = item; item = new FarPoint.Web.Spread.ListItem(); item.Text = "B"; item.Value = "2"; items[1] = item; lb.ListItems = items FpSpread1.ActiveSheetView.Cells[0, 0].CellType = lb; FpSpread1.ActiveSheetView.SetValue(0, 0, 2);
Dim lb As New FarPoint.Web.Spread.ListBoxCellType Dim items(2) As FarPoint.Web.Spread.ListItem Dim item As New FarPoint.Web.Spread.ListItem item.Text = "A" item.Value = "1" items(0) = item item = New FarPoint.Web.Spread.ListItem item.Text = "B" item.Value = "2" items(1) = item lb.ListItems = items FpSpread1.ActiveSheetView.Cells(0, 0).CellType = lb FpSpread1.ActiveSheetView.SetValue(0, 0, 2)