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
Created attachment 81709 [details]
MS .xlsx file imports incorrectly
Created attachment 81715 [details]
Comparison of xlsx in Excel vs Calc 1-3
Uses the new reference syntax of the Format As Table feature.
*** This bug has been marked as a duplicate of bug 66377 ***