Bug 117436 - Export to Calc: Line break isn't exported through copy and paste from Base to Calc
Summary: Export to Calc: Line break isn't exported through copy and paste from Base to...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste
  Show dependency treegraph
 
Reported: 2018-05-05 07:48 UTC by Robert Großkopf
Modified: 2019-06-18 05:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Copy the table to a new Calc-file. Look for line break in third column. (4.76 KB, application/vnd.oasis.opendocument.database)
2018-05-05 07:48 UTC, Robert Großkopf
Details
Screenshot of paste to Calc via context menu in Base (55.09 KB, image/png)
2018-05-07 07:43 UTC, Alex Thurgood
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2018-05-05 07:48:53 UTC
Created attachment 141901 [details]
Copy the table to a new Calc-file. Look for line break in third column.

Open the attached database.
There is a table with 3 fields. Last field contains linebreaks (LONGVARCHAR needed for this).
Copy the table with right mouseclick.
Paste the content of the table to a new opened Calc-document.
Header of the table will be shown with gray background, content of the third column has no line breaks.

Now drag the table from Base to the opened Calc-document and drop it there.
Header of the table won't be formatted (because it isn't the same wizard working?).
Switch the height of the rows.
Content of the third column will show line breaks, which had been created with Shift + Enter or Ctrl + Enter.

Remark: This is the only way to get line breaks from a whole table to Calc. There isn't any way to get it back from Calc to Base for a whole table, because the wizard wont transport the line breaks.

Have tested all these with LO 6.0.3.2, OpenSUSE 64bit rpm Linux.
Comment 1 Alex Thurgood 2018-05-07 07:05:41 UTC
@Robert : did this ever work previously ?

I don't recall being able to paste line-broken content from Calc to Base in previous versions (using excel sheet as db source), but I'll admit I don't usually line-broken content in db fields anyway.
Comment 2 Alex Thurgood 2018-05-07 07:31:59 UTC
When I do this :

Copy the table with right mouseclick.
Paste the content of the table to a new opened Calc-document.
Header of the table will be shown with gray background, content of the third column has no line breaks.

The data content gets pasted as all underlined, all struck-through - which is clearly incorrect (see screenshot).

In addition, the line breaks are ignored.

So confirming.
Comment 3 Alex Thurgood 2018-05-07 07:32:34 UTC
Tested with

Version: 6.0.3.2
Build ID: 8f48d515416608e3a835360314dac7e47fd0b821
Threads CPU : 4; OS : Mac OS X 10.13.4; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group
Comment 4 Alex Thurgood 2018-05-07 07:33:23 UTC
Pretty certain that the copy table paste table behaviour didn't behave like that in previous versions of LO, so regression.
Comment 5 Alex Thurgood 2018-05-07 07:39:24 UTC
Reproduced in 

Version: 5.4.6.2
Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8
Threads CPU : 4; OS : Mac OS X 10.13.4; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group
Comment 6 Alex Thurgood 2018-05-07 07:42:00 UTC
Reproduced with

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
Threads CPU : 4; Version de l'OS :Mac OS X 10.13.4; UI Render : par défaut; Moteur de mise en page : nouveau; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group
Comment 7 Alex Thurgood 2018-05-07 07:43:38 UTC
Created attachment 141945 [details]
Screenshot of paste to Calc via context menu in Base
Comment 8 Alex Thurgood 2018-05-07 07:44:51 UTC
Reproduced in 

Version: 5.2.7.2
Build ID: 2b7f1e640c46ceb28adf43ee075a6e8b8439ed10
Threads CPU : 4; Version de l'OS :Mac OS X 10.13.4; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group
Comment 9 Alex Thurgood 2018-05-07 09:37:33 UTC
Also reproduced with

Version: 4.4.5.2
Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99
Locale : fr_FR.UTF-8
Comment 10 Alex Thurgood 2018-05-07 09:40:38 UTC
And reproduced with LO4162 - looks like this was there from early on, possibly even in the initial release, therefore no regression ?
Comment 11 Robert Großkopf 2018-05-07 15:13:50 UTC
Same behavior with LO 3.6.7.2. Seems to be inherited from OOo.

Sometimes I don't get content all underlined and struck-through. But this bug is about line-break. 

Interesting: Import to Writer shows the line break ...
Comment 12 Robert Großkopf 2018-05-07 15:20:21 UTC
(In reply to robert from comment #11)

> Sometimes I don't get content all underlined and struck-through. But this
> bug is about line-break. 

Content will be shown without struck-through if I create a query and copy and paste the query to Calc ...
Seems there is something saved for the table which destroys the textformat. But let us first fix the bug with the line breaks.
Comment 13 ge60 2018-05-07 18:36:51 UTC
Can confirm the behavior.

Copy/Paste (context menu) of a Base table to Calc makes multi-line text entries single line, whereas Drag & Drop keeps the line breaks.

LO 6.0.3.2, win10 x64, de-de, Base setting "extended database setting" "Text lines with CR+LF" off

But more important:

Re-Import of the table from Calc to Base works in neither way - not via copy/paste nor drag & drop (like Robert stated before).

Any workaround for this direction?
Comment 14 Julien Nabet 2018-05-16 18:23:07 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.

Remark: in copy-paste right click case, the content is not grayed but underlined and struck-through
Comment 15 Julien Nabet 2018-05-16 18:39:17 UTC
If someone knows where to begin to investigate. I don't know what part of code which deals with copy paste.
Comment 16 Robert Großkopf 2018-06-17 15:29:12 UTC
I will set this one to component "LibreOffice", because it is a bug with copying from one component to another (Base to Calc and back). Hope someone will see this and gives a a hint, which part of code it could be ...
Comment 17 QA Administrators 2019-06-18 02:47:58 UTC Comment hidden (obsolete)
Comment 18 Robert Großkopf 2019-06-18 05:47:04 UTC
Buggy behaviour is still the same in LO 6.2.4.2 on OpenSUSE 15 64bit rpm Linux