Apache OpenOffice (AOO) Bugzilla – Issue 121713
fields containg line feeds are not surrounded with necessary quotes after copying to clipboard
Last modified: 2017-05-20 08:41:00 UTC
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.
Duplicate report *** This issue has been marked as a duplicate of issue 121714 ***