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 #7 in the screenshot that there is no sort options when you click on a column. If LO is missing this capability, please change to feature request.
Created attachment 81712 [details]
MS .xlsx file imports incorrectly
Created attachment 81719 [details]
Comparison of xlsx in Excel vs Calc 7
I don't reproduce with LO 184.108.40.206.alpha0+
Build ID: ce0383d2950d3b0da2c457c8a406c1229de53571 & Windows 7 Home Premium.
This goal is achieved by previously using Document Converter Wizard.
Can you try it?
Jacques, Sorry I was not clear in my description. In Excel on row 4 of the Data worksheet, there is a drop down menu to filter and sort. LO does not give you these option. SHould this be reopened as a feature request?
Perhaps it's me who was not very clear. Those options are filters (Data > Filter > AutoFilter in LO), but using Table function in Excel, they are automatically added to columns headings, so we don't see always the backward cooking.
The good news is that you can recover those filters by using File > Wizards > Document Converter. This is another way to open MS files. Uncheck Template, give it path for Excel source file, path for save .ods.
Have a nice day,
Yes, using the Wizards > Document Converter instead of File > Open results in the file being properly imported. I was unaware that there was a difference. Shouldn't both methods produce the same results? Is this a bug or by design?
I don't know. Just keep in mind this can differ.