Bug 75063

Summary: Format difference in LO and Excel
Product: LibreOffice Reporter: myecommerce01
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME QA Contact:
Severity: normal    
Priority: medium CC: vstuart.foote
Version: 4.2.1.1 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: Sample class list -- short spreadsheet

Description myecommerce01 2014-02-16 20:30:25 UTC
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.
Comment 1 V Stuart Foote 2014-02-19 05:58:29 UTC
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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.