Libre Office Vanilla on Mac Air. After hightlighting text in Calc cell and opening hyperlink box I cannot copy and paste URL link into URL box. What does happen is URL link appears in Calc cell. This failure occurs just the same in Writer too. Any help please?
menu:Insert>Hyperlink… [Ctrl+K]
Paste URL, add optional text, hit Enter twice for the dialog and the cell content.
Thank you for your suggestion.
Sorry but I don’t think I fully understand your instructions.
First instructions are fine - identify the cell Insert > Hyperlink Hyperlink dialogue box opens. Paste URL At this point the URL appears in the cell not the URL box . I then added the text to the Text box and hit Enter twice but the URL still appears in cell.
@Villeroy
I have half solved my problem.
[Command + K] Hyperlink dialogue box appears - then [Command + V] URL link appears in Hyperlink URL box. Enter relevant text in text box. Hit enter Hyperlink appears in desired cell.
Or, even simpler, highlight text in Calc cell and follow above sequence works the same
Why, therefore does copy and paste not work in the same way?
Any help gratefully received
Paste a copied URL into the cell or to the text cursor position within the cell. When you append a space, the finished URL will be recognized and converted into a hyperlink text field.
If you want to edit an existing text field, select it and call the hyperlink dialog.
Villeroy Many thanks indeed for your patience and suggestions which I have now practiced giving me a range of options on hyperlink insertions in Calc and Writer.