English
Ask Your Question
1

Deleting Hyperlinks

asked 2012-04-22 20:53:36 +0200

Philip Hurzeler gravatar image

How to delete a hyperlink in a spreadsheet cell? LibreOffice is adding them automatically to email addresses. The UI enables editing the hyperlink, but not removing it.

edit retag flag offensive close merge delete

3 answers

Sort by » oldest newest most voted
4

answered 2012-04-22 21:37:33 +0200

luyu gravatar image

Right-click the cell, then "Clear Direct Formatting". This will also reset all formatting you might have applied, but it will remove hyperlink.

If you want to permanently disable automatic hyperlinking, go to Tools -> AutoCorrect Options, "Options" tab and uncheck "URL Recognition".

edit flag offensive delete link more

Comments

I've just upgraded to Mavericks and using Libreoffice 4.1.5.3 I used to be able to remove unwanted hyperlinks with 'clear direct formatting' but that no longer seems to be effective, and my 'URL recognition' options are unchecked. Any ideas?

zohre6 ( 2014-03-12 15:37:50 +0200 )edit
1

answered 2012-04-26 20:43:09 +0200

DiamondWillow gravatar image

Thank you; apparently I can also "select" the links and then right-click on them and choose to UNlink them.

edit flag offensive delete link more

Comments

This doesn't work in my version of LO (4.2.1.1). When I right click on the link, I see this:

https://dl.dropboxusercontent.com/u/21862473/techSupport/lo_hyperlink.jpg

I see the "Clear Direct Formatting" option as described above, but no "UNlink" option.

mszczepaniak ( 2014-03-09 14:42:48 +0200 )edit
0

answered 2012-04-26 18:55:53 +0200

DiamondWillow gravatar image

Hello; I am NOT using a spreadsheet; just a page with 10 table cells, each for a business card. I have my URL and my email addy on each card but do NOT want them underlined as links. How can I remove the linking please? I can email you the odt file if that will help. Thank you!

edit flag offensive delete link more

Comments

1

Delete your URL and email. Press Enter a few times to create empty lines. Paste your URL on the first line and DON'T press Enter. Just use the cursor keys or click on the next empty line and paste the email address.

Pedro ( 2012-04-26 19:53:57 +0200 )edit
Login/Signup to Answer

Question Tools

Follow
1 follower

Stats

Asked: 2012-04-22 20:53:36 +0200

Seen: 15,384 times

Last updated: Apr 26 '12