James Plante wrote:
On Mar 4, 2005, at 6:36, Max Quordlepleen wrote:
Last night I was compiling a list of email addresses in a Calc sheet. Each time I entered one, it was formatted as a live mailto link. So far, so good. If, however, I made a typo, and tried to edit the address, the hyperlink formatting was switched off, and I had to delete the entire address and retype it.
This was in 1.9m79, on W2K. Is there a way to avoid this minor nuisance?
Look at the bottom of the window in the status line. See the entry that says "HYP?" Click on it. It changes to "STD." Now you can edit the entry normally.
Jim Plante
Actually, even though each address is fully clickable (if I hover them, the popup reads "mailto:[EMAIL PROTECTED]"), that entry you point too _already_ says "STD", and it is not clickable. I am unable to change that to HYP, or to anything else. The addresses remain resolutely uneditable.
1. Move into the cell, containing address, address will be shown on input line.
2. Put cursor into input line, input line changes to field.
3. Right-click on input line - now is address editable in CELL :)
Weird, but works.
ain
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
