[Solved] Entering email address in cell in Calc

Discuss the spreadsheet application
Post Reply
SharoninDunedin
Posts: 1
Joined: Tue Sep 15, 2009 4:52 pm

[Solved] Entering email address in cell in Calc

Post by SharoninDunedin »

I want to enter an email name without it during grey and becoming a link.

I am entering a long list of names and emails to download to an application. Most of the emails are pasted in and do not automatically activate a request to send mail when I click on that cell. However, if I enter the email name directly into a cell it becomes a link. Can I turn off that function so that I can just type in email names without them becoming a link?
Last edited by TheGurkha on Tue Sep 15, 2009 7:02 pm, edited 1 time in total.
Reason: Taggeed as solved, OP emailed that it worked.
OpenOffice 2.4 on Windows XP
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: entering email address in cell in Calc

Post by acknak »

I think the only way to turn it off for typed entries is Tools > AutoCorrect Options > Options > URL Recognition: OFF (unchecked).

Just remember: That setting also affects the other OOo applications, so if you want this feature in other situations, you'll have to turn it back on.
AOO4/LO5 • Linux • Fedora 23
Post Reply