https://bugs.documentfoundation.org/show_bug.cgi?id=154941

Mike Kaganski <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #2 from Mike Kaganski <[email protected]> ---
This is not a bug.

There is no "1.45" in Calc. When you enter this string into a cell, it gets
converted to Calc's internal numeric representation, which is IEEE 754 double
precision (64 bit) binary floating point. Its exact value is

1.4499999999999999555910790149937383830547332763671875

(you may see it at https://baseconvert.com/ieee-754-floating-point), and so the
rounding is not from exactly 1.45, but from a slightly smaller value. Hebce the
result.

Please see also this FAQ: https://wiki.documentfoundation.org/Faq/Calc/Accuracy

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to