https://productforums.google.com/forum/#!topic/docs/7rq-0UttZNw
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function updateMenu_(menu, items) { | |
| var menuIterator = makeIterator_(items); | |
| while (true) { | |
| menu.addItem(menuIterator.get().name, menuIterator.get().fn); | |
| if (menuIterator.next().done) break; | |
| }; | |
| } | |
| function getScriptFunctionsAsMenuItems_(context) { | |
| return Object.keys(context).filter(function (key) { return key.slice(-1) !== "_" && key !== "onOpen" && typeof this[key] === "function" }, context).map(function (item) { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function myFunction() { | |
| var value = SpreadsheetApp.openById("ABC").getSheets()[0].getRange("A1").getValue(); | |
| Logger.log("value: %s" , value ); | |
| Logger.log("value == '': %s" , value == "" ); | |
| Logger.log("value === '': %s" , value === "" ); | |
| Logger.log("value === undefined: %s", value === undefined); | |
| Logger.log("value === null: %s" , value === null ); | |
| Logger.log("!value: %s" , !value ); | |
| Logger.log("value === 0: %s" , value === 0 ); | |
| } |
To use find, you can connect the library Golyfils or use the Polyfill.
You can try this. Enter in the Spreadsheet in the range A:A a value from 1 to 16.
- git clone https://gist.github.com/da78186d21641d27bd824f02d8e331f4.git
- npm install
- gapps init YOUR_SCRIPT_ID
- npm start
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function СПИСОКЛИСТОВ(separator, exceptions) { | |
| var mutual = {}; | |
| mutual.exceptions = typeof exceptions === 'string' ? exceptions.split(',') : | |
| exceptions; | |
| mutual.res = []; | |
| var list = SpreadsheetApp.getActiveSpreadsheet().getSheets().reduce(function( | |
| p, c) { | |
| var name = c.getName(); |
It's a bad idea. But
- You have to allow pop-ups from https://docs.google.com
- Sample
- Copy sample
