Hi Eike,
Eike Rathke schrieb:
Hi Peter,
On Wed, Aug 17, 2005 at 14:36:28 +0200, Peter Eberlein wrote:
Type a three line function MyFunction() in any module of the Standard
library.
Open a calc document and type the function in a cell. You will get as
result the return of the function.
Now move the function to another (loaded) library and try again.
You can't specify the function call in the cell like
=MyLibrary.MyModul.MyFunction()
No, but you should still be able to call it as =MyFunction()
No, you will get in German "#WERT!" as result.
The normal behavior should be:
1. Search the function in the library of the document /works
2. Search the function in the standard library /works
3. Search the function in any other loaded user libraries /doesn't work
4. Search the function in any other loaded shared libraries /doesn't work
And btw, if you use such a document as template, the cells are not
updated automatically nor with GUI. Doc.CalculateAll() will do it.
Why should they be updated? With what? There is no dependency in form of
a cell reference passed as an argument that tells it to do so.
Because in a network installation a function =MyPhoneNumber() should
return the phonenumber of the user, who uses the template document, and
not the phonenumber of the owner of the template.
So you have to assign a macro to the document-event "OnCreate" to update
the data.
Regards
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]