Ask Your Question

How can Calc be prevented from formatting a mailto: link

asked 2017-01-30 22:14:32 +0200

Ron gravatar image

When I enter an email address in a cell, Calc automatically converts it to a mailto: link. I don't want it to do that. How/where can I turn that off?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-01-30 22:45:21 +0200

Uncheck Tools > AutoCorrect Options... > Options > URL Recognition. Afterwards, none of the URLs or mail directions will be converted to a link.

edit flag offensive delete link more

answered 2017-01-30 23:25:22 +0200

Lupp gravatar image

updated 2017-01-31 00:05:58 +0200

If you want to have the URL recognition on, there is also this way:
As long as the email address (or another recognisable link) is not part of an extended text you can escape recognition by entering a simple formula like ="My.Self@ourdomain.cosm" or even ="mailto:MySelf@ourdomain.universe".

See also:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools


Asked: 2017-01-30 22:14:32 +0200

Seen: 388 times

Last updated: Jan 31 '17