How can Calc be prevented from formatting a mailto: link

edit

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