To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43544
------- Additional comments from [EMAIL PROTECTED] Fri Oct 24 20:12:11 +0000 2008 ------- I found a strange workaround for this issue! Porting Obba (see http://www.obba.info) I came across this issue, because Obba provides a function to load an external library. In order to function with sheet-relative paths, this function (e.g. obAddJar) needs to use getURL. The function has a second argument being a boolean "isPathRelative". If you write "obAddJar("lib";TRUE())" the path not expanded. However if you write "obAddJar("lib";IF(TODAY();TRUE();TRUE()), then the function is evaluated at a later time and getURL is valid. Furthermore, try this on a sheet featuring a macro and set a breakpoint in your Java code. If you use the call without TODAY(), then your code will be called before the macro dialog appears. If you use the call with the TODAY() workaround, then the code will be called after the macro dialog appeared. You can check this behavior by downloading the Obba plugin from http://www.obba.info an use the Demo "Normal Distribution.odt". Regards Christian --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
