[Solved]] email addresses become unwanted links in Calc

Not sure where to post? Post here!

[Solved]] email addresses become unwanted links in Calc

Postby kharrisma » Sat Dec 02, 2017 1:41 am

Hi Folks

OO newbie here.... I'm creating a spreadsheet that has just a few columns: account name, associated email address, username, password, and other. What's happening is, every time I type in an email address (I have two of them), it automatically becomes a link to my email client (Thunderbird, in this case), and any time I click on the cell to try to re-format it so it ISN'T a link, it just opens a "Write" box in Thunderbird. Annoying as all get-out.

I Just want the email text I enter into the cell to display as just plain text, not become a link. How can I do this? Multiple searches of the site here return lots of hits, but of the opposite kind... people wanting to mass-export lists of email addresses (that presumably are formatted as links in the cells) to some other app. That ain't what I'm looking for, hence the new post.

Thanks in advance for any help!
Last edited by robleyd on Sat Dec 02, 2017 2:27 am, edited 1 time in total.
Reason: tagged [Solved]
OpenOffice 3.2.1 on Ubuntu Linux 10.10
kharrisma
 
Posts: 5
Joined: Thu Nov 03, 2011 12:39 am

Re: email addresses become unwanted links in Calc

Postby RusselB » Sat Dec 02, 2017 1:49 am

While I'm still looking for a way to allow you to enter the e-mail addresses without them turning into links, a work around is to enter the address(es), then highlight the cell(s) and press Ctrl+m in order to have the cells take on the default formatting.
My experiments show that pressing Ctrl+m will remove the hyperlink formatting, leaving the text.
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4158
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: email addresses become unwanted links in Calc

Postby MrProgrammer » Sat Dec 02, 2017 1:54 am

kharrisma wrote:I Just want the email text I enter into the cell to display as just plain text, not become a link.
RusselB wrote:While I'm still looking for a way to allow you to enter the e-mail addresses without them turning into links …
How to prevent automatic styling of cell content

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3122
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: email addresses become unwanted links in Calc

Postby kharrisma » Sat Dec 02, 2017 2:08 am

Thanks, MrProgrammer! Bingo, problem solved!
OpenOffice 3.2.1 on Ubuntu Linux 10.10
kharrisma
 
Posts: 5
Joined: Thu Nov 03, 2011 12:39 am


Return to Beginners

Who is online

Users browsing this forum: jagodic95 and 12 guests