Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index


Unformatted text copy of a Calc spreadsheet in which some cells contain line
breaks results in the intra-cell line break being replaced by a space. It
would be preferable if Calc used a clipboard format which retained the line
break.

Where is the best place to make this suggestion?


*In more detail*
Calc supports unformated text clipboard paste with cells containing linefeed
or carriage return characters. Quoting is used to prevent intra-cell line
breaks being interpreted as end of row markers.

Calc can save a sheet in Text CSV format with cells containing intra-cell
line breaks. The Field delimiter can be set to {Tab} and String delimiter to
“. Quoting is used to prevent intra-cell line breaks being interpreted as
end of row markers.

In contrast when a clipboard copy is done, instead of using the above Text
CSV format, Calc replaces the intra-cell line breaks with space and does not
use any quoting. Resulting in data corruption when pasting Plane text into
LibreOffice or other applications.

By comparison both Microsoft Excel and Google Sheets preserve intra-cell
line breaks during plan text copy and paste.



--
Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.