Apache OpenOffice (AOO) Bugzilla – Issue 54101
Copy / Paste: the empty cells are not pasted in the last column
Last modified: 2014-04-23 06:08:07 UTC
- Keep the A1 and B1 cells empty (or enter the following formula: ="") - Enter a text or a number in the A2 and B2 cells - Copy A1 and B1 - Select the A2 cell, perform a long click on the "Paste" icon and select the "unformated text" menu. In this case the A2 cell is replaced with an empty cell, but the B2 cell keeps its initial value. Although Issue 5342 seems to the be the same as this bug report, I didn't find the explanation very clear so I decided to open a new issue instead.
Sorry : Issue 5342 -> Issue 53842
Confirmed on Win200, m122
confirmed on W2000 and m125
I checked with 2.0 (1.9.m122) German version WIN 98: [680m122(Build8941)] and also saw the problem.
Hi Niklas, one for you I think. Frank
I reproduced this bug on Linux with Build 2.3.0. Rather than leaving A1 blank, even if you fill in A1 with a number, you still get the similar bug. So simpler set of steps to realize where the bug is would be 1.Fill A1, B1 and B2 with a number 2.copy A1 and B1 3.Select A2 cell and then click the menu part of the paste icon (or long hold) and select unformatted on th menu. You will see A1 being copied over successfully to A2, but not B1 to B2. Even when DIF is selected, only the first one gets copied (DIF and unformatted text are the only ones that don't all act alike). However DIF doesn't have a consistent pattern such as Unformatted pasting. With Unformatted it is always the last empty box. If you repeat the above with 3 cells in each row, one row of 3 empty cells A1, B1, C1 and 3 filled cells A2, B2, C2 with any numbers. Then now A1 and B2 get copied over to A2 and B2 respectively (A2 and B2 are now empty) , however C2 remains the same. I tried this with up 9 cells in each row, and it is always the last one that doesn't go empty in the second row. With DIF, if you are copying a row of empty cells, then only the first one in the second row get emptied. If you really need this for some practical reason, the way to do this is that if you need to copy 3 empty cells to be copied each time, and need unformatted text, select 4 and copy them which will paste only 3 of them.
Still Reproducible with "AOO 4.1.0 RC3 – English UI / German locale [AOO410m17(Build:9763) - Rev. 1586584 2014-04-11 08:56:50]" on German WIN7 Home Premium (64bit)", “historic” 4. User Profile used for all predecessor versions Assignee back to list due to facts