Issue 94015 - Bug when pasting from/into cells
Summary: Bug when pasting from/into cells
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.0.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-09-18 07:56 UTC by sharkd
Modified: 2013-01-29 21:47 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description sharkd 2008-09-18 07:56:58 UTC
I'm not sure which version of the Spreadsheet app this applies to, but I am 
updated to the latest 2.4.1 version of OpenOffice.

1. Create a cell containing the text, "First cell."
2. Create a cell containing the text, "Second cell."
3. Select the first cell and press CTRL+C to copy it.
4. Select the second cell and in the Input Line move the blinking cursor in 
between "Second" and "cell".
5. Paste from the clipboard using CTRL+V.
6. In the Input Line notice how there's an extra space after the text you just 
pasted. Press BACKSPACE to delete this extra space.
7. Press ENTER to finish the operation.
8. Notice how some characters from Cell #2 original contents are now missing or 
garbled. Sometimes a character is deleted or shifted to the far right of the 
pasted content.

This problem is very annoying as it forces me to go back and correct each cell 
for mistakes.
Comment 1 sharkd 2008-09-18 07:58:42 UTC
Between steps 5 and 7 also try typing in order to see some odd results.
Comment 2 sharkd 2008-09-18 08:00:49 UTC
Ooops. Also change Step #8 to:

"Notice how some characters from Cell #2's original contents are now missing or 
garbled. Sometimes a character is deleted or shifted to the far *left* of the 
pasted content."
Comment 3 Regina Henschel 2008-11-15 20:13:48 UTC
I can see the bytes 0D 0A as last entry in the clipboard. They might cause that
in the Input line a "space" is shown. But I do not see a real bug here, you must
not delete this "space" and there will be no problems. Look into the cell
itself, and you can see, the actual content is as it should be. If you leave and
reenter the Input line, you will notice that there is no additional "space" any

I have used OOo3.0 on WinXP.
Comment 4 Regina Henschel 2008-11-15 20:46:01 UTC
While editing, the input line does not show the same as the cell itself, if
content is pasted into the input line, that includes tabs or line end. If OOo
drops something or exchanges something for pasted content, it should be shown in
the input line in the same way as in the cell.
I do not know, whether this will be affected by the patch in issue 35913.
Comment 5 Rainer Bielefeld 2008-11-22 11:00:30 UTC
Modified Version due to report.

I checked with "1.1.4 (German) WIN XP: [645m52 (Build 8824)]" and can confirm
the reported effect.

Additions to report:
3. Means simply: clock on cell
4. Means: first click on cell, then click into input pane directly in front of "C"

Also reproducible with "2.4.1  Multilingual version German UI WIN XP:

Also reproducible with "Ooo 3.0.0 RC3 Multilingual version German UI WIN XP:
[OOO300m8 (Build9357)]"

We had an other issue concerning different view or contents in cell and Input
Pane (and I am pretty sure that issue 94015 is a DUP of that one), but I can't
remember where.  Issue 35913 seems to handle a very similar (or the same) problem.

During my tests I saw that I deleted a blank in the input pane, but the
resultwas that I deleted d "C" after the caret position, and that is something
completely unexpeced.

If you Mark both cells in Step 3, you will also see the unexpected blank, but
now everything will work as expected ion the further steps (with 3.0).