reliably determine the location of soffice.exe

2015-03-15 Thread Jörg Schmidt
Hello, The following code returns the directory where soffice.exe is: Sub Benutzerverzeichnis() aService = CreateUnoService(com.sun.star.util.PathSubstitution) sUserPath = ConvertFromURL(aService.substituteVariables($(prog), true)) InputBox (Ihr aktuelles OpenOffice.org-Benutzerverzeichnis

Re: OpenOffice Calc Javascript Function

2015-03-15 Thread Igal @ Lucee.org
it works. thank you Bernard! one last question -- how do I get the libraries to refresh? when I make a change to the libraries, sometimes it's visible immediately, and some times I need to close OpenOffice and re-open it in order to make sure that the new code is running. is there a better way

Re: OpenOffice Calc Javascript Function

2015-03-15 Thread Bernard Marcelly
Igal @ Lucee.org a écrit le 2015-03-15 20:41 : it works. thank you Bernard! one last question -- how do I get the libraries to refresh? when I make a change to the libraries, sometimes it's visible immediately, and some times I need to close OpenOffice and re-open it in order to make sure

Re: OpenOffice Calc Javascript Function

2015-03-15 Thread Igal @ Lucee.org
got it, thanks. it's possible that I had tried to use Ctrl-S instead of Ctrl-N. I am trying to call one function from another, but I guess I need to import it somehow first? I have that same JSLib1 module in the user location, and in it two functions: StringContains(input, substring,