Hi, Bob. You would have to insert a spreadsheet into the presentation
(or include a spreadsheet in the group of files) in order to take
advantage of that method.
I'm at a disadvantage there because I do not use presentations. I've
just checked, though, and there is a menu command Insert >Spreadsheet.
Perhaps the inserted spreadsheet could be an index?
You will not find anything in Help. This was a method devised by
someone to work around the lack in the software.
A hyperlink in a spreadsheet can be created with a formula. The formula
can refer to other cells containing components of the link. Instead of
the =DDE mentioned in other messages in the thread, you would use the
=HYPERLINK function.
It is not the ideal method but I know of no other. Look back through
the thread for further information.
Bob Treder wrote:
Could someone please explain how to use the named references? I've tried
looking in help but have been unsuccessful. I am building Impress documents
and need to create relative paths which are still broken in OO 2.0.3. I
insert icons in the document that are hyperlinked to other documents. I
create the hyperlinks by right clicking on the icon image and selecting
"Interaction...". That opens a dialog with a list box of different options. I
select "Go to Document" and then browse to and select the document which
fills in the document URL. That is filled in as an absolute. Where in this
process can I use the named references indicated below to produce relative
paths? Or what other process do I use?
I will be most grateful for a solution to this.
Bob
[EMAIL PROTECTED]
-----Original Message-----
From: CPHennessy [mailto:[EMAIL PROTECTED]
Sent: Monday, October 09, 2006 2:19 PM
To: [email protected]; Bob Treder
Subject: Re: [users] Open Office relative path vs. hard coded path. OO 2.0.1
is broke
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.
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
