Ask Your Question
0

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
2

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
0

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: https://forum.openoffice.org/en/forum...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

Stats

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

Seen: 293 times

Last updated: Jan 31 '17