[libreoffice-users] Re: flip columns in calc

-------- Original Message --------
Subject: Re: flip columns in calc
From: Stefan Weigel <stefan.weigel@bildungskreis.org>
To: users@global.libreoffice.org
Date: 2011.11.03.Thu.2:14:20
> Hi Jason,
>
> Am 03.11.2011 05:12, schrieb Jason Paul Joines:
>
> > Is there any way
> > to reverse the order of columns in a Calc spreadsheet?  For example,
> > if I have columns A through Z, I want to re-order them so that the
> > contents of Z are in A, Y in B, X in C, ..., A in Z, B in Y, C in
> > X.
> (1) Insert a row at the top.
>
> (2) Fill the row with the values 1, 2, 3, ... (This is very easy, if
> you use the AutoFill functionality.
>
> (3) Sort your columns in descending order of row 1.
>
> (4) Delete the column insertet in step (1)
>
> > In reality I need to leave the first 9 columns in order and have
> > many more than 26 columns.
> I don´t get that. A sheet has 1024 columns.
>
> Stefan


    Thanks for the suggestion.  I played with sort by column a bit 
before posting but never even thought of adding a temporary index row.  
That worked great.

    To me, 1024 columns is many more than 26 columns.  Especially if 
you are cutting column 1024, inserting a new column in front of 1, 
pasting into that, repeat until they're all reversed.


Jason
===========


--
For unsubscribe instructions e-mail to: users+help@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