To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48308
Issue #:|48308
Summary:|Reference to a Calc worksheet not stored as relative
|path
Component:|Word processor
Version:|OOo 1.1.4
Platform:|PC
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|open-import
Assigned to:|mru
Reported by:|hfinger
------- Additional comments from [EMAIL PROTECTED] Wed Apr 27 19:13:41 -0700
2005 -------
This appears to be the same problem as issues 2948, 4790, 11624, 12143, and
21091.
I am writing a report in OOo Write that cross-refers to specific worksheets in
an OOo Calc spreadsheet, which I wish to implement as hyperlinks, so that if
the
user clicks on the hotspot, the referenced spreadsheet will open. (The tables
are too large to include in the text document as either an OLE or DDE link.)
Here is what I do ...
1. Select the words that are to be the hotspot.
2. In the OOo Write document window, choose Insert > Hyperlink.
3. Complete the Hyperlink dialogue:
Path =
file:///C:/Documents%20and%20Settings/Hedley%20Finger/
My%20Documents/Projects/tools_evaluation_comparisons.sxc
(by clicking the Open button and navigating to the
target document)
Target =
Editor Usability
(by clicking the Open the Target button and choosing
the Editor Usability worksheet in the Target in Document
dialogue)
4. In the Hyperlink dialogue, click the Apply and Close buttons.
This produces a hyperlink with an absolute path. The link works absolutely as
expected when it is clicked -- the target spreadsheet opens to the correct
worksheet.
The host text document and target spreadsheet are both in the same folder. I
intend to Zip them up to send to colleagues but the hyperlink won't work
because
my colleagues are likely to Unzip the archive to a different folder. So, in
this case, I want to replace the absolute pathname with a relative path, e.g.
file://./tools_evaluation_comparisons.sxc, so that the link will work as long
as
both files are Unzipped to the same folder.
Trouble is, when I edit the pathname to turn it into a relative path, clicking
the hyperlink produces this error message and the target spreadsheet does not
open:
Error loading document file://./tools_evaluation_comparisons.sxc#Editor%
20Usability
Drive \\.tools_evaluation_comparisons.sxc does not exist.
Please tell me that this is a horrible mistake and OOo _does_ know how to
handle relative paths!
I read in the responses to one of the issues that OOo stores relative pathnames
by default but displays these pathnames in the absolute format. This is bad
usability because the GUI does not match the reality. It also misleads users
into thinking that they can enter a relative path when the REALLY want that.
Also, some simple tests involving moving files seem to indicate that the
absolute path is stored in the doc.l
---------------------------------------------------------------------
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]
