Ask Your Question

How to disable email link in calc

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

Doug W gravatar image

updated 2015-09-01 00:12:51 +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 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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 8,034 times

Last updated: Aug 18 '18