Bug 63114

Summary: XLSX import: Diagram invisible
Product: LibreOffice Reporter: bugfinderx
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium CC: jorendc, markus.mohrhard
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
i915 platform: i915 features:
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.

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.