Google Sheets Ad-On onOpen（）只运行一次，但onEdit（）很好

Question

我正在为工作表开发一个名为LastEdit的附加组件。我遇到的问题是onOpen（）仅在第一次安装加载项时运行：

• 代码可以很好地作为绑定脚本运行到我编写附加组件的原始工作表中；只有发布的附加组件（安装到不同的Google Drive帐户）才会出现问题。

那么，为什么onOpen（）不再运行？？

以下是代码，顺便说一句：

var documentProperties = PropertiesService.getDocumentProperties();
var ui = SpreadsheetApp.getUi();
var sheet = SpreadsheetApp.getActive();
var editCell;

// This function runs whenever cells are edited
function onEdit() {
  updateLastEdit();
}

// This function updates the editCell contents
function updateLastEdit() {
  // Fetch the coordinate of the designated LastEdit cell
  editCell = documentProperties.getProperty('editCell');
  // If our docProp editCell is 0 then we don't have a LastEdit to update
  if (editCell != 0.0) {
    sheet.getRange(editCell).setValue(new Date() + '');
  }
}

// This function will be used to designate the new LastEdit cell
function lastEdit() {
  editCell =  sheet.getActiveCell()
  SpreadsheetApp.getUi().alert("LastEdit cell added at: " + editCell.getA1Notation());
  documentProperties.setProperty('editCell', editCell.getA1Notation());
  // Once we've stashed the location of the LastEdit cell we move to update the LastEdit cell contents
  updateLastEdit();
}

// When the Sheet opens add a new custom menu
function onOpen(e) {

  // This is the alert for testing purposes
  ui.alert("onOpen() has run!");

  // Contingency strategy; set an Installable Trigger to perform the onOpen tasks
  //ScriptApp.newTrigger("openTrigger").forSpreadsheet(sheet).onOpen().create();

  // Creating custom menu for this app
  newMenu = ui.createAddonMenu();
  newMenu.addItem('Insert LastEdit Cell', 'insertLastEdit');
  newMenu.addItem('Disable LastEdit Cell', 'disableLastEdit');
  newMenu.addItem('LastEdit Cell Location', 'locateLastEdit');
  newMenu.addSeparator();
  newMenu.addItem('About', 'aboutLastEdit');
  newMenu.addToUi();
  // I know this can be shortened, but I removed/tested each individual
  // item to see if any of these were derailing onOpen()
}

// Insert LastEdit Cell
function insertLastEdit() {
  lastEdit();
}

// Disable LastEdit Cell
function disableLastEdit() {
  documentProperties.setProperty('editCell', 0);
  SpreadsheetApp.getUi().alert("LastEdit cell disabled");
}

// Fetch and display the LastEdit cell location via popup
function locateLastEdit() {
  editCell = documentProperties.getProperty('editCell');
  if (editCell != 0) {
    SpreadsheetApp.getUi().alert("LastEdit cell is located at: " + editCell);
  } else {
    SpreadsheetApp.getUi().alert("No LastEdit cell is active ");
  }
}

// About! 
function aboutLastEdit() {
  ui.alert("About LastEdit", SpreadsheetApp.getUi().ButtonSet.OK);
}

// After installation just run the onOpen function
function onInstall(e) {
  onOpen(e);
}

// If an Installable Trigger is required...
function openTrigger() {
    // I had a duplicate of onOpen() in here, but have abandoned this strategy
}

我错过了什么？加载项授权似乎有很多活动部分（绑定脚本、简单触发器、文档中启用、authMode.LIMITED vs.FULL等）。我查看了加载项授权生命周期页面，但它似乎指出此过程主要是自动处理的。

提前感谢您的帮助！

Answer 1

"如果为用户安装了加载项，但未在当前文档中启用，则onOpen（e）在AuthMode中运行。如果在当前文档中启用了加载项，则onOpen（e）在AuthMode中运行。有限公司。如果加载项已安装并启用，则启用状态优先，因为LIMITED允许访问更多应用脚本服务。"

当脚本处于AuthMode时。无它无权访问属性服务。由于您有调用此服务的全局代码，因此如果onOpen（）的执行失败，则加载项将失败。

您需要将此全局代码移动到函数中。

在这里看到更多https://developers.google.com/apps-script/add-ons/lifecycle#authorization_modes