Issue 122891 - MSO .xlsx fails to import properly: Rows not colored, Missing Border, and Data Missing Err:509
Summary: MSO .xlsx fails to import properly: Rows not colored, Missing Border, and Dat...
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:30 UTC by slacka
Modified: 2013-08-09 14:02 UTC (History)
2 users (show)

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

Attachments
Comparison of xlsx doc in Excel vs Calc 2 (540.58 KB, image/png)
2013-07-30 07:31 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:30:51 UTC 
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 attachment 81201 [details] Demo-2012SummerOlympics.xlsx document in calc
2. Open attachment 81201 [details] Demo-2012SummerOlympics.xlsx document in Excel2010/Office 365
3. Compare the documents. 

From the attached screenshot, please note: Item #1 from the screenshot that the rows should alternate from white to blue. Item #2 in the screenshot that the border is missing from the row. Item #3 in the screenshot instead of showing the data, there is an err:509  

I believe these 3 are all using Excel's Format As Table feature.
Comment 1 slacka 2013-07-30 07:31:27 UTC 
Created attachment 81203 [details]
Comparison of xlsx doc in Excel vs Calc 2
Comment 2 Edwin Sharp 2013-07-30 09:32:04 UTC 
Confirmed with Excel 2007 and Calc Rev. 1507307 Win 7.
Comment 3 Oliver-Rainer Wittmann 2013-08-09 14:02:08 UTC 
also reproduced in OOo 3.3.0 -> adjusting field Version accordingly