Is there a way to change an oocalc horizontal layout to vertical?

[Joseph Sinclair]

No problem, follow these steps:
1) Create a new blank sheet
2) Go to the source sheet
3) Select the block you wish to transpose
4) Edit|Copy
5) Select the new blank sheet
6) Select Cell A1
7) Edit|Paste Special
8) Click the transpose checkbox
9) OK

This will copy your data into a new sheet with columns and rows transposed.

Josef Lowder wrote:
> Is there any way to change a horizontal oocalc spreadsheet
> to a vertical layout -- i.e. so that all existing horizontal columns
> would be converted to become vertical rows, and all data
> in each column and row is rearranged accordingly?
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url : http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20080607/8cb4a84d/attachment.pgp