javascript - 无法聚焦 onOpen 触发器中的单元格

Question

我在电子表格的脚本编辑器中编写了一个函数，该函数旨在关注包含当前日期的单元格。一般来说，当函数由菜单项触发时它会起作用，但加载电子表格后它不会聚焦在任何单元格上。

function onOpen() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var entries = [{
    name : "Go to Today",
    functionName : "goToToday" // goToToday() contains same code as last 3 lines of onOpen()
  }];
  spreadsheet.addMenu("Script", entries); // works on manual run and on startup

  var s = spreadsheet.getSheetByName("Sheet1");    
  var r = 25 + s.getRange("I4").getValue();
  s.setActiveSelection(s.getRange("A" + r )); // works on manual run, doesn't work on startup


};

Answer 1

根据 Bryan 的回答，我尝试了另一种可能的代码来自动关闭对话框。

我调用 UiApp 弹出窗口的方式有一些细微的变化。

function onOpen() {
  var s = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");    
  var ui = SpreadsheetApp.getUi(); 
  ui.createMenu('Goto today').addItem('go !','goToToday').addToUi();
  var app = UiApp.createApplication().setHeight(40).setWidth(180).setTitle('Start');
  var btn = app.createButton('Go to Today in cell A'+(25 + (s.getRange("I4").getValue())), app.createServerHandler("goToToday"))
  .setStyleAttributes({'fontFamily':'arial','fontSize':'10pt','fontWeight':'bold','color':'white','background':'#3870ff'}).setPixelSize(175,35);
  app.add(btn);
  SpreadsheetApp.getActive().show(app);
}


function goToToday() {
  var s = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");    
  var r = 25 + s.getRange("I4").getValue();
  s.setActiveSelection(s.getRange("A" + r ));
  return UiApp.getActiveApplication().close();
}