FarPoint.Web.Spread.ListBoxCellType list = new FarPoint.Web.Spread.ListBoxCellType();
FarPoint.Web.Spread.ListItem[] items = new FarPoint.Web.Spread.ListItem[3];
FarPoint.Web.Spread.ListItem item = new FarPoint.Web.Spread.ListItem();
item.Text = "First";
item.Value = "Gold";
items[0] = item;
item = new FarPoint.Web.Spread.ListItem();
item.Text = "Second";
item.Value = "Silver";
items[1] = item;
item = new FarPoint.Web.Spread.ListItem();
item.Text = "Third";
item.Value = "Bronze";
items[2] = item;
list.ListItems = items;
// number of items to display in list
list.Rows = 2;
FpSpread1.Sheets[0].Cells[0,0].CellType = list;
Dim list As New FarPoint.Web.Spread.ListBoxCellType()
Dim item As New FarPoint.Web.Spread.ListItem()
Dim items(3) As FarPoint.Web.Spread.ListItem
item.Text = "First"
item.Value = "Gold"
items(0) = item
item = New FarPoint.Web.Spread.ListItem()
item.Text = "Second"
item.Value = "Silver"
items(1) = item
item = New FarPoint.Web.Spread.ListItem()
item.Text = "Third"
item.Value = "Bronze"
items(2) = item
list.ListItems = items
' number of items to display in list
list.Rows = 2
FpSpread1.Sheets(0).Cells(0, 0).CellType = list