Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ComboBoxCellType Class / Values Property
Example


In This Topic
    Values Property (ComboBoxCellType)
    In This Topic
    Gets or sets a string array of values for the combo box list.
    Syntax
    'Declaration
     
    
    Public Overridable Property Values As String()
    'Usage
     
    
    Dim instance As ComboBoxCellType
    Dim value() As String
     
    instance.Values = value
     
    value = instance.Values
    public virtual string[] Values {get; set;}

    Property Value

    String array containing the values for the corresponding list items
    Remarks
    This property is available at run time only.
    Example
    This example creates a ComboBoxCellType object and makes all the cells in the first column combo boxes. It sets the text in the cell using the values.
    string[]cbstr;
    string[]strval;
    cbstr=new String[]{"One","Two","Three"};
    strval=new String[]{"1","2","3"};
    FarPoint.Web.Spread.ComboBoxCellType cb=new FarPoint.Web.Spread.ComboBoxCellType();
    cb.Items=cbstr;
    cb.Values=strval;
    FpSpread1.ActiveSheetView.Columns[0].CellType=cb;
    FpSpread1.ActiveSheetView.DataModel.SetValue(0,0,"1");
    TextBox1.Text=cb.EditorClientScriptUrl;
    Dim cbstr As String()
    cbstr=New String(){"One","Two","Three"}
    Dim strval As String()
    strval=New String(){"1","2","3"}
    Dim cb As New FarPoint.Web.Spread.ComboBoxCellType()
    cb.Items=cbstr
    cb.Values=strval
    FpSpread1.ActiveSheetView.Columns(0).CellType=cb
    FpSpread1.ActiveSheetView.DataModel.SetValue(0,0,"1")
    TextBox1.Text=cb.EditorClientScriptUrl
    See Also