Issue 106711 - Undo wrongly leaves contents after copy 2 adjacent row cells to 2 adjacent column cells
Summary: Undo wrongly leaves contents after copy 2 adjacent row cells to 2 adjacent co...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1.1
Hardware: PC (x86_64) All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 107617 (view as issue list)
Depends on:
Reported: 2009-11-08 19:58 UTC by nicolas_fairon
Modified: 2017-05-20 10:33 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sample Document (6.67 KB, application/vnd.sun.xml.calc)
2013-11-03 08:12 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description nicolas_fairon 2009-11-08 19:58:12 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
past it to a2:a3
confirm overwrite
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.
Comment 1 nicolas_fairon 2009-11-08 20:01:57 UTC
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
Comment 2 Rainer Bielefeld 2009-11-11 05:03:20 UTC
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

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
<> and  
<>, 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?
Comment 3 nicolas_fairon 2009-11-16 10:19:00 UTC
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!

Comment 4 professor_frink 2012-04-19 02:17:07 UTC
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).
Comment 5 Joe Smith 2012-04-19 11:10:56 UTC
*** Issue 107617 has been marked as a duplicate of this issue. ***
Comment 6 Rob Weir 2013-02-02 03:00:18 UTC
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

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
Comment 7 professor_frink 2013-02-02 17:52:18 UTC
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 (?)
Comment 8 Joe Smith 2013-02-03 02:03:16 UTC
I no longer see a problem following the steps in #3 above with AOO 3.4.1 on Fedora 17.
Comment 9 Rainer Bielefeld 2013-11-03 08:11:25 UTC
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.
Comment 10 Rainer Bielefeld 2013-11-03 08:12:13 UTC
Created attachment 81868 [details]
Sample Document

See comment above how to use