Apache OpenOffice (AOO) Bugzilla – Issue 94015
Bug when pasting from/into cells
Last modified: 2013-01-29 21:47:43 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.
Between steps 5 and 7 also try typing in order to see some odd results.
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."
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 longer. I have used OOo3.0 on WinXP.
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.
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: [680m17(Build9310)]". 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).