感谢您指出的问题,这边检查了下代码,确实有需优化的地方。
将代码修改如下即可:
- spread.bind(GC.Spread.Sheets.Events.ButtonClicked, function (e, args) {
- var sheet = args.sheet, row = args.row, col = args.col;
- var cellType = sheet.getCellType(row, col);
- if (cellType instanceof GC.Spread.Sheets.CellTypes.Button) {
- if(row == 1 || col == 2) {
- // 添加数据
- var table2 = sheet.tables.all()[0];
- sheet.tables.resize(table, table2.range().rowCount+1, 3);
- datasource.getSource().source[datasource.getSource().source.length-1] = {myname: '11', myvalue: '11', mybutton: ''}
- sheet.repaint();
- } else if(col == 3) {
- sheet.deleteRows(row, 1);
- }
- }
- });
复制代码 完整代码请见附件
|
|