Re: [libreoffice-users] Calc- how to edit a link to a file

Brian,

I just tested what you said.

Indeed, when the cell contents is selected (cursor before content, the move over it with 
'shift/right arrow'), the content is available when opening the dialogue both from the button 
(which I never spotted in the first place :-) and from menu insert > hyperlink (⌘K).
From the menu this is not very intuitive, I think.

When I went to the save preferences, the option for relative path was already set (apparently it is 
the default). Since it is not displayed in the dialogue this way, I just didn't think that it would 
automagically be right. Next time no assumptions, just test first!

Thank you for your clear answer,

Rob.


On 18 aug. 2015, at 21:58, Brian Barker wrote:

> At 20:57 18/08/2015 +0200, Rob Jasper wrote:
> > I inserted a link to another pdf file. That works, if I click the link the other file is opened. 
> > Here's the weird thing. I don't seem able to edit the text value, nor the path. If I right click 
> > there's not something as edit (the link). Also in the menu I can't find something like 'edit 
> > link'. Am I missing something?
>
> I think you need first either to put the cursor immediately to the left of the hyperlink or to 
> select the hyperlink text itself - which you cannot do simply by clicking or double-clicking, of 
> course. Then you can open the Hyperlink dialogue either by clicking the Hyperlink button in the 
> Standard toolbar or by going - perhaps somewhat counterintuitively - to Insert | Hyperlink. You 
> may find it easier to open the Hyperlink dialogue first and then navigate to the hyperlink in the 
> cell: the dialogue will populate when you reach the right point. If the cell contains only the 
> hyperlink, you need only to select the cell.
>
> > If change the path to a relative path (as from the location of the calc file) I get an error 
> > message when clicking the link. The message says: LibreOffice could not find a web browser on 
> > your system. Please check your Desktop Preferences or install a web browser (for example, 
> > Firefox) in the default  location requested during the browser installation.
>
> LibreOffice always display absolute paths, since this is the way it operates internally. Your 
> choice to have a relative path is a matter of what is stored in the document file when it is 
> saved; if you want the path to be relative, you need to make this choice at Tools | Options... | 
> Load/Save | General | Save | Save URLs relative to file system. (Oh, on your Mac OS system, 
> that's at LibreOffice | Preferences | Load/Save ... .) If you create the link in the normal way 
> and have this setting ticked when you save the document, the link will behave as a relative link 
> when the document is reopened. In other words, if the document file is moved the absolute file 
> path that would then be displayed would be appropriately different.
>
> The message about a browser implies that your hyperlink is now being treated as an internet link 
> instead of a document one. This may be because you have selected Internet instead of Document in 
> the Hyperlink dialogue, but perhaps you have just attempted to edit the document path 
> inappropriately - losing its leading "file:///" - and confused LibreOffice.
>
> I trust this helps.
>
> Brian Barker
>
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted