MESCIUS SPREAD for Windows Forms 15.0J
ItemData プロパティ (ComboBoxCellType)
使用例 

コンボ ボックスのドロップダウン リストの項目に対応するデータを取得または設定します。
構文
'宣言
 
Public Property ItemData As String()
public string[] ItemData {get; set;}

プロパティ値

項目に対応するデータを含む String の配列
使用例
次のサンプルコードは、項目データを取得して設定します。
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
参照

ComboBoxCellType クラス
ComboBoxCellType メンバ

開発者ガイド

コンボボックス型セル

 

 


© MESCIUS inc. All rights reserved.