So, how to start?
In menu ‘Tools’ select ‘Add library’.
The library is already added. You can add as many libraries as you want to the spreadsheet, but please bear in mind that every new file takes some memory resources and you can end up with a very slow working spreadsheet, therefore use it with caution.
The next step is to create a custom function (if you don’t know how to do it – read it here). The body of a function can look like this:
var a = library_namespace.function1(argument1, argument2, ...); //function1 returns a string or number return a;
And that’s it. More advanced and real-life examples will be added on a regular basis. Stay with us!