Bug 60936 - : Copying text adds extra line when pasted into excel
Summary: : Copying text adds extra line when pasted into excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version: 4.0.0.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-02-16 01:23 UTC by Glenn
Modified: 2014-11-24 08:57 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments

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 
1
2
3
4
 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: 4.0.0.3 release
Comment 1 Joel Madero 2013-03-21 19:28:46 UTC
Cannot reproduce with Bodhi Linux on either 3.6.5.2 & 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 (4.0.2.2) 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 4.3.0.1
Word to Excel works fine (2010 versions)
LO to Excel does not
Comment 4 Marc Kaulisch 2014-08-11 11:36:04 UTC
still present in 4.3.1.1
Comment 5 Marc Kaulisch 2014-11-24 08:57:49 UTC
still present in 4.4.0.0.beta1


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.