Re: how to rotate a table

2013-10-21 Thread Uwe Brauer 
>> "Brian" == Brian Barker  writes:

   > At 21:54 20/10/2013 +0200, Uwe Brauer wrote:
   > Do you mean a table in a text (Writer) document?
Yes!

   > o Copy the table.
   > o Paste into a spreadsheet (Calc) document, but using Paste
   > Special... | Formatted text [RTF].
   > o Copy the table in the spreadsheet.
   > o Paste elsewhere in the spreadsheet, but using Paste Special... |
   > Options | Transpose.  (This is the trick, of course.)
   > o Cut and paste the first column of your transposed table to the
   >   right of your second.
   > o Copy the new table and paste back into your text document, but using
   > Paste Special... | Formatted text [RTF].

Ok, so it has to be done by *calc* I hoped there was some sort of macro
within writer, but seems not to be the case.

thanks

Uwe 


smime.p7s
Description: S/MIME cryptographic signature

Re: how to rotate a table

2013-10-20 Thread John Meyer 

On 10/20/2013 1:54 PM, Uwe Brauer wrote:

Hi

I googled a bit but found no solution to the problem
of rotating a table such that

| 1 | 2 | 3 |
| 4 | 3 | 4 |
becomes
| 4 | 1 |
| 3 | 2 |
| 4 | 3 |


Thanks


Uwe Brauer





http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_TRANSPOSE_function

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: how to rotate a table

2013-10-20 Thread Brian Barker 

At 21:54 20/10/2013 +0200, Uwe Brauer wrote:
I googled a bit but found no solution to the problem of rotating a 
table such that


| 1 | 2 | 3 |
| 4 | 3 | 4 |
becomes
| 4 | 1 |
| 3 | 2 |
| 4 | 3 |


Do you mean a table in a text (Writer) document?

o Copy the table.
o Paste into a spreadsheet (Calc) document, but using Paste 
Special... | Formatted text [RTF].

o Copy the table in the spreadsheet.
o Paste elsewhere in the spreadsheet, but using Paste Special... | 
Options | Transpose.  (This is the trick, of course.)
o Cut and paste the first column of your transposed table to the 
right of your second.
o Copy the new table and paste back into your text document, but 
using Paste Special... | Formatted text [RTF].


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

how to rotate a table

2013-10-20 Thread Uwe Brauer 
Hi 

I googled a bit but found no solution to the problem 
of rotating a table such that

| 1 | 2 | 3 |
| 4 | 3 | 4 |
becomes 
| 4 | 1 |
| 3 | 2 |
| 4 | 3 |


Thanks 


Uwe Brauer 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org