Issue 54101 - Copy / Paste: the empty cells are not pasted in the last column
Summary: Copy / Paste: the empty cells are not pasted in the last column
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 680m125
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2005-09-01 13:01 UTC by
Modified: 2014-04-23 06:08 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description 2005-09-01 13:01:18 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
Comment 1 2005-09-01 13:25:18 UTC
Sorry : Issue 5342 -> Issue 53842
Comment 2 2005-09-01 13:48:16 UTC
Confirmed on Win200, m122
Comment 3 flecher 2005-09-01 22:41:29 UTC
confirmed on W2000 and m125
Comment 4 Rainer Bielefeld 2005-09-03 19:07:38 UTC
I checked with 2.0 (1.9.m122) German version WIN 98: [680m122(Build8941)] and
also saw the problem.
Comment 5 frank 2005-09-13 12:06:47 UTC
Hi Niklas,

one for you I think.

Comment 6 razvizara 2008-02-04 20:14:18 UTC
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. 
Comment 7 Rainer Bielefeld 2014-04-23 06:08:07 UTC
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