使用 onSelectionChange 时我做错了什么 [英] What am I doing wrong when using onSelectionChange
问题描述
我在开发者身上发现了这个触发器onSelectionChange(e).google.com 如果选择了单个空单元格,它应该将背景设置为红色.我只是复制和粘贴没有得到那个结果.我认为我没有遗漏任何一步,我们将不胜感激.
I found this trigger onSelectionChange(e) on developers.google.com it should set background to red if a single empty cell is selected. I'm not getting that result with just copy and paste. I don't think I'm missing a step any help would be appreciated.
/**
* The event handler triggered when the selection changes in the spreadsheet.
* @param {Event} e The onSelectionChange event.
*/
function onSelectionChange(e) {
// Set background to red if a single empty cell is selected.
var range = e.range;
if(range.getNumRows() === 1
&& range.getNumColumns() === 1
&& range.getCell(1, 1).getValue() === "") {
range.setBackground("red");
}
}
推荐答案
更新:
它似乎已全面向所有用户推出.您应该能够在不修改代码的情况下使其工作.e
事件对象类似于 onEdit
事件对象.
It seems it is fully rolled out to all users. You should be able to get it working without any modification to the code. The e
, event object is similar to the onEdit
event object.
onSelectionChange
是最近推出的功能.考虑等待几天将该功能推出到您的特定项目和电子表格.
onSelectionChange
is a recently rolled out feature. Consider waiting a few days for the feature to be rolled out to your specific project and spreadsheet.
这篇关于使用 onSelectionChange 时我做错了什么的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!