Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.