spread 怎样用前台js实现用鼠标单击单元格单元格改变

收藏

就是鼠标单击一个单元格，单元格变为ComoboxCellType下拉框，双击单元格就变为TextCellType类型
怎样使用前台的js方法实现？？

iceman · iceman

wjj_123 你好，设置方法如下：

protected override void Render(HtmlTextWriter writer)
{
Table spreadTable = this.FpSpread1.FindControl("viewport") as Table;
spreadTable.Attributes.Add("onclick", ClientScript.GetPostBackEventReference(FpSpread1, "click,-1,-1") + "; return false;");
spreadTable.Attributes.Add("ondblclick", ClientScript.GetPostBackEventReference(FpSpread1, "doubleclick,-1,-1") + "; return false;");
base.Render(writer);
}
protected void FpSpread1_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
int activerow=this.FpSpread1.Sheets[0].ActiveRow;
int activecol=this.FpSpread1.Sheets[0].ActiveColumn;
if (e.CommandName=="click")
{
FarPoint.Web.Spread.ComboBoxCellType comboCellType = new FarPoint.Web.Spread.ComboBoxCellType();
comboCellType.ShowButton = true;
this.FpSpread1.Sheets[0].Cells[activerow, activecol].CellType = comboCellType;
}
if (e.CommandName=="doubleclick")
{
FarPoint.Web.Spread.TextCellType textCellType = new FarPoint.Web.Spread.TextCellType();
textCellType.ShowEditor = true;
this.FpSpread1.Sheets[0].Cells[activerow, activecol].CellType = textCellType;
}
}

复制代码

wjj_123 · wjj_123

没效果啊,请指教！！

wjj_123 · wjj_123

怎样在前台用js实现此效果，在Button_Command里随便点一下鼠标页面就回发一次

iceman · iceman

楼主请确认是否添加 Spread 后台 ButtonCommand 事件？

wjj_123 · wjj_123

添加了Button_Command事件，但是我的鼠标随便点一下页面就刷新即使不对着单元格
我想问在前台用js能通过单击或双击某一单元格改变单元格类型吗?
请赐教！！！！

iceman · iceman

楼主可以在前台抓取相应的节点，
在节点的 onclick 事件中添加

复制代码

在节点的 ondblclick 事件中添加

复制代码

后台代码:

protected void FpSpread1_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
int activerow=this.FpSpread1.Sheets[0].ActiveRow;
int activecol=this.FpSpread1.Sheets[0].ActiveColumn;
if (e.CommandName=="click")
{
FarPoint.Web.Spread.ComboBoxCellType comboCellType = new FarPoint.Web.Spread.ComboBoxCellType();
comboCellType.ShowButton = true;
this.FpSpread1.Sheets[0].Cells[activerow, activecol].CellType = comboCellType;
}
if (e.CommandName=="doubleclick")
{
FarPoint.Web.Spread.TextCellType textCellType = new FarPoint.Web.Spread.TextCellType();
textCellType.ShowEditor = true;
this.FpSpread1.Sheets[0].Cells[activerow, activecol].CellType = textCellType;
}
}

复制代码

wjj_123 · wjj_123

怎样取得节点啊,我不懂！！，拜托赐教!!!!!再具体点!!!

iceman · iceman

楼主你好，假设 testDiv 为目标节点 ID ，设置方法如下：

复制代码

wjj_123 · wjj_123

运行js报错说无法获取attachEvent的值怎么回事???

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

[已处理] spread 怎样用前台js实现用鼠标单击单元格单元格改变