You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by "WA.TWORSX via AOL" <wa...@verizon.net.INVALID> on 2020/04/25 13:27:36 UTC
format for a website
Calc 4.1.5, Win10 x64, desktop
_______________________________________________
Within a Calc sheet there exists, say, www.domain.com in plain text
format, (or email.address@isp.net). How is this converted to a hotlink
so when clicked my browser opens to that website (or my email client
opens a compose window) ?
I know how to convert a hotlink to a non-hot link, but how do I go the
other way?
Stay safe.
Regards,
VinceB.
Re: format for a website
Posted by "Vince B." <wa...@verizon.net.INVALID>.
TNX Brian. That works for me!
Regards,
Vince
Sent from my iPad
> On Apr 25, 2020, at 09:45, Brian Barker <b....@btinternet.com.invalid> wrote:
>
> At 09:27 25/04/2020 -0400, Vince Bonly wrote:
>> Within a Calc sheet there exists, say, www.domain.com in plain text format, (or email.address@isp.net). How is this converted to a hotlink so when clicked my browser opens to that website (or my email client opens a compose window) ?
>
> Easy way:
> o Position the cursor in the cell immediately after the relevant text.
> o Press the spacebar.
> o Backspace over the space to delete it.
>
> More generally:
> o Select not the entire cell but the required text within that cell.
> o Insert | Hyperlink.
> o Etc.
>
> I trust this helps.
>
> Brian Barker
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
Re: format for a website
Posted by Brian Barker <b....@btinternet.com.INVALID>.
At 09:27 25/04/2020 -0400, Vince Bonly wrote:
>Within a Calc sheet there exists, say, www.domain.com in plain text
>format, (or email.address@isp.net). How is this converted to a
>hotlink so when clicked my browser opens to that website (or my
>email client opens a compose window) ?
Easy way:
o Position the cursor in the cell immediately after the relevant text.
o Press the spacebar.
o Backspace over the space to delete it.
More generally:
o Select not the entire cell but the required text within that cell.
o Insert | Hyperlink.
o Etc.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org