I am trying to transpose horizontal cell data to vertical columns. I select the row data, click cut, click on new cell, click paste special. The screen has one selection of "unformatted text", I click OK and it pastes in rows. I have no "paste all" or "transpose" options so cannot perform the transpose I need.
Thanks in advance for any help.
Thank you for the responses. This behavior could not be replicated after a reboot.
You must be working in a plain table in Writer. Paste Special has a Transpose setting in Calc.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-04 19:50:51 +0200
Seen: 250 times
Last updated: Aug 20 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Which OS , which LO version? I tried to reproduce this with Ubuntu 12.04 and LO 3.5.4, but the only way to get that selection dialogue after "
tohuwawohu ( 2012-08-04 20:54:53 +0200 )editPaste Special" is using the the "Paste Special" functionality of Writer, not Calc. If the problem persists: Could you create a screencast ...... of how you proceed to reproduce this behaviour?
tohuwawohu ( 2012-08-04 20:55:14 +0200 )edit