Summary: | FILEOPEN: .xlsx Fails to import chart properly - First data label of 2nd column is displayed on the bottom | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Luke <lukebenes> |
Component: | Chart | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | jorendc |
Version: | 4.2.0.4 release | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Bug Depends on: | |||
Bug Blocks: | 75054, 75057 | ||
Attachments: |
Chart showing issue with data label
Recreated the data labels in Excel 2007 |
Created attachment 94510 [details] Recreated the data labels in Excel 2007 I believe this chart was original created in Office 2013. To try to narrow down the issue, I redid data label in Excel 2007. This new chart opens correctly in LO Calc. Attached is the updated file. If you unzip it and run a diff of \xl\charts\chart1.xml you’ll see: </a:schemeClr></a:solidFill></c:spPr><c:dLbls><c:dLbl><c:idx val="0"/><c:layout><c:manualLayout><c:x val="0"/><c:y val="1.1990407673860906E-2"/></c:manualLayout></c:layout><c:showVal val="1"/><c:extLst><c:ext uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}" xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart"><c15:layout/></c:ext></c:extLst></c:dLbl><c:dLbl><c:idx val="3"/><c:layout> Are some new OOXML codes confusing the importer? Can any OOXML gurus shed some light on this issue? Reproducible tested Windows 8.1 Version: 4.3.0.0.alpha1+ Build ID: 145f2e970f46a3a3e5456b122d71f17c3abe878f TinderBox: Win-x86@42, Branch:master, Time: 2014-04-26_23:32:36 Kind regards, Joren |
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.
Created attachment 94506 [details] Chart showing issue with data label This bug was tested LibreOffice v4.3 running in windows 7. It appears that LibreOffice loses formatting when importing MS .xlsx files with charts. I have attached an example. Steps to reproduce the bug: 1. Open Demo-Hayden-Management-v2-chart.xlsx document in calc 2. Open Demo-Hayden-Management-v2-chart.xlsx document in Excel 2007/skydrive 3. Compare the documents. Note: The first data label of 2nd column (250) is displayed on the bottom of the chart.