FarPoint.Win.Spread アセンブリ > FarPoint.Win.Spread.CellType 名前空間 > ComboBoxCellType クラス : Items プロパティ |
次のサンプルコードは、1月から6月までを含むコンボボックスを最初のシートのセルに設定し、表示部分のサイズを指定します。
FarPoint.Win.Spread.CellType.ComboBoxCellType cmbocell = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); cmbocell.Items = (new String[] {"January", "February", "March", "April", "May", "June"}); cmbocell.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows; cmbocell.AutoSearch = FarPoint.Win.AutoSearch.SingleCharacter; cmbocell.Editable = true; cmbocell.ListAlignment = FarPoint.Win.ListAlignment.Left; cmbocell.ListOffset = 20; cmbocell.ListWidth = 0; cmbocell.MaxDrop = 4; fpSpread1.Sheets[1].Cells[2,2].CellType = cmbocell;
Dim cmbocell As New FarPoint.Win.Spread.CellType.ComboBoxCellType() cmbocell.Items = (new String() {"January", "February", "March", "April", "May", "June"}) cmbocell.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows cmbocell.AutoSearch = FarPoint.Win.AutoSearch.SingleCharacter cmbocell.Editable = True cmbocell.ListAlignment = FarPoint.Win.ListAlignment.Left cmbocell.ListOffset = 20 cmbocell.ListWidth = 0 cmbocell.MaxDrop = 4 fpSpread1.Sheets(1).Cells(2,2).CellType = cmbocell