openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <b.m.bar...@btinternet.com>
Subject Re: how to rotate a table
Date Sun, 20 Oct 2013 20:13:37 GMT
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message