Re: [libreoffice-users] function aliases in calc

2011/11/5 Jason Paul Joines <jason@joines.org>:
>    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.

I would like to know that too. At least I know that this does NOT work:

Function MEAN(x As Variant) As Double
        Dim a As Object
        a=createUNOService("com.sun.star.sheet.FunctionAccess")
        x=a.callFunction("AVERAGE",x)
End Function

Unfortunately I don't have much of a clue what to do about it, except
converting x to an array of the exact type that the function needs,
whatever that is. Maybe someone who understand English much better
than me can figure it out from the documentation.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

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