Ask Your Question

MAC OS - How to open Base reports based on queries in standalone

asked 2018-07-21 22:22:28 +0100

VHM gravatar image

updated 2018-07-26 21:20:08 +0100

Hello everybody!

I am using a MAC OS X 10.11.6 and LibreOffice version

I am was reading this link text. I run the macro and start to fill the dropdown fields, but the desktop field is always blank. So I need to select some file to add in that field. (I choose any LibreOffice file in this situation)

After pushing the Create Shortcut button, the shortcut creates an invisible file, and when I tried to open it, it only opens as a note. It is not open the real file.

I appreciate any help. Thank you,


I am editing to better explain the issue.

I am referring to @koolninja comments. I downloaded the DB shortcuts and ran the macro. As you can see, shortcut location is blank, and the only way to include a path is selecting an existing file. So, using an existing file on this, after pushing Create Shortcut button, the file created not work.


edit retag flag offensive close merge delete



This needs more information. It appears you are using the macro by @Kridtbandit. Have you modified it as stated in the comments? Also there is nothing mentioned anywhere in that post related to drop downs. What is this drop down stuff all about? Please be as specific as possible.

Ratslinger gravatar imageRatslinger ( 2018-07-21 22:33:05 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-07-26 23:38:24 +0100

Ratslinger gravatar image


You need to be a bit more careful on your references. The comments were NOT made by @koolninja but rather by myself. Also the download file (extension is more precise) was DB Doc Shortcut. by Roberto Benitez.

Unfortunately, the referred to post was mode almost two years ago and things don't seem to work the same. The original test was done on a Linux Xubuntu install with an older LO than currently used. Have no idea even at that time if it worked on Mac. Just tried on Mint 18.3 with LO v6.0.5.2 and was able to have the dialog produce the appropriate command but creating the Bash file was a failure - it was blank. Using the created command and generating my own file it worked. However trying to connect to the standalone document was another problem.

I have tried (recently on Mint 18.3) & successfully used the macro on the mentioned post under the answer by @Kridtbandit and had no problem (again look at my comments there as there are a couple of lines to be deleted). This is a much better solution at this point and you should try it.

edit flag offensive delete link more


Thank you, and I apologize for the wrong citation.

VHM gravatar imageVHM ( 2018-07-26 23:45:23 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-21 22:22:28 +0100

Seen: 42 times

Last updated: Jul 26 '18