On 06/12/2007, Harold Fuchs <[EMAIL PROTECTED]> wrote:
>
>
>
> On 06/12/2007, Brian Barker <[EMAIL PROTECTED]> wrote:
>
> <snip>
>
> That's easy to get around. You need the HYPERLINK function, which
> > will do what you need on the fly:
> > =HYPERLINK("http://www.org.org/page/anotherpage="&A8)
> >
> > If you want different text from the URL displayed in the cell, use:
> > =HYPERLINK(" http://www.org.org/page/anotherpage="&A8;"Click Me!")
> >
> > I trust this helps more.
> >
> > Brian Barker
> >
>
> I'm confused. I'm using OO 2.2 on Win XP Pro.
>
> If I enter "www.openoffice.org" without the quotes into a Calc cell then
> (a) it shows up in blue on a grey background and (b) if I click in the cell
> my web browser fires up and goes to that page.
>
> If I enter "=hyperlink("www.openoffice.org")" without the *outer* quotes,
> then neither of those things happens. The "link" is dead although the mouse
> pointer changes to a hand when hovered over the cell.
>
> What is happening here please?
>
Sorry to reply to my own post but I've solved *part* of the mystery.
I find that I need to put "http://"; before the text in the "hyperlink"
function. This makes the link live and my browser fires up correctly.
However, it does *not* show the text as blue on a grey background.
Help!
Oh, Brian Barker, your "trick" of concatenating the contents of a cell
using "&" works perfectly although it can only be used within the
"hyperlink" function and *not* by clicking the "hyperlink" toolbar button
and filling in the form.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
