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 <r...@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+unsubscr...@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+unsubscr...@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
