运行Logger.log onEdit?正在尝试检查数据验证
问题描述:
我试图查看如果在数据验证设置为拒绝无效数据输入的单元格中输入了错误条目,onEdit是否会激活。我无法使用onEdit使其工作,因此将该函数修改为myonEdit并在工作表上设置了通知。我得到了同样的结果。运行Logger.log onEdit?正在尝试检查数据验证
我对此做了什么不对吗?
function myonEdit() {
var mycell = SpreadsheetApp.getActiveSpreadsheet().getActiveCell().getA1Notation()
Logger.log('The cell edited was ' & mycell)
}
执行纪录是:
[16-04-21 05:09:33:624 PDT] SpreadsheetApp.getActiveRange() [0 seconds]
[16-04-21 05:09:33:625 PDT] Range.getRow() [0 seconds]
[16-04-21 05:09:33:625 PDT] Range.getLastRow() [0 seconds]
[16-04-21 05:09:33:625 PDT] Range.getColumn() [0 seconds]
[16-04-21 05:09:33:625 PDT] Range.getLastColumn() [0 seconds]
[16-04-21 05:09:33:626 PDT] SpreadsheetApp.getActiveSpreadsheet() [0 seconds]
[16-04-21 05:09:33:714 PDT] Starting execution
[16-04-21 05:09:33:719 PDT] SpreadsheetApp.getActiveSpreadsheet() [0 seconds]
[16-04-21 05:09:33:720 PDT] Spreadsheet.getActiveCell() [0 seconds]
[16-04-21 05:09:33:720 PDT] Range.getA1Notation() [0 seconds]
[16-04-21 05:09:33:722 PDT] Logger.log([0.0, []]) [0 seconds]
[16-04-21 05:09:33:724 PDT] Execution succeeded [0.003 seconds total runtime]
但日志包含
[16-04-21 05:09:33:721 PDT] 0.0
我已正确地做到了这一点?记录器是否可以使用简单的触发器?一个onEdit事件是否会被错误地进入验证过的单元格激活?
非常感谢那个Max。记录器日志记录,我不需要担心数据验证干扰onEdit事件。干杯! – Glib