Apache OpenOffice (AOO) Bugzilla – Issue 100355
Cut / Paste Special shift cells defective
Last modified: 2013-01-29 21:40:02 UTC
When the paste special dialog is opened after cutting cells, the special paste dialog disables the shift cells down option if the paste area overlaps columns with the cut area. The same holds for the shift cells right options if it overlaps rows. This is correct behavior, however it is not checked if the overlapping rows/columns are on the same sheet. Steps to reproduce: 1) Create a new spreadsheet 2) Cut cell B2 3) Paste special at cell B1, shift cells down is disabled as expected. 4) Close the dialog 5) Paste special at cell A2, shift cells right is disabled as expected. 6) Close the dialog 7) Paste special at cell A1, all shift options are enabled as expected. 8) Close the dialog 9) Go to the Sheet2 10) Paste special at cell B1, shift down is disabled, this is not expected because it is a different sheet. 11) Close the dialog 12) Paste special at cell A2, shift right is disabled, this is not expected because it is a different sheet. 13) Close the dialog
confirm the issue with 3.2.0 Question: why is it correct behaviour if the shift cells down option is disabled if the paste area overlaps columns with the cut area (and shift down with rows)?
Confirmed in 3.2 Regarding your question. Where I previously stated that it is correct behavior I should have stated that it I believe it to be an unimplemented feature. I suspect that such a feature would require some special rules when it comes to updating of references in formulas. Somewhere it was apparently decided to disable the feature, but I simply see no reason why it should be disabled when special pasting cut cells on a different sheet. Obviously implementing the feature would be the preferred solution to this problem, since it can be quite frustrating when pasting a range that does not even contain formulas (and hence there should be no doubt about the expected behavior).