https://bugs.documentfoundation.org/show_bug.cgi?id=50299
--- Comment #37 from Aron Budea <[email protected]> ---
(In reply to klsu from comment #36)
> Using the above test file dated 2014-12-21 19:00 CET in Version 5.1.4.2,
> Build ID: 1:5.1.4-Oubuntu1, the spreadsheet is still showing 143 of 1000
> results not equal to zero, 72 of which are significant; so the problem still
> exists.
5.1.4.2 is quite old, if you check the bug report mentioned by Eike, the fix is
in 5.3. Testing with 5.3.0.2 and doing a hard recalc on the fields shows no
errors.
> The problem that lead me to the discovery of this one also still occurs in
> Version 5.1.4.2, Build ID: 1:5.1.4-Oubuntu1. That involved converting months
> and displayed as decimals (i.e., European format) to U.S. format in a
> spreadsheet in which everything else is in U.S. format. I've added an
> example of that.
This is quite interesting, the main issue is:
=MOD(24.09;1)*100 is 8.9999999,
while:
1) 0.09*100 is 9,
2) =MOD(24.09;1) is 0.09.
There's probably a reasonable explanation for it in the handling of floating
point numbers, hopefully someone else can shed some light on that.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
