https://issues.apache.org/ooo/show_bug.cgi?id=121714
--- Comment #5 from Max Wildgrube <[email protected]> --- (In reply to comment #0) > Hi, > I have a sheet with multiple lines in cells (you can separate lines inside a > cell with ctrl-enter). I had to copy the complete sheet with ctrl-a ctrl-c > into the clipbord and paste this in a textarea field of a web browser. > (in the background there is a PHP application using fgetcsv for to > interprete the content) > > But while clipping as text the necessary quotes (") are not surrounded the > text fields which contain new-line characters. So these new-line chars > produces new rows, destroying the structure of the table. > > This is in opposite to the behaviour of MS Excel or LibreOffice Calc which > works correctly. > There is a workaround while using save as csv file, which asks for the > column and text delimiter. > (And making the copy and paste out off this file) > > Not using a text delimiter if there are syntactical characters (as tab or > new line) is not meaningful, so I think this is obviously a bug. > > OS: Win 7, OOo: 3.4.1 > > Max. 1. In an empty Calc sheet put in cell A1 an "A" and in B1 "B" CTRL-ENTER "C" (Without the ") 2. Select the Cells A1 and B1, copy the selection into the Clipboard (CTRL-C) 3. Open your favorite Text Editor (e.g. Notepad) 4. Paste the Clipboard (CTRL-V). What you see is: A B C 5. Select all (CTRL-A) and Copy back (CTRL-C) 6. Go back to the sheet and select e.g. cell A3, Paste Clipboard. 7. What you see is: A3 = A, B3=B, A4=C and NOT A3 = A, B3=B C as expected. 8. As an counter example you can paste the clipboard after step 2 into an Excel sheet, do the step 2 in Excel now. Step 4 shows you: A "B C" ,in a non-Notepad editor. In Notepad is looks like A "BC" the CR between B and C is only hidden but present. if you repeat step 5 and 6 (Excel) you see the expected result. Max. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
