Ubuntu
openoffice.org package

using spreadsheet as database, clicking in cell with an email address automatically triggers an email box (multiple times); how can I disable this so that I can simply edit email addresses?

Asked by Cathy Silber

Using spreadsheet as a database of names, addresses, email addresses etc. Clicking in the email address cell automatically generates an email to that address, and trying to get into the cell without generating an email box usually results in failure--and multiple email boxes that have to be closed one at a time, each time telling it yes, I really mean to discard this email.

How can I disable this automatic email function (in all open office documents)?

thanks.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
DrewJensen (atjensen) said : 		#1

Hod down the CTRL key when you click the field - that should do it.

Revision history for this message
Lars J. Nielsen (ebidk) said : 		#2

Another option is to use the arrow keys to navigate instead of the mouse and then pressing F2 to edit the current cell.

Revision history for this message
Tony Pursell (ajpursell) said : 		#3

Hi

Go to this Help menu item

"Turning off Automatic URL Recognition"

You can turn off URL Recognition completely in Tools > AutoCorrect Options > Options.

You can turn off URL formatting for an individual entry as soon as you have typed it Ctrl-Z, or later, by selecting it and going Format > Default Formatting (or Ctrl-M).

Tony

Revision history for this message
Tony Pursell (ajpursell) said : 		#4

Hi again

If you want to retain the facility to click on the email address to email the person, then I suggest you format the cell width to ensure it is wider than the longest email address. You can then click on the white space at the end of the cell without triggering an email.

Tony

Can you help with this problem?

Provide an answer of your own, or ask Cathy Silber for more information if necessary.

To post a message you must log in.