How can Calc be prevented from formatting a mailto: link [closed]

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

Ron
80 ●3 ●4 ●9

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-23 03:17:35.908684

add a comment

2

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

asiersar
221 ●3 ●6 http://librezale.eus/w...

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

add a comment

0

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

Lupp
20174 ●46 ●126 ●245

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

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".

edit flag offensive delete link

add a comment

How can Calc be prevented from formatting a mailto: link [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-23 03:17:35.908684

2 Answers

Question Tools

Stats

Related questions

How can Calc be prevented from formatting a mailto: link [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-09-23 03:17:35.908684

2 Answers

Question Tools

Stats

Related questions

How can Calc be prevented from formatting a mailto: link [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-23 03:17:35.908684