Search This Blog

Wednesday, October 26, 2005

Transpose of data

To take transpose of rectangular data in oocalc
  • Select the rectangular region of interest
  • Press ctrl-c to copy the data
  • Go somewhere where you have sufficient space to paste the transpose. This will be your top-left corner of the new matrix.
  • Enter Ctrl-Shift-V to bring up the Paste Special dialog
  • Select Transpose in the Options field and press OK

tested on oocalc 2.0 on Debian Sid

No comments: