Bug 63114

Summary: XLSX import: Diagram invisible
Product: LibreOffice Reporter: bugfinderx
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED    
Severity: major CC: ilmari.lauhakangas, jorendc, markus.mohrhard
Priority: medium    
Version: 4.0.2.2 release   
Hardware: All   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=67436
Whiteboard: target:4.2.0 target:4.1.0.0.beta2 target:4.3.0
Crash report or crash signature: Regression By:
Attachments: ods, xls and xlsx-files
xls-exported from ods with LO 4.0.2
xlsx-exported from ods with LO 4.0.2
xlsx-exported from xls with SoftMaker Office 2012 (the xls was exported from ods with LO 4.0.2)

Description bugfinderx 2013-04-04 12:09:32 UTC
I opend a XLSX-file exported with LO 4.0.0. in LO 4.0.0 and higher.

In the orginal ods was an diagram (Ringdiagramm), which was missing wehn in opend the exported xlsx in LO 4.0.0 or highter. The diagramm is not visible, but the legend ist correct. the border of the diagramm is exitent, you can click it and move ist, but in doest show the diagramm-graphic.

If i open the same xlsx-file in OpenOffice 3.4.1, LibreOffice 3.6.4 or SoftMaker Office 2012, the diagram is correct shown.

I also created a XLSX-file with Softmaker Office 2012 (ods to xls with LO 4.0.0, xls to xlsx with Softmaker Office 2012).
OpenOffice 3.4.1, LO 3.6.4 and Softmaker Office 2012 display the diagramm correct, but in LO 4.0.0 and higher the diagram invisbile too.


(In exported xls-files the diagram is correct shown in LO 4.0.0, ist just a problem with xlsx-files)


TestSystem: Windows 7, XP, Debian-Linux 6.0 (i368)

Office: LibreOffice 4.0.0 and higher
Comment 1 bugfinderx 2013-04-04 12:58:02 UTC
Created attachment 77417 [details]
ods, xls and xlsx-files
Comment 2 bugfinderx 2013-04-04 12:58:51 UTC
Created attachment 77418 [details]
xls-exported from ods with LO 4.0.2
Comment 3 bugfinderx 2013-04-04 12:59:37 UTC
Created attachment 77419 [details]
xlsx-exported from ods with LO 4.0.2
Comment 4 bugfinderx 2013-04-04 13:00:44 UTC
Created attachment 77420 [details]
xlsx-exported from xls with SoftMaker Office 2012 (the xls was exported from ods with LO 4.0.2)
Comment 5 Jorendc 2013-04-05 23:27:56 UTC
Thanks for reporting!

I can reproduce this behavior using Mac OSX 10.8.3 with LibreOffice 4.0.2.2. The diagram is gone when you save the ods file to xlsx and reopen it using LibreOffice. Open the xlsx file using Excel (for Mac 2010) shows the diagram in a very ugly way. I think Major Medium is indeed a correct priority for this bug.

Kind regards,
Joren
Comment 6 Commit Notification 2013-05-27 00:28:46 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=54fbbc20b8397a8362f5a0878744c3a082464713

respect element order in OOXML chart export, related fdo#63114



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 7 Commit Notification 2013-05-27 11:14:22 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-4-1":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=7855cd6704c864911d97b73f8c46d712975ec9b5&h=libreoffice-4-1

respect element order in OOXML chart export, related fdo#63114


It will be available in LibreOffice 4.1.

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 8 Markus Mohrhard 2013-05-29 15:42:19 UTC
My current patch only fixes problems with the import into Excel in LO 4.1/master. The remaining problems are import problems as the file can be opened correctly by Excel.
Comment 9 Commit Notification 2014-02-23 05:43:41 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

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

don't write axId for dougnught chart, related fdo#63114



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 10 Joel Madero 2015-05-02 15:43:48 UTC Comment hidden (obsolete)
Comment 11 Buovjaga 2015-06-21 12:21:01 UTC
Donut chart legends go to 1 column instead of 2 and the percentages turn into numbers.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: 3ecef8cedb215e49237a11607197edc91639bfcd
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-06-19_23:16:58
Locale: fi-FI (fi_FI)
Comment 12 Bartosz 2016-08-03 22:56:26 UTC
Closed as the original problem was resolved.

If you noticed any other issue, please create new bug report.