Bug 93001 - Libreoffice can't show diagram in xlsx file
Summary: Libreoffice can't show diagram in xlsx file
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.0.0.4 rc
Hardware: x86-64 (AMD64) All
: high critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-07-29 14:59 UTC by bazilio
Modified: 2016-06-14 11:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
xlsx file containing diagram (139.17 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-07-29 14:59 UTC, bazilio
Details
original file from ms office (197.94 KB, application/zip)
2015-07-30 17:50 UTC, bazilio
Details
xlsx saved as ods (150.49 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-07-30 17:50 UTC, bazilio
Details
Fresh test file (243.29 KB, application/zip)
2016-06-14 11:27 UTC, bazilio
Details

Note You need to log in before you can comment on or make changes to this bug.
Description bazilio 2015-07-29 14:59:38 UTC
Created attachment 117516 [details]
xlsx file containing diagram

I have xlsx file created in MS Office.
In this file contains a diagram.

In Ms office all works well.

LibreOffice can't show this diagram. Both in 4.3/4.3 and 5.0
Comment 1 raal 2015-07-29 16:17:15 UTC
Hello, where is the diagram? I doesn't see it in excel 2010.
Comment 2 Maxim Monastirsky 2015-07-29 17:07:45 UTC
Hi,

Looking inside this xlsx file reveals that it was last edited by LibreOffice, and there is no chart inside at all. Could you please attach the original file that was created by MS Office?

Setting to NEEDINFO until a test file is provided.
Comment 3 bazilio 2015-07-30 17:50:26 UTC
Created attachment 117540 [details]
original file from ms office
Comment 4 bazilio 2015-07-30 17:50:52 UTC
Created attachment 117541 [details]
xlsx saved as ods
Comment 5 raal 2015-07-30 18:55:36 UTC
Reproducible with Version: 5.1.0.0.alpha1+
Build ID: 74d4168f8830f7bbec6b784c3fb774296d9adafa
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-07-22_06:14:00
Comment 6 bazilio 2015-08-04 12:49:58 UTC
Any suggestions about of time to fix this error?
Comment 7 Libomark 2015-08-15 11:21:48 UTC
There appear to be a whole series of bugs related to inability to save and/or read back chart parameters correctly, as if the incorrect subroutine for saving/reading has been incorporated into the LO builds, with parameters not being passed to/from the main chart routines when saving/opening files.  In some cases, parameters get lost when merely editing a chart element such as a legend (change its position by dragging it and then change formatting to provide a filled box, and its position is lost, as if the position has been overwritten with a default.  Correct the position and save the file, and the position is lost again on opening the file).

I suspect there needs to be a project to investigate the whole series of related bugs, rather than treating them piecemeal and ignoring them as low priority.
Comment 8 Bartosz 2016-06-13 00:46:56 UTC
On Libreoffice 5.1.3.2, the charts are displayed correctly.

I tested it on Ubuntu 16.04
Comment 9 bazilio 2016-06-14 11:26:32 UTC
I tried in 5.1.3.2 (x64) windows
ID 644e4637d1d8544fd9f56425bd6cec110e49301b

Nothing has changed. 
Diagram invisible
Comment 10 bazilio 2016-06-14 11:27:32 UTC
Created attachment 125648 [details]
Fresh test file