Re: [libreoffice-users] Fill down with a twist. [SOLVED w/ hack]

also sprach Tom Davies <tomcecf@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.bogus@madduck.net

-- 
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