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 [email protected] 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
