Apache OpenOffice Community Forum

Posted: **Fri Feb 03, 2017 5:15 pm**

I'm attempting to call functions in an external DLL from a button handler in scalc, but LibreOffice crashes at the end of the handler.
I'm not certain what I'm doing incorrectly. The external function calls "succeed" (has the desired effect, returns data, etc.), but at the end of the handler, LO crashes.

Here's the BASIC macro I have.

Code: Select all

Declare Function _myfunc Lib "path\to\my.dll" Alias "myfunc" (ByVal inst as Integer) as Integer
Function myFunc(ByVal x as Integer) as Integer
    Dim rc as Integer
    rc = _myfunc(x)
    myFunc = rc
End Function

Sub ButtonHandler(oEvent)
    Print myFunc(0)
    FreeLibrary "path\to\my.dll"
End Sub

Am I doing this the proper way? Do I need to FreeLibrary at the end? It crashes with or without it. I tried putting it inside the function making the external call, without meaningful effect. Is there some other setup/teardown I need to do, in general? Are there limitations on event handlers?
Thanks.

Posted: **Fri Feb 03, 2017 5:43 pm**

Are not LibreOffice/OpenOffice BASIC variables case insensitive?

Posted: **Fri Feb 03, 2017 5:45 pm**

Probably.
Why would that matter? Am I using two variables with the same (insensitive) name?

Posted: **Sat Feb 04, 2017 12:58 am**

Try in an otherwise empty module

Declare Function _myfunc Lib "path\to\my.dll" Alias "myfunc" (ByVal inst as Integer) as Integer

Sub test()
dim a as integer,b as integer
a= _myfunc(b)
End Sub

Make things the simplest possible and try...

Posted: **Sat Feb 04, 2017 9:19 am**

Or upload please the project (the ODF file with the macro code, and the DLL file. Then we will able to try it and (maybe) to fix the bug.

Posted: **Tue Feb 07, 2017 7:33 pm**

It's possible that there's a stack problem. Is there a way to specify the calling convention to be used? I'm having trouble finding documentation for this kind of thing.

Posted: **Tue Feb 07, 2017 9:05 pm**

OpenOffice on Windows is a 32-bit application.
LibreOffice is availlable in 64 bit.

Posted: **Thu Feb 09, 2017 8:39 pm**

I'm using all 32-bit stuff. The DLL is a 32-bit binary, and I'm using a 32-bit version of LibreOffice.

Posted: **Sat Apr 15, 2017 6:24 pm**

... this works on my Windows 10 (writes a '9'). You may want to try if this also crashes in your handler. Then you can be pretty sure that it is an AO problem

Code: Select all

Declare function keybd_event Lib "user32.dll" ( ByVal bVk As Long, ByVal bScan As Long, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)

sub main
  call keybd_event(57, 0, 0, 0)
end sub

Apache OpenOffice Community Forum

Call DLL Function (from Event Handler) Crashes?

Call DLL Function (from Event Handler) Crashes?

Re: Call DLL Function (from Event Handler) Crashes?

Re: Call DLL Function (from Event Handler) Crashes?

Re: Call DLL Function (from Event Handler) Crashes?

Re: Call DLL Function (from Event Handler) Crashes?

Re: Call DLL Function (from Event Handler) Crashes?

Re: Call DLL Function (from Event Handler) Crashes?

Re: Call DLL Function (from Event Handler) Crashes?

Re: Call DLL Function (from Event Handler) Crashes?