Rows Property (ListBoxCellType)

Visual Basic
C#

'Declaration
 
Public Property Rows As Integer

'Usage
 
Dim instance As ListBoxCellType
Dim value As Integer
 
instance.Rows = value
 
value = instance.Rows

public int Rows {get; set;}

Property Value

Integer number of items (rows) of the list box to display

This property sets the number of rows in the list box to display when the cell is in edit mode. When the user clicks on a cell and the list box editor control is displayed, the number of items that are displayed is determined by this property.

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