https://bugs.documentfoundation.org/show_bug.cgi?id=119928
--- Comment #19 from Eike Rathke <[email protected]> --- (In reply to Barry L. Kramer from comment #18) > Does anyone here know how this is handled by different software, such as > Excel or Open Office? I don't have these to compare. OpenOffice doesn't even know line breaks in formulas (as per this bug's summary). For non-formulas like in your GSheet example copy-pasting B3:C5 it does line 1 line A line B line 2 line C line 3 line D line E line F which is about the worst you could get. I don't have Excel. > Just to compare, Google Sheets handles it like this > So any cell with a newline is quoted, and tab or \n marks end of any cell. Which seems to be a regular TSV (tab separated values) export with optional double quotes when needed. Doable if we agree on it, but would change current usage flow and come unexpected. That For one cell containing a newline: "line A line B" would come very unexpected though, because currently the plain text including newline is pasted without any additional quote characters, and I think at least that should be kept. -- You are receiving this mail because: You are the assignee for the bug.
