Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When using cut and pasting LibreOffice maintains exact formula used along with moving old references to point to the new location, however when using paste special: transpose it treats the past as if copy was used (recalculating references relative to new positions and breaking references to the moved cells)

Is there some way to prevent this change of behaviour when transposing or is there another way to transpose these cells whilst maintaining their exact references (as is) and the references to these cells.

Shift+F4 simply toggles the "absoluteness" of every reference within the cells, as some references within the range are absolute it cannot be used to make every reference within them exact.

Aside from manually moving each and every cell is there a method to do this? Even partial solutions appreciated.

share|improve this question

You can use normal transpose method (see also ) or you can use transpose function in Calc. So you must select any cell that must transposed matrix be replaced there, then click on formulas section and choose transpose from list. after choosing main matrix, transposed matrix would be appeared.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .