Linux VBA : access external so library tested with windows version

[gecos]

with reference to previous discussion

VBA, external C dll/so (shared library) not in memory

I have a simple C dll (shared library, multi-threaded) which stores (as static data) some value to share between methods mytestA, mytestB , this library works fine with Excel (Excel loads once the dll and doesn’t release it) while LibreOffice reloads / releases the dll every time I call a method in dll Public Declare Function mytestA Lib "test.dll" (ByVal a As Long) As Long Public Declare Function mytestB Lib "test.dll" (ByVal b As Long) As Long c = mytestA(a) d = mytestB(b) this means t…

do you know if recent versions of LibreOffice Ubuntu (linux) have the capability to call external so libraries ?
I wish to move VBA for Windows to Ubuntu / Linux, the original (Windows) VBA code includes

Private Declare Function LoadLibrary Lib “kernel32” alias “LoadLibraryA” (ByVal lpLibName As String) As Long
Global LibLoad As Long

Sub MyTest()

if LibLoad = 0 then
LoadLibrary(“mylib.dll”)
LibLoad = 1
endif

End Sub

Do you know an equivalent method working in Ubuntu / Linux to load mylib.so ?

Thank you very much for help.

[elmau]

What exactly does mylib.so do?

[gecos]

it’s an external application (in this case a shared library) which provides additional features (i.e. numerical solvers etc.) not available in LibreOffice…

[elmau]

I ask, because maybe you can call it from Python. LibreOffice has very good support for Python.

[gecos]

yes, that’s another option,
at present Excel (Office) has limited support for Python so I did hope to maintain my VBA which, on Windows, works on both Excel and LibreOffice

[mikekaganski]

@gecos

Do you know an equivalent method working in Ubuntu / Linux to load mylib.so ?

There is none. Basic’s DLL manager is only implemented on Windows currently. There is tdf#147377 which would allow to support it on any platform.

[gecos]

thank you for the comment,
I did fear VBA has limited support in Linux versions,
still I think scripts are one of the best features in LibreOffice and I hope a solution will be available…

[mikekaganski]

@gecos

I did fear VBA has limited support in Linux versions

In fact, we don’t have much difference of VBA support level between Windows and Linux. The Declare statement is not a VBA-related feature.

[gecos]

I agree, but Declare makes the process to load external plugins much less complex…