apps-script-samples
apps-script-samples copied to clipboard
Sample manifest for Custom Functions on Sheets
Expected Behavior
From the documentation, it appears that a sheets add-on with custom functions can be deployed as a workspace add-on. A sample manifest file (appsscript.json) to do so would be super helpful.
Description: The current examples of manifests available in manifest documentation don't mention custom functions.
Actual Behavior
Under test deployment, custom functions are not recognized (while menu and side panel work). It would be a nice to have a sample manifest using which custom functions on sheets will be recognized when deployed.
I have the same issue. Custom functions defined in .gs files do not work in sheets as is. There must be something to specify in the manifest but I cannot find anywhere in the documentation what it is.
@sqrrrl Would be great to include a sample manifest or at least specify something in the README.
@rickygarg did you find what to specify in the manifest?