ListItems Property (ListBoxCellType)

Visual Basic
C#

'Declaration
 
Public Property ListItems As ListItem()

'Usage
 
Dim instance As ListBoxCellType
Dim value() As ListItem
 
instance.ListItems = value
 
value = instance.ListItems

public ListItem[] ListItems {get; set;}

Property Value

ListItem array containing the list of items

This property is available at run time only.

This example creates a list box cell type and assigns it to the first cell in the sheet with a list of three items and displays two of them at any time.

C#

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;

Visual Basic

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

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

ListBoxCellType Class
ListBoxCellType Members