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 <[email protected]> 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: [email protected] >> 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: [email protected] > 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: [email protected] 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
