Open Office Calc DLLs not found. Impossible to run executable

[aRCo]

Hello the forum,

i'm having a problem in executing an EXE: the Open Office Calc DLLs called inside the main VI are not found. No problem at all to run the VI in the LabVIEW development environment. 

The main VI simply opens and closes a spreadsheet document using Open Office Calc (download available here). Attached the source code.

Any help is welcome!

Marco

[wiebe@CARYA]

My guess would be that the dlls are not included in the build. Make sure the dlls are either in the system path or in a (sub)directory of the executable. Or add the paths to the executable's search path (in it's ini file).

[aRCo]

Hello, I already did this kind of test without success.

Please find attached the updated project with all you mentioned above.

[aRCo]

Hello, is there anybody out there?!

UP

[wiebe@CARYA]

---

@aRCo wrote:

Hello, is there anybody out there?!

---

Sure, but the answer is still more or less:

---

wiebe@CARYA wrote:

My guess would be that the dlls are not included in the build. Make sure the dlls are either in the system path or in a (sub)directory of the executable. Or add the paths to the executable's search path (in it's ini file).

---

Note that we cannot run your source code. The dlls won't load. That is because those dlls have dependencies, and they are not included in the source code. They are also not included in your executable...

You'd need to find and include those dependencies. 

[aRCo]

Thanks, but sorry, I cannot figure out the way to include these dependencies.

I had already specify in the build to always include these DLLs (AlwaysInclude.png), I moved the dependencies inside the project (ProjectRoot.png) and I added a path in the INI file coming with the EXE. Nothing solved the problem.

viSearchPath="C:\Users\...\Desktop\OpenOfficeCalcExample\Builds\Main Application\data\*"

Could you please be more precise and give practical examples?

[wiebe@CARYA]

I think there simply are more dependancies then those dlls. Those dlls seem to need other dlls.

I'm still not sure if you try the executable on another system, or the same system as the development system? That would make a huge difference.

Perhaps something like this: https://www.workshell.co.uk/products/netdepends/ helps you find the other dependancies.

[aRCo]

Thanks for the suggestion.

I downloaded the program, searched for listed dependencies on my PC, copied them inside the Source folder of the project and Always Included all these dependencies in the build. Even if I can see them inside the data folder, the EXE doesn't run. Find attached the whole project.

Concerning your question, I'm testing the EXE on the same PC on which I develop and on which the Main.vi runs fine. Clearly, the PC has OpenOffice installed...

Really don't know what to do...

[aptivo]

Is it necessary to use open office? There are a few tools available which can write in XLSX files on a low level without the need of having Excel or OpenOffice installed.

E.g. EPPlus which is a .NET based

[aRCo]

We deploy Open Office on the test benches not only to open xlsx, but also to treat data inside them, to plot graphs and also to open TDMS using the NI supplied plugin and so on... 

What is annoying is that the code works well but there's no way to understand why the EXE doesn't!