Bug 75692 - FORMATTING: Spreadsheet line/graph data not copy pasting into LibreOffice draw.
Summary: FORMATTING: Spreadsheet line/graph data not copy pasting into LibreOffice draw.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Drawing (show other bugs)
Version: 4.2.1.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: target:4.4.0 target:4.3.0.1
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-03 03:36 UTC by Mat Fletcher
Modified: 2014-06-07 03:13 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
Screenshot of the copy/paste bug (86.94 KB, image/jpeg)
2014-03-03 03:36 UTC, Mat Fletcher
Details
Excel 2013 Spreadsheet (17.10 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-03-07 05:43 UTC, Mat Fletcher
Details
Excel spreadsheet (17.10 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-03-07 05:47 UTC, Mat Fletcher
Details
Spreadsheet (25.96 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-03-09 22:50 UTC, Mat Fletcher
Details

Description Mat Fletcher 2014-03-03 03:36:41 UTC
Created attachment 94998 [details]
Screenshot of the copy/paste bug

The Graph from excel does not copy/paste correctly into Libreoffice Draw.

It will copy the graph ( x axis & y axis & labels but does not copy/paste the actual graphed data )

Appears to be bug in libreoffice relating how to handle the graphed data from the  clipboard.

Copy / pasting a graph works fine in Open Office, MS Word etc.

I should also note that if you save the document in open office, then open in libreoffice.  The graph shows fine and can be copy/pasted properly.
Comment 1 foss 2014-03-04 10:43:34 UTC
Hi Mat, can you please attach the problematic LO file so this can be reproduced and looked into?

Is this bug still valid / reproducible with the latest LO release?  Currently 4.2.1: http://www.libreoffice.org/download/

Please also try resetting your user profile and let us know if that helps: https://wiki.documentfoundation.org/UserProfile

Should this be still reproducible for you with the latest LO release please set this bug back to UNCONFIRMED. Should this issue be solved set it to WORKSFORME.

Setting to NEEDINFO until more detail is provided.
Comment 2 Mat Fletcher 2014-03-05 04:52:44 UTC
Issue still present.

Downloaded 4.2.1.1  - No change 
Deleted user profile - No change

Same problem exists across multiple computers around the office.
Comment 3 Joel Madero 2014-03-07 03:50:12 UTC
I cannot reproduce this with 4.2.2.1 rc

Ubuntu 13.10
GNOME

Does this happen with every document for you? What is your OS? Please attach a spreadsheet that you're using as well as a draw document that has the messed up chart. 

Marking as NEEDINFO - once you attach and answer questions please mark as UNCONFIRMED.

Thanks
Comment 4 Mat Fletcher 2014-03-07 05:43:51 UTC
Created attachment 95284 [details]
Excel 2013 Spreadsheet

Graph from Excel 2013 does not copy / paste correctly into Libre Office Draw.

Windows 7 (64 Bit)
Excel 2013 ( Home & Business 2013 )
Libre Office 4.2.2.1
Comment 5 Mat Fletcher 2014-03-07 05:47:21 UTC
Created attachment 95287 [details]
Excel spreadsheet
Comment 6 Mat Fletcher 2014-03-07 05:50:05 UTC
Excel spreadsheet attached.  

Windows 7 (64 bit)
Using Excel 2013 

Pasting the graph into a fresh LO Draw file.

If possible, try Excel 2013 to reproduce the issue.
Comment 7 Joel Madero 2014-03-07 06:01:04 UTC
Interesting - I can't even open that file with 4.2.2.1 nor with 4.3 master
Comment 8 Mat Fletcher 2014-03-09 22:50:16 UTC
Created attachment 95477 [details]
Spreadsheet

I've uploaded another sample that opens in LO.

The orange line graph does not copy/paste correctly.  The blue/white graph from the same spreadsheet does copy/paste correctly.   

You need to copy the graph from Excel 2013 to the clipboard and paste it into LO to see the issue, yet open office draw works fine.
Comment 9 Jacques Guilleron 2014-03-10 17:48:14 UTC
Hi Mat,

If, in Excel, you save your files as .ods, you can open those files in LO 4.2.2.1.
At least, you have a way to work with thosee files.
Like Joel, I cannot open your xlsx Excel 2013 Spreadsheet, with LO 4.2.2.1 nor with LO 4.3.0.0.alpha0+
Build ID: 7122ef19847b26529ed1d5bad40df869e91a8495
TinderBox: Win-x86@39, Branch:master, Time: 2014-03-06_00:38:21
& Windows 7 Home Premium 
Cannot Copy directly from Excel to Draw, but, surprisingly, if you copy graphs and paste them in Word, you can this time copy correctly to Draw.


I set status to New,

Kind regards,

Jacques
Comment 10 Commit Notification 2014-06-07 02:54:25 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=127b11cbf944d51640c45801693b93ab3b18b14b

make sure all objects exist, related fdo#75692



The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.
Comment 11 Commit Notification 2014-06-07 03:13:17 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-4-3":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=bd096081eb56a70cd6f65e5c957fa73cd5193f1d&h=libreoffice-4-3

make sure all objects exist, related fdo#75692


It will be available in LibreOffice 4.3.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.


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.