I am on Win10 Pro - recently upgraded to LO 7.5 .0.3 and had no problems before with copy and paste special (column to row) with transpose ticked and Values only highlighted in the Paste Special dialog box and pasting only text and numbers.
It is now very flaky, works sometimes but most of the time when I paste (after highlighting cells and right click copy with the mouse) into a cell in an adjacent sheet nothing happens or this Information Widow comes up with “Protected cells can not be modified.”. No cells are protected in the ods.
Sometimes when I right click to paste, the Paste Special box comes up saying:
Source Unknown and under Selection: Unformatted text and Use Text import dialog.
Exited all the clipboard managers as they sometimes copy text as an image from Calc.
Very confusing and frustrating as the only work around is to paste normally and then manually move the cells (sometimes up to 50) into a row.
Also when the paste fails and after trying a couple of times , Calc stops responding and after forcefully terminating the program, the spreadsheet has to be restored and I lose all the modifications made - which means having to remember to save after each one.
I have also reset the user profile to default but it does not seems to have had any effect on restoring the Paste Special > Transpose to a working, reliable facility.
Any help much appreciated.
