ComboBoxCellType的疑问

home5p · home5p

这是我的js写法：

function FPD1_DataChanged(fp_obj) {
var act_row = fp_obj.ActiveRow;
var act_col = fp_obj.ActiveCol;

//16为隐藏栏位
if (fp_obj.GetValue(act_row, 16) != 'A') {
fp_obj.SetValue(act_row, 16, "U", true);
}

//FP1_COL_OUTFLG 为一个ComboBoxCellType
if (act_col == FP1_COL_OUTFLG) { fp_obj.SetValue(act_row, 16, "U", true); }
fp_obj.UpdatePostbackData();
fp_obj.CallBack("Update");
}

iceman · iceman

你好，不好意思，这么久才回复，可以对 ComboBoxCellType 设置为 true 的类型添加以下代码，让事件先走前台代码：

FarPoint.Web.Spread.ComboBoxCellType c1 = new FarPoint.Web.Spread.ComboBoxCellType();
//FPD1_DataChanged 前台 JS 赋值函数
c1.OnClientChanged = "FPD1_DataChanged()";

复制代码

wangleiecho · wangleiecho

winform的能实现此功能吗？

iceman · iceman

wangleiecho 你好，可以通过以下方式实现

private void Form1_Load(object sender, EventArgs e)
{
FarPoint.Win.Spread.CellType.ComboBoxCellType comboBoxCellType1 = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
comboBoxCellType1.Items = (new String[] { "1", "2", });
fpSpread1.Sheets[0].Cells[2, 1].CellType = comboBoxCellType1;
comboBoxCellType1.EditorValueChanged += new EventHandler(comboBoxCellType1_EditorValueChanged);
FarPoint.Win.Spread.CellType.ComboBoxCellType comboBoxCellType2 = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
comboBoxCellType2.Items = (new String[] { "1", "2", });
fpSpread1.Sheets[0].Cells[2, 2].CellType = comboBoxCellType2;
}
void comboBoxCellType1_EditorValueChanged(object sender, EventArgs e)
{
FarPoint.Win.Spread.CellType.ComboBoxCellType test = sender as FarPoint.Win.Spread.CellType.ComboBoxCellType;
if (this.fpSpread1.Sheets[0].Cells[2,1].Text=="1")
{
this.fpSpread1.Sheets[0].Cells[2, 2].Locked = true;
}
if (this.fpSpread1.Sheets[0].Cells[2, 1].Text == "2")
{
this.fpSpread1.Sheets[0].Cells[2, 2].Locked = false;
}
}

复制代码

wangleiecho · wangleiecho

哦明白了多谢版主

iceman · iceman

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

[已处理] ComboBoxCellType的疑问

回复 11# home5p 的帖子

回复 13# wangleiecho 的帖子

回复 15# wangleiecho 的帖子

活字格认证

微信认证勋章

元老葡萄