Can I add a "custom help function" to google spreadsheet? those. if I type = sum in a spreadsheet cell, I get the text with a floating tooltip, is there a way to do this using custom functions?
Documentation in Google script applications is created using the JSDoc http://en.wikipedia.org/wiki/JSDoc style (JavaDoc like) comments. as described here https://developers.google.com/apps-script/guide_libraries?hl=en#guidelines
it looks like they only work in the script editor. There is a way to add documentation so that it appears in a spreadsheet.
This feature was added in May 2014, and the previous Issue 2475 was closed.
the examples provided in the Google Documentation are fine, but you can do more with jsdoc information than they show.
For instance:
/** * Return the time that the referenced cell or range was last changed. * Initial use shows current time. * * @param {Sheet3!B32} reference Cell or range to monitor. * @returns The time the reference was last changed. * @customfunction */ function lastModified( reference ) { // Surprise - we don't actually care what has changed! return( new Date() ); }
I examined this in more detail and examples from my blog .
Seeing that there is no documentation on it, I would suggest that this functionality is impossible. Consider searching for an existing query for this in Tracker , and if not, make a feature request! I am sure that you are not the only one who would like to see this.
I sent a feature request for this. https://code.google.com/p/google-apps-script-issues/issues/detail?id=2475