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

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 <madduck@madduck.net> wrote:

> 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