We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

Deleting Hyperlinks [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 23:10:44.225734


Please re-open the question, since the answer does not work.

This is a bug that has been reported repeatedly here and here and more. Please add your vote and voice to those bug reports to get them fixed.

Lifeboy gravatar imageLifeboy ( 2017-10-13 10:48:10 +0200 )edit

3 Answers

Sort by » oldest newest most voted

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



I've just upgraded to Mavericks and using Libreoffice 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 gravatar imagezohre6 ( 2014-03-12 15:37:50 +0200 )edit

It's 2017, LO on Ubuntu and this is still the case. "clear direct formatting" does not remove the email hyperlink.

Lifeboy gravatar imageLifeboy ( 2017-10-13 10:46:59 +0200 )edit

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


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


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

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

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



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 gravatar imagePedro ( 2012-04-26 19:53:57 +0200 )edit

Question Tools



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

Seen: 54,321 times

Last updated: Apr 26 '12