On Wed, 27 Apr 2005 16:12:20 +1000, hedley.finger wrote: > Fellow keyboard tappers: > > I am writing a report in OOo Write that refers to specific worksheets in > an OOo Calc spreadsheet. (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 with a folder icon on it 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!
Hedley I just tried this with 2 beta 1.9.95: 1. I created links in a writer document to a spreadsheet in the same directory. I didn't try to alter the links in any way to make them relative. 2 I then zippped the files and moved them to a completely different drive, unzipping them to a new directory. 3 When the writer file was opened, the hyperlinks had changed to reflect the new location. The only problem was that once the hyperlink had opened a particular sheet in the spreadsheet file, clicking on other hyperlinks failed to switch to other sheets in the file. It was necessary to close the file between each attempt to access it via the hyperlinks. -- John [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
