ItemData Property (ComboBoxCellType)

Gets or sets the corresponding data for the items in the drop-down list in the combo box.

Syntax

Visual Basic
C#

'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();
}

Visual Basic

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ComboBoxCellType Class
ComboBoxCellType Members

User-Task Documentation

Setting a Combo Box Cell