Spread ASP.NET 18
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ListBoxCellType Class / Values Property
Example


In This Topic
    Values Property (ListBoxCellType)
    In This Topic
    Gets or sets a string array of values for the list box list.
    Syntax
    '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;
    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