可以参考下面的代码修改- sheet.bind(GC.Spread.Sheets.Events.EditEnding, function (sender, args) {
- if (args.editingText != null && args.editingText.indexOf('!') != -1 && args.editingText.indexOf('=') != -1) {
- setTimeout(function () {
- sheet.setFormula(args.row, args.col,undefined)
- sheet.setValue(args.row, args.col, null)
- },0)
- console.log(sheet.getValue(args.row, args.col)) // null
- console.log(sheet.getText(args.row, args.col)) //
- console.log(sheet.getFormula(args.row, args.col)) // null
- }
- })
复制代码
|