its possible reverse the contents of the rows lines with odd lines in calc?

users
#1

I would have the need to reverse the content, text above and chords under
thanks for help

<http://nabble.documentfoundation.org/file/n4202044/sapore_prova.jpg>

#2

Here's one way:

In B1 (or wherever), enter:
=OFFSET(A1;MOD(ROW();2)*2-1;0)
and fill it down the column.

Note that this works if your list starts in an odd-numbered row (as it does in your picture - in row 1), so that you are exchanging the contents of an odd-numbered row with those of the even-numbered row following it. If your list started in an even-numbered row, so that you were instead exchanging each odd-numbered row with the even-numbered row preceding it, you would need to use the similar formula:
=OFFSET(A1;1-MOD(ROW();2)*2;0)
instead. Alternatively, you could use the original formula but displaced by one row from the data.

I trust this helps.

Brian Barker