On Fri, 2005-03-04 at 13:15 +0000, Max Quordlepleen wrote:
> 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.
>
Try:
1. Select cell
2. Insert Hyperlink
3. Edit as needed
4. Click ok
Let us know if this works for you.
--
Documentation Co-Lead
PLEASE - keep list traffic on the list. Email sent directly to me may
be ignored utterly.
"Dinna meddle wi' things ye ken nuthin' aboot!"
J.Herriot
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
