Bug 66381

Summary: FILEOPEN: MS .xlsx Fails to import properly. chart not displayed (5/6)
Product: LibreOffice Reporter: Luke <lukebenes>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: jalojo
Priority: medium    
Version: 4.1.0.1 rc   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=65765
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: MS .xlsx file imports incorrectly
Comparison of xlsx in Excel vs Calc 5-6

Description Luke 2013-06-29 19:06:19 UTC
This bug was tested LibreOffice v4.1 RC1 running in windows 7 and XP. It appears that LibreOffice 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 item #6 in the screenshot that the chart is not displayed
Comment 1 Luke 2013-06-29 19:12:18 UTC
Created attachment 81711 [details]
MS .xlsx file imports incorrectly
Comment 2 Luke 2013-06-29 19:17:43 UTC
Created attachment 81718 [details]
Comparison of xlsx in Excel vs Calc 5-6
Comment 3 Jacques Guilleron 2013-07-01 13:47:29 UTC
Hi Luke,

This is a natural consequence of error 509 in column I for the not still implemented Table function.

Jacques
Comment 4 Jacques Guilleron 2013-07-02 18:45:40 UTC
Just close this report as Not a bug.

Jacques