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