Hello,
I created an add-on to a Google spreadsheet and applied to Google Workspace Marketplace, but no matter how many times I communicate with them, the reviewer will reject me if I don't see the menu
Please refer to the following
Menu-Menu options not show after App is installed.Please configure
that the add-on correctly uses onInstall() and onOpen() to populate
its menu.The menu items populate when the add-on is first installed
and when a different file is opened.See Editor add-on authorization.
When I do the editor add-on deployment test in my environment, it works fine, so I don't know what the problem is
The code is as follows
必要I omit the contents of functions that I don't think are necessary
functionGlobalVar(userLocale){
if(userLocale===null)userLocale='ja';
US>return{
TITLE: (userLocale=='ja') ?'Copype': 'Copype', // Add-on Title
VERSION: '1.1.2', // Application Version
}
}
function onInstall(e){
onOpen(e);
}
function onOpen(e){
varmenu=SpreadsheetApp.getUi().createAddonMenu();
varuserLocale=Session.getActiveUserLocale(); // Language determination used by the user
if(userLocale!='ja')userLocale='en'; // English for non-Japanese
variableInfo = {
Item1: {func: 'display_sidebar', ja: 'Operation panel display', en: 'Show Sidebar'},
Item2: { func: 'dispVersion', ja: 'Version Information', en: 'about version'}
};
menu.addItem(itemInfo.Item1[userLocale], itemInfo.Item1.func)
.addSparator()
.addItem(itemInfo.Item2[userLocale],itemInfo.Item2.func);
menu.addToUi(); // Add Menu
}
function askEnabled() {
let userLocale=Session.getActiveUserLocale();
let title=GlobalVar(userLocale).TITLE;
let msg = userLocale === 'ja'? "Script is enabled\nPlease open the menu screen again and let me see the sidebar": "The script has been enabled.\nOpen the menu screen again to display the sidebar.";
letui=SpreadsheetApp.getUi();
ui.alert(title, msg, ui.ButtonSet.OK);
onOpen();
};
function display_sidebar(){
let userLocale=Session.getActiveUserLocale(); // Language determination used by the user
let SidebarHTML = HtmlService.createTemplateFromFile('sidebar');
SidebarHTML.LANGUAGE=userLocale;// Send language information to sidebar
let Sidebar=SidebarHTML.evaluate().setTitle(GlobalVar(userLocale).TITLE);
SpreadsheetApp.getUi().showSidebar(Sidebar);//View sidebar
}
function dispVersion() {
let userLocale=Session.getActiveUserLocale(); // Language determination used by the user
Browser.msgBox (GlobalVar(userLocale).TITLE+"Version", 'Version:' + GlobalVar(userLocale).VERSION, Browser.Buttons.OK);
}
function toolTask(TASK_ORDER) {
return toolTaskRun().start(TASK_ORDER);
}
function toolTaskRun() {
US>return{
SPRED: null,
SHEET: null,
JOB: null,
INFO: null,
TAG_NAME: '_copype_',
init:function(){
This.SPRED=SpreadsheetApp.getActiveSpreadsheet();
this.SHEET = this.SPRED.getActiveSheet();
},
start:function(TASK_ORDER){
},
copy: function() {
},
paste:function(TAISHO){
},
moveRows:function(){
},
moveColumns: function() {
},
zettai:function(MODE){
}
};
}
The manifesto is as follows
{
"timeZone": "Asia/Tokyo",
"exceptionLogging": "STACKDRIVER",
"runtimeVersion": "V8",
"dependencies": {
"libraries":[
{
"userSymbol": "SetNamedRange",
"version": "0",
"libraryId": "1M0tYhnFHYkxl0IXsDju8NWTvWHZWBY8H4-Z7eFOIKyi26p-Ymmtu7C7r",
"developmentMode"—true
}
]
},
"oauthScopes": [
"https://www.googleapis.com/auth/spreadsheets",
"https://www.googleapis.com/auth/script.container.ui",
"https://www.googleapis.com/auth/userinfo.email"
]
}
I've tried many things and applied for it, but I get the same rejection every time
If anyone knows, please let me know
Thank you for your cooperation
*This content is also being asked in English version of the main house
https://stackoverflow.com/questions/73397896/i-cannot-publish-editor-addon-on-google-workspace-marketplace-menu-options-not
I received a reply with the English version of stackoverflow
Resolved
https://stackoverflow.com/a/73406949/19766029
Japanese translation
The result seems to be that if you load your own library in development mode, the library will not be able to integrate well in a non-test environment.
Now it's settled
© 2024 OneMinuteCode. All rights reserved.