Ask Your Question

How to disable email link in calc

asked 2015-08-31 21:48:25 +0200

Doug W gravatar image

updated 2020-07-12 20:30:36 +0200

Alex Kemp gravatar image

In LibreOffice (English) vanilla, how can I enter an email address in a Calc cell and not have it be an email link? I'm using OS X 10.10.5

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2015-09-02 10:57:02 +0200

pierre-yves samyn gravatar image

updated 2015-09-02 12:08:20 +0200


Uncheck Tools Autocorrect Options URL Recognition


Uncheck the option to inhibit recognition when entering new emails.

To remove the links already entered (without losing the text): Edit Find & Replace

  • Search for: .*
  • Replace with: &
  • Other options: check Regular Expressions and possibly check Current selection only


edit flag offensive delete link more

answered 2017-10-27 05:06:59 +0200

simon gravatar image

A more straightforward solution for removing hyperlinks is

  • select the cells containing hyperlinks
  • Click on Format > Clear Direct Formatting (or just press Ctrl+M)
edit flag offensive delete link more


Thanks: I had searched for a solution for more that one hour... (sorry if I can'y upvote being new to this forum: your solution is fast and efficient!)

Leopoldo Vaghi gravatar imageLeopoldo Vaghi ( 2017-12-11 15:20:31 +0200 )edit

answered 2018-08-18 23:53:34 +0200

Bob Coleman gravatar image

The above are both good answers, but I have a further question.

Can I enter an email address and have it remain an active email address, but have the same text and background colors as other cells?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-08-31 21:48:25 +0200

Seen: 10,315 times

Last updated: Aug 18 '18