Am 21.02.2015 um 21:02 schrieb Andreas Säger:
Am 21.02.2015 um 19:17 schrieb hw:
how can I make a self-written function (i. e. a macro) available for all
spreadsheets so that I can use this function for any spreadsheet I
create or load and modify?
Ideally, this should work with multiple users in that I'd like to deploy
the macro(s) somewhere central for others to use.
You have two choices:
1) Write an add-in package which is installable via the extension
manager. These functoons can have their own localized help pages and
function names. They appear in the function wizard just like a built-in
function. You can not write add-ins Basic code.
2) Quick and drity Basic functions without any integration can be stored
in the "Standard" library of the global macro name space ("My Macros").
This library is loaded automatically so the functions can be found at
2a) Since it is possible to call macro code from different languages,
and write a Basic wrapper. The spreadsheet calls the Basic function
which itself calls the other script.
Thank you very much! For now, I'll just put the macro into the
"Standard" library --- I tried it and it works.
Would it be possible to have one file this "Standard" library is saved
in for multiple users, or would that give problems with several users
accessing the same file? Perhaps I could put it on a network share and
allow only read-only access to it.
To unsubscribe e-mail to: email@example.com
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