[libreoffice-users] Re: making self-defined functions available for all spreadsheets

Am 21.02.2015 um 19:17 schrieb hw:
> Hi,
>
> 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.

Hi,
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
any time.
2a) Since it is possible to call macro code from different languages,
you can write or re-use functions written in Java, Python or JavaScript
and write a Basic wrapper. The spreadsheet calls the Basic function
which itself calls the other script.

HTH


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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