Hi Peter, you're right, there seems to be no way to call a macro that is not located in the Standard library, even if that library has been loaded. I could reproduce this behavior with src680_m121 . I propose you file a report at Issuezilla, thanks.
2005/8/19, Peter Eberlein <[EMAIL PROTECTED]>: > 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] > > -- Best Regards Christian Junker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
