https://bugs.documentfoundation.org/show_bug.cgi?id=173045
Bug ID: 173045
Summary: Calc is rounding up some values on (EXPORT) convert-to
csv for .xls
Product: LibreOffice
Version: 6.0.7.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
floating point number is being rounded up unexpectedly in some cases. This
occurs both with "raw" and "formatted" conversion from .xls files but not with
.xlsx or .ods files.
Steps to Reproduce:
1. Create testdoc.xls with ANY software with these values on sheet1:
8301772.29756076 <-- literal value
'8301772.29756076 <-- use apostrophe to force as text
2. run command line conversion to CSV
libreoffice --convert-to csv testdoc.xls
3. inspect testdoc.csv
Actual Results:
8301772.29756077
8301772.29756076
Expected Results:
8301772.29756076
8301772.29756076
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Tried with many differnet values but only saw problem with this one so far.
Same behaiour seen with both these versions:
LibreOffice 6.0.7.3 00m0(Build:3)
LibreOffice 7.3.7.2 30(Build:2)
--
You are receiving this mail because:
You are the assignee for the bug.
