Having a bit of trouble understanding the question
I think that what you want to do is to reverse the order (based on
rows), so that the first row becomes the last row and the last row
becomes the first row.
Although this can be done using a macro, I would probably do something
like
On Wed, Jan 15, 2014 at 5:13 PM, Jim Plante wrote:
> Add a column in front of Column A. Enter in the cell "=ROW()"; If the sheet
> contains a header row in Row 1, then make that formula "=ROW()-1". Copy that
> formula all the way down.
>
> Now, select the entire table and sort descending on Colu
- Mensaje original -
De: "Wade Smart"
Para: ooo-us...@incubator.apache.org
Enviados: MiƩrcoles, 15 de Enero 2014 23:45:40
Asunto: [openoffice] Flipping a table
In my calc sheet I have a need to flip the
entire sheet. So Column 1A would be 450A?
Ive found several macr
Add a column in front of Column A. Enter in the cell "=ROW()"; If the sheet
contains a header row in Row 1, then make that formula "=ROW()-1". Copy that
formula all the way down.
Now, select the entire table and sort descending on Column 1. You can retain or
delete the extra column when you've
In my calc sheet I have a need to flip the
entire sheet. So Column 1A would be 450A?
Ive found several macros but Ive not been
able to get them to work. Does anyone know
if this can be done?
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---