On Mon, 9 Oct 2006 22:19:13 +0100 CPHennessy <[EMAIL PROTECTED]> wrote:
> On Sat October 7 2006 09:39, + Bob Treder wrote: > > [ MODERATED ] ******************** > > It looks like this is still broken in OO 2.0.3. I'm developing some > > training materials in Impress and badly need relative paths to make passing > > of materials work from wherever they are installed. Does anyone have a > > suggestion on how to work around this? Everytime I create the link in > > Impress, even with the two boxes checked that a mentioned in the messages > > below the full path gets saved. > > > As you are not subscribed you may not have seen that: > On Sun October 8 2006 01:01, Terry wrote: > > You could use the following methods published by an expert Spreadsheet > > user on the forum: > > > > [quote] > > Some named refs from my default template. No macros, > > platform-independant and they should work with Excel as well: > > cFilename =CELL("FILENAME") > > FilePath =RIGHT(FileURLPath;LEN(FileURLPath)-7) > > FileURL =MID(cFilename;2;SEARCH("'#";cFilename)-2) > > FileURLPath =MID(cFilename;2;SEARCH("/[^/]+'#";cFilename)-1) > > shSep =MID(ADDRESS(1;1;1;"Foo");4;1) > > ThisSheet =MID(cFilename;FIND("#$";cFilename)+2;256) > > > > shSep returns "." in Calc and "!" in Excel (useful with indirect() or > > pattern matching with/without regular expressions). > > "FilePath" with Windows: =SUBSTITUTE(FilePath;"/";"\") > > [end quote] > > Please reply to users@openoffice.org only. > Looked at those, and for the life of me, could not get them to do what I want. DDE is so much simpler. -- Rodney D. Myers <[EMAIL PROTECTED]> Registered Linux User #96112 ICQ#: AIM#: YAHOO: 18002350 mailman452 mailman42_5 They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Ben Franklin - 1759
signature.asc
Description: PGP signature