[Libreoffice-bugs] [Bug 57474] Copy-paste of multiline cells to external text editor inconsistent

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=57474

--- Comment #9 from JMM <sub2015 at eligeotravez.net> ---
(Note: I'm making this comment because this is just another of the thousands of
forgotten btanb)

I don't think this is a bug, it's rather a feature that it's wanted or not. The
pasted text is enclosed in double quotes if it contains a new line. It's the
way Calc makes the text looks like 'it starts here' and 'it ends here'.

As for why the text can't be reconstructed back to spreadsheet uniquely, as in
the example where two different cell contents paste as two equal texts, well
text lines are not cells. If that feature would be needed, then every
extraneous character (newline, tab, etc.) should be escaped when pasting as
text e.g. with \n \t etc. and then unscaped when pasting text back into Calc.
That could be a feature request, but certainly this is not a bug. Basically my
opinion is that wanting that pasting cells as text should be always reversible
is more complex than it seems, due to the implications of my earlier statement:
text lines are not cells. Changing Calc to paste cell content being reversible
might make the pasted text unusable for most uses imho.

Personally I want Calc to paste newlines as newlines in my text editor; getting
rid of the double quotes is an unwanted side-effect but I understand the need
of r them. A few times I wanted Calc to escape those special chars, but nothing
that a little editing or formula mangling can't do.

If anyone with experience in these things shares my view, change status to
resolved.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170506/ff1ed990/attachment.html>