Spread for ASP.NET 8.0 Product Documentation
Rows Property (ListBoxCellType)
Example 


Gets or sets the number of items to display when when editing the list.
Syntax
'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
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.
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
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

Reference

ListBoxCellType Class
ListBoxCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.