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+unsubscr...@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