Bug 75063 - Format difference in LO and Excel
Summary: Format difference in LO and Excel
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.2.1.1 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-16 20:30 UTC by myecommerce01
Modified: 2015-01-24 13:20 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Sample class list -- short spreadsheet (12.41 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-02-16 20:30 UTC, myecommerce01
Details

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.