Re: [libreoffice-users] function aliases in calc

Hi Jason,

Jason Paul Joines schrieb:
> I'm using LibreOffice 3.4.3 on Kubuntu 11.04. Is there any way to create
> an alias to an existing function in Calc? I also use R regularly. When
> using Calc I'm continuously mistyping =mean() instead of =average() when
> trying to enter a formula for the mean. I would like to be able to
> create an alias so that I can type mean() and it will use the average()
> function.

It might be possible to write a macro for MEAN, but the effort is huge. 
To get a true alias you need to mimic the possibility to have up to 30 
optional parameters where each parameter can be a cell range. It is much 
easier to remember to use AVERAGE when you get a #NAME? error.

The effort is small in the code. But in that case you need to build your 
own LibreOffice or convince the community that such an alias is useful 
and has no side effects and find a developer.

Kind regards
Regina


--
For unsubscribe instructions e-mail to: users+help@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