Values Property (ListBoxCellType)

Visual Basic
C#

'Declaration
 
Public Overridable Property Values As String()

'Usage
 
Dim instance As ListBoxCellType
Dim value() As String
 
instance.Values = value
 
value = instance.Values

public virtual string[] Values {get; set;}

Property Value

String array containing the values corresponding to the items in the list

This property is available at run time only.

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.

C#

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;

Visual Basic

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

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

Reference

ListBoxCellType Class
ListBoxCellType Members