Spread for ASP.NET 7.0 Product Documentation
Rows Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ListBoxCellType Class : Rows Property


Glossary Item Box

Gets or sets the number of items to display when when editing the list.

Syntax

Visual Basic (Declaration) 
Public Property Rows As Integer
Visual Basic (Usage)Copy Code
Dim instance As ListBoxCellType
Dim value As Integer
 
instance.Rows = value
 
value = instance.Rows
C# 
public int Rows {get; set;}

Property Value

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

Remarks

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.

Example

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#Copy Code
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 BasicCopy Code
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

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.