Hi :) Congrats! Nicely found! :)) Some good experimentation and interesting results there! Congrats and regards from Tom :)
On 19 September 2014 15:00, martin f krafft <madd...@madduck.net> wrote: > also sprach Tom Davies <tomc...@gmail.com> [2014-09-19 13:56 +0200]: > > Create (perhaps by inserting a new row 3 temporarily?) > > > > B3 = '=B2' > > C3 = '=C2' > > D3 = '=D2' > > E3 = '=E2' > > etc and then select all them, copy and transpose 'into' A2 and onwards. > > > > Does that not work? > > No. :( > > If I take that temporary row 3 and paste it into the four fields in > the destination column G1:G4, then the references get "rotated" too. > > I.e. the result will be: > > G1 = '=F1' > G2 = '=F2' > G3 = '=F3' > G4 = '=F4' > > This is because row three in the above always references the cell > above, and after transposing with paste-special, the resulting cells > are modified to reference the respective cell to the left. > > If I change B3:E3 to '=B$2':'=E$3', I get an error 522 in the > result, because the cells are now all '=G$2', which is > a self-reference. > > If I change B3:E3 to '=$B2':'=$E2', I get the following weird > result: > > G1 = '=$B#REF!' > G2 = '=C1' > G3 = '=D2' > G4 = '=E3' > > But if I change B3:E3 to all absolute references, then it works. > Super! Thank you for that hint. It's a hack, but it works. > > -- > @martinkrafft | http://madduck.net/ | http://two.sentenc.es/ > > "der glaube an den kausalnexus ist der aberglaube" > -- wittgenstein > > spamtraps: madduck.bo...@madduck.net > -- 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