From: Vieri <firstname.lastname@example.org>
Sent: Friday, 14 June 2013, 8:02
Subject: Re: [libreoffice-users] create custom macro within share location (program files)
The link that Tom refers to lead me to several documents of which only one deals with what I want
to do (which is install a macro that is global to openoffice/libreoffice). That would be
location=share and on Windows the path would be %PROGRAMFILES%\libreoffice 4.0\share\basic\.
From the LO/OO GUI I can't create any NEW macros within the "global container" (grayed out). And
I haven't found any option to enable it. So there's obviously some kind of security reason that I
don't know how to circumvent.
The only document within Tom's links that should do what I want is the following:
"To Make a Custom OpenOffice.org Basic Library Available to All Users on a Network"
The basic idea of this guide is to create my macros within my "user profile folder" and then copy
them to the "global share folder". However, note how the guide suggests to include in script.xlc
and dialog.xlc: the library xlink:href should point to $(USER)/basic...etc.
I find that wrong (or not what I want).
I understand that $(USER) points to the user profile folder where I first wrote my macros. It
doesn't point to the "global share folder". So maybe it does make the macros available in OO/LO on
that PC as "global macros" BUT it is required to keep a copy of the macros in the $USER dir. Am I
What I would like to do (or at least that's what I feel should be done) is not to COPY the macros
from a user dir to the global share dir but to MOVE them. So if I do that then the library
xlink:href in script.xlc and dialog.xlc should point to something like
"$(INST)/share/basic/MyLibraryName/script.xlb/". Doing so doesn't make LO or OO complain BUT I
don't see my library listed in the "gloabl macros tree mode". So I can't run my macros in the
As I stated in another e-mail on this list, I managed to actually install my custom BASIC macros
within the "global share" by creating my own extension .oxt file. So I'd be happy with that except
for the fact that I can't also bundle my JAVA macros in my extension oxt file. So I'm stuck in the
middle: I can install my Java macros by copying them over to the global share (and they work!) but
I can0t do the same with Basic macros; and on the other hand I can deploy my Basic macros with a
custom extension but not my Java macros. I can combine both methods to do what I need (ie.
"install custom Basic and Java macros in the global share") but that doesn't sound "clean" or
Any more ideas?
--- On Thu, 6/13/13, Andrew Douglas Pitonyak <email@example.com> wrote:
Openoffice stores individual macros
in modules. Modules are stored in libraries, and libraries
are stored in macro containers.
Three "things" can be macro containers, documents, your user
space, and one that is global to OpenOffice. It sounds like
you desire to add a macro that is global to OpenOffice. I
have never done this.... It is not enabled on my Linux
system, is it available to you to do from the GUI when you
are logged in as an administrator?
I expect that the Link from Tom Davis is the best you can
find, since I don't see an ability to set the Macro location
directories in the configuration.
On 06/12/2013 02:26 AM, Vieri wrote:
This is probably trivial but I'm not capable of
correctly creating new custom macros within
%PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7).
My goal is to setup some custom macros globally for all
users (location=share). I don't want to include the macros
within location=document because I'll be deploying lots of
docs and it would be a pain to maintain/update macros within
every single odt document. I'd also like to avoid
location=user (or location=application - I don't remember
which is which) because I have PCs that are being used by
lots of users and copying/syncing "user macros" to each user
profile on every machine would be a waste of space and
That's why I was hoping to install and update all my
macros within the main LO application.
Another even better way would be to tell the LO
application that my custom macros can be found on a remote
server, eg. something like "location=url". This way, I'd
maintain my macros on my web/ftp/webdav/whatever server
(just one single copy) and forget about syncing them with
each and every LO client installation.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy