Re: [libreoffice-users] its possible reverse the contents of the rows lines with odd lines in calc?

At 08:33 07/12/2016 -0700, Nobody Noname wrote:
> I would have the need to reverse the content, text above and chords under
> <http://nabble.documentfoundation.org/file/n4202044/sapore_prova.jpg>

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


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