Turn off spreadsheet auto-transpose

[One Sock]

I use Open Office spreadsheet. When I copy and paste a formula from one cell to another, it automatically transposes the cell data, like from B4 to C4, or B4 to B5. Most of the time, this is great. Once in a while, it's really annoying. How do I turn it off when I want to?

[DaveLembke]

You need to use the "Paste Special" and check or uncheck Transpose as seen in screenshot. When you right-click to get the menu Paste Special is at the bottom of list.

[attachment deleted by admin to conserve space]