Apache OpenOffice (AOO) Bugzilla – Issue 64060
Undo When Editing Cell Does not Undo Pasted Formatting
Last modified: 2013-08-07 15:12:27 UTC
Step to reproduce: 1. Copy some text to the clipboard that has font and/or color formatting e.g. I copied some text from a source code editor that had green color and Courior font. 2. Begin typing in a Calc cell. 3. Use CTRL-V to paste in the formatted text from the clipboard. 4. Use CTRL-Z to undo the paste. 5. Continue typing. In step 5 you will notice that the font settings of the material on the clipboard have been preserved i.e. when you keep typing now it will be in the font of the material on the clipboard. This should not happen because you use Undo to undo the paste and this should have reset the font settings for the cell.
confirmed with 680_m162 on WinXP Pro SP2
Hi Niklas, one for you ? Frank
EditEngine.
Using Windows XP, Using OOo 2.1, The problem is originally reported in version 2.0.2. It persists in version 2.1. This issue was perfectly reproduced. The steps above were followed in order to duplicate the issue. Step 1 was followed in OpenOffice Writer. Step 2 onwards were followed on OpenOffice Calc. This issue was tested with different font type, font size, text colour, bold or unbold. The same issue results in all cases. A work-around for the bug is pressing CTRL-Z twice. This however, works in few cases and not all. A very unstable behaviour was observed in doing so. It is as follows: In all the following cases, step number 1 above(in the original comment) is done first. --> Case 1: A word is typed all in lower case. A space is inserted after it. The first letter of the word is automatically capitalized. The copied text is then pasted using CTRL-V. CTRL-Z is presses once for undoing what paste, and pressed for the second time to work-around the bug. When pressed for the second time, the automatic change of lower case to upper case of the first letter of the word id undone. Anything typed after that is just in the same format of the original text which was being typed. In this case, if the writer did not want the first letter of the word to be in upper case, the text he was typing is not changed at all and he can continue typing in the same format (even though something in other formats was pasted and the paste was undone afterwards). --> Case 2: A word is typed. The first letter of it is typed in upper case and the rest are typed in lower case. A space is inserted after it. The copied text is then pasted using CTRL-V. CTRL-Z is presses once for undoing the paste and pressed for the second time to work-around the bug. When pressed for the second time, the space inserted is removed. To continue typing, the writer has to insert a space again and continue writing. However, what he types will be in the same format he was originally typing, which is the desired outcome. --> Case 3: A word is typed. It does not matter if the first letter is lower or upper case. There is no space inserted. The copied text is pasted and CTRL-Z is pressed once, to undo the paste, and it is pressed for the second time to work-around the bug. In this case however, the original word typed is removed completely and has to be retyped by the writer. --> Case 4: An interesting behaviour is when a word is being typed in a column that had already some words typed in the previous cells. If the word being typed starts similarly to any one of the words above, the previous word is automatically suggested (by appearing in black highlight). No space is inserted after what was typed. The copied text is pasted. The paste is undone by pressing CTRL-Z once. The second time CTRL-Z is pressed, the original word will change to the word that was suggested automatically; meaning the word typed will change to the similar word that existed in the cells above in that row. In all the cases above, pressing CTRL-Z twice resulted in weird and unstable behaviours that could not be duplicated again. For instance, few times it happened that the second time CTRL-Z was pressed, nothing happened; no space was deleted (if there was any space), nothing was changed to the suggested words, or nothing was changed at all. This is the ideal case to work-around this bug, but unfortunately it could not easily be reproduced.
Using Windows XP, Using OOo 2.1, The problem is originally reported in version 2.0.2. It persists in version 2.1. This issue was perfectly reproduced. The steps above were followed in order to duplicate the issue. Step 1 was followed in OpenOffice Writer. Step 2 onwards were followed on OpenOffice Calc. This issue was tested with different font type, font size, text colour, bold or unbold. The same issue results in all cases. A work-around for the bug is pressing CTRL-Z twice. This however, works in few cases and not all. A very unstable behaviour was observed in doing so. It is as follows: In all the following cases, step number 1 above(in the original comment) is done first. - Case 1: A word is typed all in lower case. A space is inserted after it. The first letter of the word is automatically capitalized. The copied text is then pasted using CTRL-V. CTRL-Z is presses once for undoing what paste, and pressed for the second time to work-around the bug. When pressed for the second time, the automatic change of lower case to upper case of the first letter of the word id undone. Anything typed after that is just in the same format of the original text which was being typed. In this case, if the writer did not want the first letter of the word to be in upper case, the text he was typing is not changed at all and he can continue typing in the same format (even though something in other formats was pasted and the paste was undone afterwards). - Case 2: A word is typed. The first letter of it is typed in upper case and the rest are typed in lower case. A space is inserted after it. The copied text is then pasted using CTRL-V. CTRL-Z is presses once for undoing the paste and pressed for the second time to work-around the bug. When pressed for the second time, the space inserted is removed. To continue typing, the writer has to insert a space again and continue writing. However, what he types will be in the same format he was originally typing, which is the desired outcome. - Case 3: A word is typed. It does not matter if the first letter is lower or upper case. There is no space inserted. The copied text is pasted and CTRL-Z is pressed once, to undo the paste, and it is pressed for the second time to work-around the bug. In this case however, the original word typed is removed completely and has to be retyped by the writer. - Case 4: An interesting behaviour is when a word is being typed in a column that had already some words typed in the previous cells. If the word being typed starts similarly to any one of the words above, the previous word is automatically suggested (by appearing in black highlight). No space is inserted after what was typed. The copied text is pasted. The paste is undone by pressing CTRL-Z once. The second time CTRL-Z is pressed, the original word will change to the word that was suggested automatically; meaning the word typed will change to the similar word that existed in the cells above in that row. In all the cases above, pressing CTRL-Z twice resulted in weird and unstable behaviours that could not be duplicated again. For instance, few times it happened that the second time CTRL-Z was pressed, nothing happened; no space was deleted (if there was any space), nothing was changed to the suggested words, or nothing was changed at all. This is the ideal case to work-around this bug, but unfortunately it could not easily be reproduced.