https://bugs.documentfoundation.org/show_bug.cgi?id=142561
Bug ID: 142561
Summary: Editing: Enable unformated text copy of Calc cells
containing line breaks
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: patch.pub...@gmail.com
Description:
Unformatted text copy of a Calc spreadsheet in which some cells contain line
breaks results in the intra-cell line break being replaced by a space. It would
be preferable if Calc used a clipboard format which retained the line break.
In more detail
Calc supports unformated text clipboard paste with cells containing linefeed or
carriage return characters. Quoting is used to prevent intra-cell line breaks
being interpreted as end of row markers.
Calc can save a sheet in Text CSV format with cells containing intra-cell line
breaks. The Field delimiter can be set to {Tab} and String delimiter to “.
Quoting is used to prevent intra-cell line breaks being interpreted as end of
row markers.
In contrast when a clipboard copy is done, instead of using the above Text CSV
format, Calc replaces the intra-cell line breaks with space and does not use
any quoting. Resulting in data corruption when pasting Plane text into
LibreOffice or other applications.
By comparison both Microsoft Excel and Google Sheets preserve intra-cell line
breaks during plan text copy and paste.
Steps to Reproduce:
1. Open a new calc document
2. In a cell type: Hello<shift><enter>World
3. Copy the cell and surrounding
Actual Results:
4. In calc use paste special text only or paste in an application which accepts
only text
Expected Results:
5. Paste result has line feed replaced by <space>
Reproducible: Always
User Profile Reset: No
Additional Info:
6. Ideally libreOffice calc should behave the same as cvs file export format.
When a cell contains a special character such as linefeed, the character should
be retained and quoting added to identify the linefeed is part of the cell
contents rather than starting a new row. This would enable unformated paste of
multi-line cells within LibreOffice and also into third party applications
See also
https://ask.libreoffice.org/en/question/311810/enable-unformated-text-copy-of-calc-cells-containing-line-breaks/
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
