Apache OpenOffice (AOO) Bugzilla – Issue 106711
Undo wrongly leaves contents after copy 2 adjacent row cells to 2 adjacent column cells
Last modified: 2017-05-20 10:33:56 UTC
When trying to paste a line of values (more than one cell) to multiple cells in the same column with a mix of empty and non-empty cells in the adjacent column, you must confirm to overwrite cells. Once done, if you try to cancel (ctrl-z), only the first column return to previous state and cells in other columns where a value was already present, empty cells keep the value pasted! Easy to do : ------------------ Put 'a' in cell A1 Put 'b' in cell B1 Put 'c' in cell B2 select a1:b1 copy past it to a2:a3 confirm overwrite cancel Cell b:3 is not empty, there is an unwanted 'b' remaining! It affects only empty cells before paste, and only if you try to select multiple line in the same column, if you chose all the cells affected by the paste before pasting, bug is not present. In fact, only the first column return to previous state.
I set priority to one because when working with large arrays of data, you can copy and paste without noticing you leave corrupted data on your file if you cancel your paste. Hope it will help, Nicolas Fairon
NOT reproducible with "Ooo-Dev 3.2.0 multilingual version English UI WIN XP: [OOO320m2 (Build 9432)]"! Same with with "Ooo 3.1.1 WIN XP DE-multilingual version German UI activated [OOO310m19 (Build 9420)]"! Not P1 @nicolas_fairon: Your report is too imprecise! Do not write terms like "paste", but "click on cell 'a1', rightclick, context menu 'paste' (or what ever you want to say)! Before you file further issues or post again here, please read our guidelines on <http://qa.openoffice.org/issue_handling/pre_submission.html> and <http://www.openoffice.org/bugs/bug_writing_guidelines.html>, then contribute a clear step by step instruction containing all observations (error messages ...), _every_key_press_and_every_mouse_click_ how to reproduce the problem, and explain why you believe that your results are unexpected. That means (for example): do not write something like „I am not able to ...“, but „6. left mouse click on … expected: …, color of … changes, … actual: no …., color remains white, no … Screenshots might help to explain the problem. What Linux version from what distribution do you use?
OS: Ubuntu 9.04 x86_64 on Intel Core i7 940 Not reproduced since update to Ubuntu 9.10. Not reproduced with Fedora 11 on same architecture. Here is the corrrected "how to reproduce procedure" ------------------ Write 'a' in cell A1 Write 'b' in cell B1 Write 'c' in cell B2 SELECT A1:B1 with mouse COPY (with Ctrl+C or menu bar "Edit > Copy") PASTE it to A2:A3 (Ctrl+V or menu bar "Edit > Paste") Confirm overwrite CANCEL (Ctrl+Z or menu bar "Edit > Cancel ") Expected : A1: a, B1: b, A2: empty, B2: c, A3: empty, B3: empty Actual : A1: a, B1: b, A2: empty, B2: c, A3: empty, B3: b Cell B:3 is not empty, there is an unwanted 'b' remaining!
I'm not sure if it is possible to change the importance of this issue &/or if it is being addressed, but it still appears to be an issue in 3.3.0 in Windows 7. For instance, in one of my spreadsheets, I have 4 columns of very elaborate formulae. Each row is a copy (subject to appropriate changes in row references) of the previous row. If I was to leave the formulae in place, the document would swell in size a number of times over, often becoming unstable, so I simply leave the top row in place, then copy & paste the formulae when the information is needed. I.e.: - Copy cells I167:L167 - Paste I170:I408 (I170:L408 are blank) - Undo paste I170:I408 return to being blank, but J170:L408 remain filled. While I have become familiar with this, so simply can't use undo in this case, in other comparable situations, the file can end up unusable/corrupted by an unexpected rogue cell(s).
*** Issue 107617 has been marked as a duplicate of this issue. ***
This Issue requires more information ('needmoreinfo'), but has not been updated within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download Please report back the outcome of your testing, so this Issue may be closed or progressed as necessary - otherwise the issue may be Resolved as Invalid in the future.
My particular issue with this doesn't seem to occur in 3.4.1, so I guess it has been resolved in the course of updating OO; don't know if anyone else is still having issues though (?)
I no longer see a problem following the steps in #3 above with AOO 3.4.1 on Fedora 17.
Reproducible with "Ooo 3.1.1 German WIN7 Home Premium (64bit) DE [OOO310m19 (Build 9420)]", here the correct step by step instruction: 1. open attached sample document (created due to reporters instruction) 2. Select A1:A2 using mouse > A1:B1 Highlighted 3. 'Rightclick B1 -> Copy 4. Select A3:A3 using mouse > A2:A3 highlighted 5. 'Rightclick A2 -> Paste (and confirm "overwrite?" if necessary A1:A3 shows "a" B1:B3 shows "b" 6. <control+z> (or undo icon or menu 'Edit -> Undo', does not matter) Expected: contents as after step 1 Actual: additional contents "b" in B3 :-( Additional Info: ---------------- (a) I am pretty sure that I already saw a report for this problem, I am not sure whether in OOo or LibO, but because FIXED in betwen I will not check that. (b) That was ok in OOo 1.1.5 and OOo 2.0.3, so this one seems to be a (very old) regression in OOo 3.x (c1) No longer a problem with AOO 3.4.0 (WIN) (c2) Still reproducible with OOo 3.3.0 (WIN) Has been fixed for AOO 3.4.0, but because of crippled Target Milestone selector contents (Bug 123063) I only can select TM = 4.1.0, no useful information can be left.
Created attachment 81868 [details] Sample Document See comment above how to use