https://bugs.freedesktop.org/show_bug.cgi?id=83511
Priority: medium
Bug ID: 83511
Assignee: [email protected]
Summary: FILEOPEN FILESAVE rounding XLSX numbers
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Context: https://github.com/SheetJS/js-xls/issues/49#issuecomment-54542526
Excel stores raw IEEE754 numbers when saving. For example, a cell with formula
=0.1+0.2 will have a stored value of 0.30000000000000004. However, LibreOffice
appears to store the rounded value instead.
Based on the aforementioned context, I have collected some sample files at
http://sheetjs.com/xls_issue_49/
xls_issue_49.xls is the original XLS file. The other files are produced by
opening the XLS file and saving as XLSX with the specified tool:
- xls_issue_49_2011.xlsx -- excel 2011
- xls_issue_49_2013.xlsx -- excel 2013
- xls_issue_49_2013_strict.xlsx -- excel 2013 Strict OpenXML
- xls_issue_49_libreoffice.xlsx -- LibreOffice
Look at cell C172 in the sheet1.xml subfile of each. The files based from
Excel show:
<c r="C172" s="1">
<v>3.2400000000000005E-2</v>
</c>
The LO file shows:
<c r="C172" s="4" t="n">
<v>0.0324</v>
</c>
On a side note, the `t="n"` is strictly not needed according to ECMA-376: the
default cell type is "n" as seen in the schema definition
<xsd:attribute name="t" type="ST_CellType" use="optional" default="n"/>
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
