Bug 60936 - Writer: Copying text adds extra row when pasted into MS Excel
Summary: Writer: Copying text adds extra row when pasted into MS Excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other Windows (All)
: low minor
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Cut-Copy
  Show dependency treegraph
Reported: 2013-02-16 01:23 UTC by Glenn
Modified: 2019-02-06 16:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Glenn 2013-02-16 01:23:39 UTC
Problem description: 
Test which includes line breaks added with the enter key result in an extra row for each line break when the text is copied and then pasted into excel

Steps to reproduce:
1. type 
 with a standard line break (added with just the enter key) between each numeral
2. select the text and copy

3. paste the text into an excel spreadsheet  

Current behavior:
Excel add an extra row between each of the numerals

Expected behavior:
Expect the text to be in contiguous cells 

Note:  While I accept that Excel may not meet standards for accepting pasted text, it does need noting that this behaviour only occurs with text copied from LibreOffice Text and some html.  I tried  Microsoft Word, Notepad and libreOffice spreadsheet and they function as expected.  
HTML from this website pastes oddly.  If the five lines from the libreoffice documentation page (https://www.libreoffice.org/get-help/documentation/) starting with LibreOffice 3.5 User Guides is copied there is an extra row inserted after the bolded heading line "LibreOffice 3.5 User Guides" and there are no extra rows added between the other four lines of text.  The source for this shows that the first line simply has the Strong attribute applied.  So, while I accept it is probably primarily M$ playing silly games with their excel paste functionality one needs to ask why is libreoffice copied text different to other?
Operating System: Windows 7
Version: release
Comment 1 Joel Madero 2013-03-21 19:28:46 UTC
Cannot reproduce with Bodhi Linux on either & 4.1 master build - must be Windows only
Comment 2 Marc Kaulisch 2013-04-15 19:43:31 UTC
I can reproduce this behaviour with Windows 8 (64bit).
Copy and pasting these lines from Writer ( into Calc works as expected, pasting into MS Excel 2010 (14) (64bit) lines are added as described by bug reporter.
Comment 3 Marc Kaulisch 2014-06-27 10:51:44 UTC
still can reproduce this in
Word to Excel works fine (2010 versions)
LO to Excel does not
Comment 4 Marc Kaulisch 2014-08-11 11:36:04 UTC Comment hidden (obsolete)
Comment 5 Marc Kaulisch 2014-11-24 08:57:49 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2015-12-20 16:12:45 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2017-01-03 19:48:11 UTC Comment hidden (obsolete)
Comment 8 Marc Kaulisch 2017-01-03 20:47:11 UTC
can still be reproduced with 
Version: (x64)
Build-ID: c019706a50de7fcb07d0d528b09b46a887562beb
CPU-Threads: 4; BS-Version: Windows 6.19; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: group

and tested in Excel 2016

and with:
Version: (x64)
Build-ID: a7e30712ad6d8bc9286007b37aa581983e0caba3
CPU-Threads: 4; BS-Version: Windows 6.19; UI-Render: GL; Layout-Engine: neu; 
Gebietsschema: de-DE (de_DE); Calc: group
Comment 9 QA Administrators 2018-07-04 02:49:00 UTC Comment hidden (obsolete)
Comment 10 Timur 2019-02-06 16:08:23 UTC
Repro LO 6.3+. Can be avoided if Paste Special as Text.