Skip to content

Instantly share code, notes, and snippets.

@soundTricker
Last active April 25, 2018 05:01
Show Gist options
  • Save soundTricker/5309ebc893bcebaedc906a2b4d1369ab to your computer and use it in GitHub Desktop.
Save soundTricker/5309ebc893bcebaedc906a2b4d1369ab to your computer and use it in GitHub Desktop.
2018/04/25 gtug girls gas
function translate(val) {
if (val.map) {
return val.map(translate);
}
return LanguageApp.translate(val, "en", "ja");
}
function onOpen(e) {
var ui = SpreadsheetApp.getUi();
var mainMenu = ui.createMenu("カスタムメニュー")
.addItem("toast", "test")
.addToUi()
;
}
function test() {
SpreadsheetApp.getActive().toast("カスタムメニュー");
}
function onOpen(e) {
SpreadsheetApp.getActive().toast("シートの数: " + SpreadsheetApp.getActive().getSheets().length);
}
function onEdit(e) {
e.range.getSheet().getRange(e.range.getRow() + ":" + e.range.getRow()).setBackground("yellow");
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment