Bug 66379

Summary:	FILEOPEN: MS .xlsx Fails to import properly. Data Missing Err:509 (3/6)
Product:	LibreOffice	Reporter:	Luke <lukebenes>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	medium
Version:	4.1.0.1 rc
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	MS .xlsx file imports incorrectly Comparison of xlsx in Excel vs Calc 1-3

Description Luke 2013-06-29 18:53:18 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 #3 in the screenshot instead of showing the data, there is an err:509

Comment 1 Luke 2013-06-29 19:11:32 UTC

Created attachment 81709 [details]
MS .xlsx file imports incorrectly

Comment 2 Luke 2013-06-29 19:15:02 UTC

Created attachment 81715 [details]
Comparison of xlsx in Excel vs Calc 1-3

Comment 3 Markus Mohrhard 2013-06-29 19:21:21 UTC

Uses the new reference syntax of the Format As Table feature.

*** This bug has been marked as a duplicate of bug 66377 ***