[Solved] Unwanted assumption of an email address

Discuss the spreadsheet application
Post Reply
hypGnosis
Posts: 16
Joined: Fri Apr 26, 2013 10:40 pm

[Solved] Unwanted assumption of an email address

Post by hypGnosis »

Example; x@x

When I enter the @ symbol with characters on either side into a cell, the entry is assumed by OO to be reminiscent of an email address, which in my case, it is not.

The entry automatically receives a darkened background which I do not want.

In some instances, when I click on the affected cell in order to edit, the Google browser pops-up instead.

How do I override this unwanted behavior?
.
Last edited by thomasjk on Sat Dec 31, 2016 11:09 pm, edited 1 time in total.
Reason: Mark thread [Solved] and add green checkmark
OpenOffice 4.1.7 on Windows 10
User avatar
RoryOF
Moderator
Posts: 35203
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Unwanted assumption of an email address

Post by RoryOF »

Try /Tools /Autocorrect options : Options tab and uncheck URL recognition.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
hypGnosis
Posts: 16
Joined: Fri Apr 26, 2013 10:40 pm

Re: Unwanted assumption of an email address

Post by hypGnosis »

Works like a charm!

Of course, a URL is not an email address, but ... whatever.

Beaucoup thanx, RoryOF!
OpenOffice 4.1.7 on Windows 10
User avatar
Lupp
Volunteer
Posts: 3755
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: [Solved] Unwanted assumption of an email address

Post by Lupp »

Workarounds
If you want URL recognition generally but want to block it in specific cases (pseudo URL?) you may enter the respective texts as little formulae generating the wanted display. For example:

Code: Select all

="with@gore.tex"
If you want to make wrong "recognition" undone under circumstances defined by a syntax that can be given as a RegEx (regular expression), you can use the 'F&R' tool to revert the unwanted procedure.
On Windows 10: LibreOffice 25.8.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Post Reply