https://bz.apache.org/ooo/show_bug.cgi?id=127640
--- Comment #5 from Patricia Shanahan <[email protected]> --- (In reply to Peter from comment #4) > Probably OpenOffice uses a different internal prediction. I had the same > issue with excel and SA5 (a statistical language) > If I remember it directly Excel used a fixed 9 precision while SAS uses 14 > and produced different results. > > My guess would be you deal the same issue. According to "Floating-point arithmetic may give inaccurate results in Excel" at https://support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel, Excel uses IEEE 754 64-bit binary floating point, like OpenOffice. The article suggests the use of ROUND and/or "precision as displayed". -- You are receiving this mail because: You are the assignee for the issue.
