关于自定义单元格的问题

收藏

本帖最后由 Joky 于 2016-4-26 18:01 编辑

我想实现在模板中设置单元格点击事件，点击时弹出窗口进行操作，将值填充回点击的单元格，要怎么实现？

Lenka.Guo · Lenka.Guo

您好：
实现思路，
1. 为Spread 单元格绑定CellCliked 事件;
activeSheet.bind(GcSpread.Sheets.Events.CellClick, function (sender, args){}

2. 获取返回的数据，绑定到对应的单元格，如
var person = {name: "Wang feng", age: 25, address: {postcode: "710075"}};
var source = new GcSpread.Sheets.CellBindingSource(person);
activeSheet.setBindingPath(0, 0, "name");
activeSheet.setBindingPath(1, 1, "age");
activeSheet.setBindingPath(3, 3, "address.postcode");
activeSheet.setDataSource(source);

Joky · Joky

Lenka.Guo 发表于 2016-4-25 11:41
您好：
实现思路，
1. 为Spread 单元格绑定CellCliked 事件;

模板里怎么给指定的单元格绑定事件？在保存的模板中的json中是以什么格式保存点击事件的？

dexteryao · dexteryao

本帖最后由 dexteryao 于 2016-4-26 11:21 编辑

你在fromJSON后加事件就好了

spread.fromJSON(data);
var activeSheet = spread.getActiveSheet();
activeSheet.bind(GcSpread.Sheets.Events.CellClick, function (sender, args){
//... your code
});
绑定事件后可以获取到单元格行号，列号，然后处理就好了

activeSheet.bind(GcSpread.Sheets.Events.CellClick, function (sender, args) {
if(args.sheetArea === GcSpread.Sheets.SheetArea.colHeader){
console.log("The column header was clicked.");
}
if(args.sheetArea === GcSpread.Sheets.SheetArea.rowHeader){
console.log("The row header was clicked.");
}
if(args.sheetArea === GcSpread.Sheets.SheetArea.corner){
console.log("The corner header was clicked.");
}
console.log("Clicked column index: " + args.col);
console.log("Clicked row index: " + args.row);
});
activeSheet.bind(GcSpread.Sheets.Events.CellDoubleClick, function (sender, args) {
if(args.sheetArea === GcSpread.Sheets.SheetArea.colHeader){
console.log("The column header was double clicked.");
}
if(args.sheetArea === GcSpread.Sheets.SheetArea.rowHeader){
console.log("The row header was double clicked.");
}
if(args.sheetArea === GcSpread.Sheets.SheetArea.corner){
console.log("The corner header was double clicked.");
}
console.log("Double clicked column index: " + args.col);
console.log("Double clicked row index: " + args.row);
});

复制代码

Joky · Joky

dexteryao 发表于 2016-4-26 11:09
你在fromJSON后加事件就好了

spread.fromJSON(data);

好的，我再研究一下，非常感谢

dexteryao · dexteryao

不客气，弹出框关闭时候setValue就好了

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

[已处理] 关于自定义单元格的问题

5 个回复

活字格认证

讲师达人

悬赏达人

微信认证勋章

元老葡萄

SpreadJS 认证

SpreadJS 高级认证