双击spread 某列单格，将该单元格的类型转换成下拉列表框

wangwuliSpread · wangwuliSpread

ComboBoxCellType 选中事件应该这么写?

iceman · iceman

回复 11楼wangwuliSpread的帖子

后台代码如下：

protected void FpSpread1_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
int _row = e.SheetView.ActiveRow;
int _col = e.SheetView.ActiveColumn;
if (this.FpSpread1.ActiveSheetView.Cells[_row,_col].CellType is ComboBoxCellType)
{
}
else
{
FarPoint.Web.Spread.ComboBoxCellType cmbocell2 = new FarPoint.Web.Spread.ComboBoxCellType();
cmbocell2.Items = (new String[] { "综合部", "销售部", "服务部", "产品部", "运维" });
cmbocell2.AutoPostBack = true;
FpSpread1.ActiveSheetView.Cells[_row, _col].CellType = cmbocell2;
this.FpSpread1.ActiveSheetView.Cells[_row, _col].Text = DateTime.Now.Year.ToString();
cmbocell2.ShowButton = true;
this.FpSpread1.SaveChanges();
}
}

复制代码

wangwuliSpread · wangwuliSpread

回复 12楼iceman的帖子

  if (this.FpSpread1.ActiveSheetView.Cells[_row,_col].CellType is ComboBoxCellType)
            {

            }
            else
            {
                  FarPoint.Web.Spread.ComboBoxCellType cmbocell2 = new FarPoint.Web.Spread.ComboBoxCellType();
                  cmbocell2.Items = (new String[] { "综合部", "销售部", "服务部", "产品部", "运维" });
                  cmbocell2.AutoPostBack = true;
                  FpSpread1.ActiveSheetView.Cells[_row, _col].CellType = cmbocell2;
                  this.FpSpread1.ActiveSheetView.Cells[_row, _col].Text = DateTime.Now.Year.ToString();
                  cmbocell2.ShowButton = true;
                  this.FpSpread1.SaveChanges();
            }
      }
这个选中事件没有效果啊

iceman · iceman

回复 13楼wangwuliSpread的帖子

请问你的测试步骤是什么？附件是我的测试工程。

14596_checkbox.zip (29.61 KB, 下载次数: 318)

		自动登录	找回密码
密码			立即注册

[已处理] 双击spread 某列单格，将该单元格的类型转换成下拉列表框

活字格认证

微信认证勋章

元老葡萄