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?
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
