Created attachment 94174 [details] Sample class list -- short spreadsheet This simple spreadsheet is just a list of students in a class along with email addresses. It displays correctly in Excel. It 's display in LO is useless. I'm running LO 4.2.0.4 under Windows 8. It was created in Excel by another user. I don't know the version.
Hmm, kind of a vague description. But I compared to spreadsheet function in MS Office Excel 2010 Styles differ a bit obviously (it is not MS Excel) but fidelity of the LibreOffice .XLSX import is good. I'm simply not seeing any issue with 4.2.0.4 or 4.2.1.1 or current builds of LibreOffice master. Style issues aside, all formatting works correctly, was there something other than the Hyperlink formatting incorrectly assigned to the phone number cells? Those of course can be cleared from the <F11> Styles and Formatting panel. Setting resolved worksforme, but please reopen if you have additional specifics of what you define as 'useless'. On a side note, the uploaded class roster is now publicly available, please be mindful of privacy issues when submitting sample documents.