Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

also sprach Tom Davies <> [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

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 | |
"der glaube an den kausalnexus ist der aberglaube"
                                                       -- wittgenstein

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.