When I edit text that looks like either a url or an email address, it is formatted as a link, and I cannot work with the text. How do I prevent the cells from being interpreted as links?
LeroyG answers your question but for existing hyperlinks, they can be removed by right-clicking on the hyperlink and selecting Remove hyperlink
Choose menu Tools - AutoCorrect Options… - Options tab, and uncheck URL Recognition.
See LibreOffice Help on AutoCorrect Options.
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→ 
) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow (
) that is on the left (to vote, you need to have karma of at least 5).