The libraries “Application Macros & Dialogs” contain a lot of useful macro functions. Is it possible to use such function directly in a Calc cell?
I know I can write a macro function, add it to the spreadsheet and use it in a cell, see e.g. Einzelne Namen aus String extrahieren - #8 by Regina.
Is there a way to use the ArrayOutOfString function used in the example directly, without writing an own macro?
Function MySplit(s, sep)
GlobalScope.BasicLibraries.loadLibrary("Tools")
MySplit = Tools.Strings.ArrayOutOfString(s, sep)
End Function
Edit: I see, you want to call ArrayOutOfString directly from the cell. No, this is impossible. Even if the library would be loaded automagically, the returned array is one-dimensional.
I can load the application library “Tools” (e.g) with
Sub onStartApplication(pEvent)
GlobalScope.BasicContainer.loadLibrary("Tools")
End Sub
placed in a module of my Standard library, and assigned to the proper event stored to application).
The function names are then recognized by the Calc formula parser, but even with functions returning ordinary values (Double, String) the respective cell always shows #VALUE! error.
If I remove the loadLibrary line from my onStartApplication then Calc does NOT recognize the function names (if not they are accessible in a different way like “POWER()”).
Have no clue.
Users working with ScrptForge macros may know how to get what we want.