Spread for ASP.NET 11 Product Documentation
Items Property (ListBoxCellType)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ListBoxCellType Class : Items Property
Gets or sets a string array of items for the list box list.
Syntax
'Declaration
 
Public Overridable Property Items As String()
'Usage
 
Dim instance As ListBoxCellType
Dim value() As String
 
instance.Items = value
 
value = instance.Items
public virtual string[] Items {get; set;}

Property Value

String array containing items for the list
Example
This example creates a ListBoxCellType Object and assigns it to the first cell in the sheet. An array of items for the list and the values for the corresponding items are supplied. The background and foreground colors of the selected item are defined and the value of the cell is set to the third item in the list.
string[]lbstr;
lbstr=new String[]{"Carbon","Oxygen","Hydrogen"};
string[]strval;
strval=new String[]{"1","2","3"};
FarPoint.Web.Spread.ListBoxCellType lbcell=new FarPoint.Web.Spread.ListBoxCellType();
lbcell.SelectedBackColor=Color.Yellow;
lbcell.SelectedForeColor=Color.DarkBlue;
lbcell.Items=lbstr;
lbcell.Values=strval;
FpSpread1.ActiveSheetView.Cells[0,0].CellType=lbcell;
FpSpread1.ActiveSheetView.SetValue(0,0,"3");
FpSpread1.ActiveSheetView.Rows[0].Height=140;
Dim lbstr As String()
lbstr=New String(){"Carbon","Oxygen","Hydrogen"}
Dim strval As String()
strval=New String(){"1","2","3"}
Dim lbcell As New FarPoint.Web.Spread.ListBoxCellType(lbstr,strval)
lbcell.SelectedBackColor=Color.Yellow
lbcell.SelectedForeColor=Color.DarkBlue
lbcell.Items=lbstr
lbcell.Values=strval
FpSpread1.ActiveSheetView.Cells(0,0).CellType=lbcell
FpSpread1.ActiveSheetView.SetValue(0,0,"3")
FpSpread1.ActiveSheetView.Rows(0).Height=140
See Also

Reference

ListBoxCellType Class
ListBoxCellType Members