Bug 138114 - End-of-lines lost when copying between Calc and Base tables
Summary: End-of-lines lost when copying between Calc and Base tables
Status: RESOLVED DUPLICATE of bug 117436
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-10 15:10 UTC by Silvain Dupertuis
Modified: 2023-06-16 14:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Silvain Dupertuis 2020-11-10 15:10:43 UTC 
Description:
When copying data from a Base table with multiline date into a Calc sreadsheet, end-of-lines are lost and the multiple lines are stuck together.
The same happens the other way roung.
Nevertheless, when copying Base data into a texte document, end-of-lines are preserved.
It is a bit annoying as Calc is the easiest way to export/import data between different databases.
I am presently on Ubuntu 18.04 and LO 7.0.2.2, but this limitation seems to be general (indendent of version/OS) and I have observed it for years.

Steps to Reproduce:
1. Have a table with mutliline data
2. Copy/past table or a related query into a Calc spreadsheet


Actual Results:
Multiple lines are stuck into one line in the pasted data

Expected Results:
End-of-lines should be preserved


Reproducible: Always


User Profile Reset: No



Additional Info:
End-of-lines should be preserved
Comment 1 frofa 2020-11-11 04:19:32 UTC 
Using the PASTE SPECIAL (under the Edit>Paste Special menu) seems to respect the line breaks in a text (VARCHAR) field when copying from a BASE FORM into CALC. (Multiple Calc ROWS are created in the COLUMN of the pasted-cell.)
Comment 2 Robert Großkopf 2021-07-13 19:03:11 UTC 
(In reply to frofa from comment #1)
> Using the PASTE SPECIAL (under the Edit>Paste Special menu) seems to respect
> the line breaks in a text (VARCHAR) field when copying from a BASE FORM into
> CALC. (Multiple Calc ROWS are created in the COLUMN of the pasted-cell.)

Do I see right? Should we close this bug as WORKSFORME?
Comment 3 Silvain Dupertuis 2021-07-13 19:25:23 UTC 
My MAIN problem is data transfer between Base tables or queries and other databases using Calc - which, apart from this problem, is very efficient and handy.

When copying a table/query containing a multiline field to paste the data into a Calc spreadsheet, the line breaks in the multiline field are lost.

Paste special is no solution to this situation
Comment 4 Robert Großkopf 2023-06-16 14:00:02 UTC 
Copying data from Base to Calc with linebreaks is already reported: See https://bugs.documentfoundation.org/show_bug.cgi?id=117436

If there is also a bug from copying content form Calc to Base this should be reported in another bug.

I will close this one as a duplicate.

*** This bug has been marked as a duplicate of bug 117463 ***
Comment 5 Robert Großkopf 2023-06-16 14:00:26 UTC 

*** This bug has been marked as a duplicate of bug 117436 ***