Bug 75316 - FILEOPEN: .xlsx Fails to import chart properly - title axis alignment lost
Summary: FILEOPEN: .xlsx Fails to import chart properly - title axis alignment lost
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version: 4.2.0.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
: 68884 (view as bug list)
Depends on:
Blocks: 75054 75057
  Show dependency treegraph
 
Reported: 2014-02-21 11:14 UTC by Luke
Modified: 2014-12-27 03:04 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Chart showing issue with vertical allignment .xlsx import (11.51 KB, application/vnd.ms-excel.12)
2014-02-21 11:14 UTC, Luke
Details
Recreated the title in 2007 (11.55 KB, application/vnd.ms-excel.12)
2014-02-21 12:24 UTC, Luke
Details

Description Luke 2014-02-21 11:14:41 UTC
Created attachment 94505 [details]
Chart showing issue with vertical allignment .xlsx import

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 title axis of "USD In Hundred Thousands" is not vertically (270 deg) aligned.
Comment 1 Luke 2014-02-21 12:24:59 UTC
Created attachment 94509 [details]
Recreated the title in 2007

I believe this chart was original created in 2003 or 2010. To try to narrow down the issue, I redid the title in Excel 2007. This file opens correctly in LO Calc. Attached is the updated file. If you unzip it and run a diff of \xl\charts\chart1.xml:

-<c:axId val="74228864"/><c:axId val="74230784"/><c:axId val="0"/></c:bar3DChart><c:catAx><c:axId val="74228864"/>
+<c:axId val="44365312"/><c:axId val="48443776"/><c:axId val="0"/></c:bar3DChart><c:catAx><c:axId val="44365312"/>

- <a:bodyPr/>
+ <a:bodyPr vert="horz" rot="-5400000"/>

- <c:crossAx val="74228864"/>
+ <c:crossAx val="44365312"/>

It appears that either 1) vert="horz" rot="-5400000" is coming from somewhere else in the file, or 2) the text box is being shrunk. Any OOXML gurus know what's going on here?
Comment 2 foss 2014-02-27 12:52:29 UTC
Confirmed:4.2.1.1:OSX as well as latest nightly from today -> NEW

Thanks for the report Luke.
Comment 3 Luke 2014-04-01 07:37:30 UTC
The attachment 85112 [details] from Bug 68884 has the same issue with the axis formatting of the Y title.
Comment 4 Luke 2014-04-01 07:41:48 UTC
*** Bug 68884 has been marked as a duplicate of this bug. ***


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.