<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Copy of cell with multi-line text is pasted as CSV for unformatted text, enclosed in double quotes and with quote escaping (FORMATTING)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113571#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Copy of cell with multi-line text is pasted as CSV for unformatted text, enclosed in double quotes and with quote escaping (FORMATTING)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113571">bug 113571</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>So apparently this is related to the fix for <a class="bz_bug_link bz_status_CLOSED bz_closed" title="CLOSED FIXED - [EDITING]: Paste Unformatted Text broken for complex cell contents" href="show_bug.cgi?id=32213">bug 32213</a> where <a href="https://cgit.freedesktop.org/libreoffice/calc/commit/?id=cdcd262ea4aa3c3e407b14ed533e514f75de2d3a">https://cgit.freedesktop.org/libreoffice/calc/commit/?id=cdcd262ea4aa3c3e407b14ed533e514f75de2d3a</a> in ScTransferObj::GetData() constructs the ScExportTextOptions with mbAddQuotes=true to maintain line breaks and proper cell distribution. That is some internal "unformatted (but CSV-like)" text and probably the reason that MS-Office does it similar. You can't have both behaviour in one format. The only solution is to offer two text variants to the clipboard and/or, depending on the consumer, generate one or the other, if that is possible. The problem here is that for non-in-cell paste the existing quoted format is needed, but for in-cell or external unformatted paste the non-quoted format is needed.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>