Values Property (ListBoxCellType)

Gets or sets a string array of values for the list box list.

Syntax

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

Remarks

This property is available at run time only.

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;

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

Requirements

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