Apache OpenOffice (AOO) Bugzilla – Issue 59123
Paste in a cell a text with double quotes
Last modified: 2017-05-20 11:13:32 UTC
-Open a text editor (Crimson) -Enter this text: "test1"test2 -Select it all -Copy'n Paste in a cell of a spreadsheet, formatted as text (also tested with number) In cell appers only: test1. But if paste in "Input Line" , in cell appears the text correctly: "test1"test2.
Sorry, "single and" shouldn't be in Summary.
changed summary due to comment from poster
Can reproduce with OOo2.0.1rc3 Win98SE. Strange, only pasting inside a Calc cell doesn't work. With Writer, Wordpad, Word... works. Confirming. Hwoarang
Hi Niklas, and another one for you. Frank
Double quote is the text delimiter, and if a cell starts with a quote, the text between the quotes is used. We already have an internal task (108962) and a specification (http://specs.openoffice.org/calc/ease-of-use/Paste_special_for_unformatted_text_in_Calc.sxw) for a change, but with target "later".
Reset assigne to the default "issues@openoffice.apache.org".