Google Sheets not showing custom function in autocomplete -


i can't google sheets autocomplete show custom function when use google's version (see below). have jsdoc info correctly formatted, still doesn't show up. i'm sure i'm overlooking stupid, can't find it. missing?

google's demo code:

/**  * multiplies input value 2.  *  * @param {number} input value multiply.  * @customfunction  */ function double(input) {   return input * 2; } 

btw, i'm using chrome develop custom functions. also, function works, no autocomplete. built-in functions autocomplete works.

thanks in advance help!

brad

i managed custom function autocomplete working yesterday. seems work container-bound scripts, jsdoc info inside script being used library not come across. verify works, did following:

  • create new google sheet
  • open script editor
  • enter following in script:

    /**  * returns amount multiplied itself.  *  * @param {number} amount amount multiplied itself.  * @return {number} amount multiplied itself.  * @customfunction  */ function test(amount) {   return amount*amount; } 
  • then, when entering =test cell in spreadsheet, information above function appears in autocomplete hint, other built-in spreadsheet function.

Comments

Popular posts from this blog

c++ - How to add Crypto++ library to Qt project -

jQuery Mobile app not scrolling in Firefox -

How to use vim as editor in Matlab GUI -