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

Am 25.02.2015 um 17:14 schrieb Regina Henschel:
> Hi,
>
> hw schrieb:
> > 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.
>
> In addition to the suggestions by Andreas, in the Basic Organizer, you
> can export a macro library to an extension (file name .oxt). When you
> then install this extension "for all users" the library goes to
> <installation directory>/share/uno_packages/... and with the next start
> of LibreOffice another user will find it in its UI in "LibreOffice
> Macros&Dialogs".
>
> But although this works in general, it will not work for Basic
> functions, which are written to be used in Calc formulas, see
> https://bz.apache.org/ooo/show_bug.cgi?id=53615 and likely the same root
> cause in https://bugs.documentfoundation.org/show_bug.cgi?id=79588.

Thank you very much!  This is good to know, though currently, it is 
actually a macro written in BASIC.  It provides some functions to be 
used with spreadsheets.

BTW, is there a macro readily available somewhere to genearate EAN-13 
codes for spreadsheets?  I got something for perl which I could 
translate, and it might save time if there's already a function for 
spreadsheets.

--
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