https://bugs.documentfoundation.org/show_bug.cgi?id=119928
--- Comment #20 from Barry L. Kramer <[email protected]> --- I agree it is important to not do anything unexpected. And certainly the way it is now without the quoting is good if someone wants it more human readable. Others may want or need the multi-line cells always quoted (even if only one cell is copied, such as an address like I'm using). Perhaps this is an example of where it could be configurable with the default setting giving the same behavior as now. If something like a checkbox "Always quote multi-line cells" was in Tools - Options - LibreOffice Calc - Compatibility, then that could work? Maybe in a new section for Interoperability? Alternatively (see attached mock-up), a pull-down list "Copy cells externally" {Default | Quote multi-line cells | Quote all copied cells"? The latter would give user the choice of the current method, or the way Google Sheets (and probably excel) do it, or a method where all data is quoted. An additional checkbox (defaulted off) "Also apply to single cell copy" could control the behavior to quote single multiline cells, so the copy gives consistent results no matter how many or how few cells are copied. Just some ideas. -- You are receiving this mail because: You are the assignee for the bug.
