[Libreoffice-bugs] [Bug 143005] New: New line (LF) are lost when pasting text into Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143005
           Summary: New line (LF) are lost when pasting text into Calc
           Product: LibreOffice
           Version: 7.1.4.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: silvain-dupertuis at bluewin.ch

Description:
Pasting text into Calc does not preserve end of lines ([LF] = newline = \n)
=============================================================================
Calc is the ideal way to export/import data between Base and other databases
but newline characters in long text fields are all lost when exporting from a
table or a query. I have imported Data from Access databases with no problem
except for these [LF] characters in Memo fields lost in the target Base table.
===
It seams to be a problem of calc.
- [LF] can appear in a cell, and can be copied-pasted from Calc to Base or
Writer (in this last case, it becomes an end of paragraph).
- But it is lost when pasting into calc (whatever the source, external or
another calc cell) 

Steps to Reproduce:
1. Create text with a newline (for exemple in Writer)
2. Copy-paste into a Calc cell
3.

Actual Results:
Newline lost
Example:
Nickname=Bob A very tall guy

Expected Results:
Newline should be there
Example:
Nickname=Bob
A very tall guy


Reproducible: Always


User Profile Reset: No



Additional Info:
This is an old problem which I never see mentioned anywhere-
I am working with Linux (Ubuntu), but I also have a Windows installation, and I
did not check if it is the same in Windows.

-- 
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/20210623/6b26179b/attachment.htm>