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: 2023-02-07 03:24 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.
Comment 11 QA Administrators 2021-02-06 04:08:27 UTC Comment hidden (obsolete)
Comment 12 QA Administrators 2023-02-07 03:24:57 UTC
Dear Glenn,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword

Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team