https://issues.apache.org/ooo/show_bug.cgi?id=121714
Bug ID: 121714
Issue Type: DEFECT
Summary: fields containg line feeds are not surrounded with
necessary quotes after copying to clipboard
Classification: Application
Product: spreadsheet
Version: AOO 3.4.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: save-export
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
