Spread Windows Forms 11.0 Product Documentation
ItemData Property (ComboBoxCellType)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > ComboBoxCellType Class : ItemData Property
Gets or sets the corresponding data for the items in the drop-down list in the combo box.
Syntax
'Declaration
 
Public Property ItemData As String()
'Usage
 
Dim instance As ComboBoxCellType
Dim value() As String
 
instance.ItemData = value
 
value = instance.ItemData
public string[] ItemData {get; set;}

Property Value

String array with data corresponding to the items
Example
This example gets and sets item data.
FarPoint.Win.Spread.CellType.ComboBoxCellType combo = new FarPoint.Win.Spread.CellType.ComboBoxCellType();

private void Form1_Load(object sender, System.EventArgs e)
{        
      string[] cbstr;
      cbstr = new String[] {"One", "Two", "Three"};
      string[] strval;
      strval = new String[] {"1", "2", "3"};
      combo.Items = cbstr;
      combo.ItemData = strval;
      combo.EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData;
      fpSpread1.Sheets[0].Cells[0, 0].CellType = combo;
}

private void fpSpread1_ComboSelChange(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e)
{
      textBox1.Text = fpSpread1.Sheets[0].Cells[0, 0].Value.ToString();
}
Dim combo As New FarPoint.Win.Spread.CellType.ComboBoxCellType()

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim cbstr As String()
        cbstr = New String() {"One", "Two", "Three"}
        Dim strval As String()
        strval = New String() {"1", "2", "3"}
        combo.Items = cbstr
        combo.ItemData = strval
        combo.EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData
        fpSpread1.Sheets(0).Cells(0, 0).CellType = combo
End Sub


Private Sub fpSpread1_ComboSelChange(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EditorNotifyEventArgs) Handles
fpSpread1.ComboSelChange
        TextBox1.Text = fpSpread1.Sheets(0).Cells(0, 0).Value
End Sub
See Also

Reference

ComboBoxCellType Class
ComboBoxCellType Members

User-Task Documentation

Setting a Combo Box Cell