Issue 122890 - Imported MSO .xlsx file does not display Axes and loses formatting
Summary: Imported MSO .xlsx file does not display Axes and loses formatting
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-30 07:08 UTC by slacka
Modified: 2013-08-09 14:01 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Attachments
MSO .xlsx file imports incorrectly (468.90 KB, application/vnd.ms-excel.12)
2013-07-30 07:08 UTC, slacka 		no flags Details
Comparison of xlsx doc in Excel vs Calc 4 (481.81 KB, image/png)
2013-07-30 07:11 UTC, slacka 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description slacka 2013-07-30 07:08:16 UTC 
Created attachment 81201 [details]
MSO .xlsx file imports incorrectly

This bug was tested OpenOffice v4.0 running in windows 7 and XP. It appears that OpenOffice loses formatting when importing MS xlsx files. I have attached an example.

Steps to reproduce the bug:
1. Open attached Demo-2012SummerOlympics.xlsx document in calc
2. Open attached Demo-2012SummerOlympics.xlsx document in Excel2010/Office 365
3. Compare the documents. 

Note the circled chart. The X and Y axes are not displayed.
If you click on the chart -> right click -> Insert/Delete Axes -> Check "X and Y", the Axes will show up. But the X axis label should have a -45 degree alignment.
Comment 1 slacka 2013-07-30 07:11:00 UTC 
Created attachment 81202 [details]
Comparison of xlsx doc in Excel vs Calc 4

Note the missing axes labels.
Comment 2 Edwin Sharp 2013-07-30 09:30:14 UTC 
Confirmed with Excel 2007 and Calc Rev. 1507307 Win 7.
Comment 3 Oliver-Rainer Wittmann 2013-08-09 14:01:03 UTC 
also reproduced in OOo 3.3.0 -> adjusting field Version accordingly