https://bugs.freedesktop.org/show_bug.cgi?id=57474
Priority: medium
Bug ID: 57474
Assignee: [email protected]
Summary: Copy-paste of multiline cells to external text editor
inconsistent
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.0.0.0.alpha0+ Master
Component: Spreadsheet
Product: LibreOffice
To reproduce:
---
1. Create a new spreadsheet
2. Make A1 a multiline cell with hard breaks (eg: 'abc<ctrl-enter>def')
3. Make A2 a single line cell (eg: 'ghi')
4. Copy A1 and A2 together
5. Paste contents across to an external text-only editor (like Geany)
Contents for the above example will paste across as:
"abc
Def"
ghi
Note that the multiline cell has been wrapped in double-quotes.
If the multiline cell contents contain a double quote, it ends up escaping by
doubling up the quotes.
ie: abc"def becomes abc""def on copy.
What should happen (in my opinion)
---
All text should paste across exactly as if the contents were copied directly,
with no wrapping quotes (or double-up escaping). ie: the example shoudl paste
across as:
abc
Def
ghi
Previous versions of Calc did precisely this. Excel also does this.
In case this multiline-quote-enclosing/escaping was introduced as a feature to
try and make it clear in the pure-text paste where individual cells/rows are
delimited... this does not work and causes more confusion than without it.
Consider the case where a single line cell has a leading double quote in it.
This double quote is NOT escaped, so you cannot parse the pasted pure text
contents to determine with certainty what the cell delimiting was.
It should paste across as pure text. No wrapping quotes or escapes. If there
is a convincing argument for some other pasting scheme, it should at least be a
configurable option.
This issue exists in 3.5.4, as well as the master as of Nov 21, 2011
(1c31558e9739ea6cf0cfa58d5cbda8d808eb0527) - thanks to shm_get for confirming
this.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
