Bug 89410 - LibreOffice interpretation of XLSX file's floating point numbers does not match Excel
Summary: LibreOffice interpretation of XLSX file's floating point numbers does not mat...
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: Other All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-16 09:01 UTC by David North
Modified: 2015-02-16 20:16 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Minimal reproduction .xlsx file (7.77 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-02-16 09:02 UTC, David North 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description David North 2015-02-16 09:01:40 UTC 
Open the attached .xlsx file in LibreOffice.

Click on Cell A1.

Expected result: the UI displays -130.98999999999

Reason for expected result: Excel (2007 and up) displays that.

Actual result: the UI displays -130.989999999991

LibreOffice should match Excel's interpretation of the file (or cite evidence from the OOXML standards that Excel is wrong).
Comment 1 David North 2015-02-16 09:02:12 UTC 
Created attachment 113426 [details]
Minimal reproduction .xlsx file
Comment 2 raal 2015-02-16 09:31:06 UTC 
In the xlsx file is value: -130.98999999999069

- <sheetData>
- <row r="1" spans="1:1" x14ac:dyDescent="0.25">
- <c r="A1" s="1">
  <v>-130.98999999999069</v> 
  </c>
  </row>
  </sheetData>

  
LO show:  -130.989999999991
excel_:   -130,98999999999

I see no bug here.

LO 4.4.0.3, excel2010, win7
Comment 3 David North 2015-02-16 09:34:41 UTC 
(In reply to raal from comment #2)

> LO show:  -130.989999999991
> excel_:   -130,98999999999
> 
> I see no bug here.

Surely it is a bug on somebody's part that LO shows the final 1 and Excel does not.
Comment 4 Jean-Baptiste Faure 2015-02-16 20:16:24 UTC 
If there is a bug somewhere, I think it is on the MS-Excel side which doesn't show the last digit. You can't ask LibreOffice to deteriorate its result in order to mimic MS-Excel. Please report the bug to Microsoft.

Closing as NotOurBug.

Best regards. JBF