OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Entering/editing email addresses as plain text in Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
RoseWind
General User
General User


Joined: 30 Aug 2010
Posts: 5
Location: Port Townsend

PostPosted: Tue Dec 06, 2011 9:30 am    Post subject: Entering/editing email addresses as plain text in Calc Reply with quote

Calc recognizes the "@" symbol and treats email addresses specially.

I am a poor typist with 50 addresses to enter, so I need to correct my typing after leaving the field, [b]preferably without reentering the entire address[/b]. However Calc won't let me do this as I can in most fields. The whole address is highliighted and when I try to edit the whole address string is replaced.

Is there a cell format that I can use that will let me treat these addresses as plain text for purpose of data entry?

I know there must be but I don't know how to look it up in HELP, so you help please!

P.S. Yes I could do this all in a CSV text file but that would just be a work around :-)
_________________
NOT a Techie anymore ...
Back to top
View user's profile Send private message Visit poster's website
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Tue Dec 06, 2011 9:42 am    Post subject: Reply with quote

Why do you use a calculator program for list keeping?
Have a look at Tools>AutoCorrect. There you should find some setting to turn off URL recognition.

This tiny program is a very good and simple tool to keep lists in plain text files: http://csved.sjfrancke.nl/
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
RoseWind
General User
General User


Joined: 30 Aug 2010
Posts: 5
Location: Port Townsend

PostPosted: Tue Dec 06, 2011 2:01 pm    Post subject: Autocorrect URL recognition turned OFF Reply with quote

Thank you for the suggestion! I turned OFF URL recognition and the existing email address fields are still greyed out and "recognized" ... but new entries are treated as plain text so more convenient to correct.

As to using Calc, I like to enter the data using software that recognizes fields, is something I already have, & will save as a csv file for upload to a mailing list.

Seemed reasonable at the time :-)
_________________
NOT a Techie anymore ...
Back to top
View user's profile Send private message Visit poster's website
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Tue Dec 06, 2011 4:16 pm    Post subject: Reply with quote

Use Format-->Clear Direct Formatting to cleanup the left overs.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group