2011/8/11 Johnny Rosenberg <[email protected]>:
> 2011/8/11 Andreas Säger <[email protected]>:
>> 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: [email protected]
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
