单元格设置成ComboxCellType，显示值

单元格设置成ComboxCellType，显示值要是下拉集合里面的值

回复 1楼叹息的帖子

抱歉，我没有太理解您的意思   。

设置ComboBoxCellType类型：

1.                
   
2. ComboBoxCellType cmb = new ComboBoxCellType();
   
3. this.FpSpread1.ActiveSheetView.Cells[2, 3].CellType = cmb;
   
4. cmb.Items = new string[] { "a","b","c"};
   
5. cmb.Values = new string[] { "1", "2", "3" };
   
6. cmb.ShowButton = true;
   
7. cmb.UseValue = true;
   

复制代码

使用选择的数据：

1. 
   
2. object o = this.FpSpread1.ActiveSheetView.GetValue(2, 3);
   
3. o = this.FpSpread1.ActiveSheetView.GetText(2, 3);
   
4. o = this.FpSpread1.ActiveSheetView.Cells[2, 3].Text;
   
5. o = this.FpSpread1.ActiveSheetView.Cells[2, 3].Value;
   

复制代码