Re: [libreoffice-users] Link in calc

Tom,

Thanks for your reply.
This works in MS Excel. Just insert > hyperlink enter A2 as the cell, and =A2 in the text.

Anyway, if one inserts lines, the link is not updated, so this makes the whole thing quite 
unworkable...
I would expect this to be 'automagically' update, much like formula references.

Is this a bug, or is this for some reason 'per design'?

Rob.

PS. Excel doesn't update the link either, but it does update the formula ref.
.
Op 27 aug. 2014, om 17:30 heeft Tom Davies het volgende geschreven:

> Hi :)
> I think just typing
> =A2
> into cell B4 would do the job?
>
> B4 wouldn't be clickable but if you double-click on it then it would
> highlight A2 to show the source.
>
> I'm not sure how to do both things at the same time unless you do the whole
> thing in html.  An html table might be a better idea for this but even that
> would be quite messy.
>
> Apols and regards from
> Tom :)
>
>
>
>
> On 24 August 2014 19:51, Rob Jasper <Rob@famjasper.nl> wrote:
>
> > Hi,
> >
> > I have a list of names, for which I want to reference AND link to other
> > names.
> >
> > Think about:
> >
> > —
> >        A       B       C
> > 1       Name    Parent1 Parent2
> > 2       John
> > 3       Eve
> > 4       Chris   John    Eve
> > ---
> >
> > Where the parent is both to link the value and a hyperlink to the
> > respective cell. So B4 should be both #A2 as =A2.
> > Can this be done? The hyperlink screen does not seem to allow a formula
> > i.s.o. text...
> >
> > Best,
> > Rob.
> >
> >
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted