Re: [libreoffice-users] Re: Macro not active when the document start

2011/8/11 Johnny Rosenberg <gurus.knugum@gmail.com>:
> 2011/8/11 Andreas Säger <villeroy@t-online.de>:
> > Am 11.08.2011 10:30, Johnny Rosenberg wrote:
> > > The macro is used as a cell function right?
> > > In that case, where did you put the macro? It should be placed in My
> > > Macros, I think, so you need to move it there if it's not there
> > > already.
> >
> > Wrong. It has to be stored in library "Standard", either the document's one
> > or the global one. "Standard" is loaded automatically and a cell function
> > will be found immediately.
>
> Well, I have mine in My Macros/Standard but maybe that's not necessary.
>
> At the moment I have one cell function there and it works perfectly,
> but when I add another one, LibreOffice refuse to recognise it. What
> ever I do, the cell only displays ”#NAME?” no matter if I have it in
> the document's Standard library or in My Macros/Standard.
>
> Can someone give a step-by-step instruction how to create a simple
> cell function? Do I need to restart LibreOffice (did that too, but it
> didn't help)?
> I know I didn't create the thread, but still…

Strange… I fiddled with it a bit and suddenly it works, I don't have a clue why…

It also seems like it looks in the document's Standard library first,
because if I had them at both places the local one was executed.

I made a very simple one, this is the one in the document's standard library:
Function DoStuff As Long
        DoStuff=3
End Function

Here's the one in My Macros/Standard:
Function DoStuff As Long
        DoStuff=4
End Function


In a cell:
=DOSTUFF

The result was 3. When I removed the local one, the result was 4 after
a Ctrl+Shift+F9.

But still I don't have a clue why it works now and not a few minutes ago…


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