Ask Your Question
1

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 4.4.4.4, 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
1

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

pierre-yves samyn gravatar image

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

Hi

Uncheck Tools Autocorrect Options URL Recognition

[EDIT]

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

Regards

edit flag offensive delete link more
0

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
0

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

Comments

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

Stats

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

Seen: 8,034 times

Last updated: Aug 18 '18