User Help Web Apps

Custom Functions not working for Google Sheets Addon

I created a GSuite Editor Addon project in Clasp and Typescript. I can test my code via the Script Editor->Execute->Test as Addon and select a Sheet. That works and the addon menu that I defined in the onOpen function appears.

However, all the Custom Functions that I defined in the project are not available from the Spreadsheet. For example, when I type in =double(2), I simply get an unknown function error. But, when I copy the Custom Function to the Spreadsheets’ local scripts (Tools->Scrip editor), it works just fine.

Is there any issue with Custom Functions inside addons?

Leave a Reply

Your email address will not be published. Required fields are marked *