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.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
