At 13:16 28/05/2018 -0400, Vince Bonly wrote:
I am attempting to insert a link to a .ODT file that contains "read
me first" information associated with one of my Calc spreadsheets. I
have made use of an inserted link on one or two occasions, but do
not recall with confidence what I actually had done.
At present, I want to:
1. initially, create the ReadMeFirst text (.ODT) with AOO Writer;
2. insert a link to the resulting .ODT text file within my Calc .ODS file;
3. have edits to the .ODT file with Writer in the future
reflected/updated whenever I click on the link in the .ODS file.
Can this be accomplished with AOO? If yes, how should I go about
doing the link insertion in Calc?
Have you read "Hyperlinks and URLs" in Chapter 10, "Linking Calc
Data", of the Calc Guide? You should, you know.
o Go to Insert | Hyperlink (or click the Hyperlink button in the
Standard toolbar).
o Click Document at the left.
o Under Document, click the Open File icon and browse to and select
your target text file.
o Under "Further settings", select Text or Button as preferred.
o For Text, enter the text you want to appear for the link.
o Click Apply and Close.
You may want to go to Tools | Options... | Load/Save | General | Save
and to tick "Save URLs relative to file system" or to leave it
unticked if you want these to be absolute. The usefulness of relative
addressing is that the link will still work if the files are moved
but retain the same relative positions in folders. So if you have ,
say, both files in the same folder or perhaps have the text file in a
"Text" subfolder of the spreadsheet's folder, the hyperlink will
still work if both files are moved - perhaps even to another system -
but retain their relative positions. Do not worry that, even with
relative addressing chosen, the address for Path in the Hyperlink
dialogue will always show as an absolute path.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
