[Libreoffice-bugs] [Bug 87506] Inconsistency in how LibreOffice Calc 4.4.0BetaDevDaily handles real numbers internally or with the MOD() function or both.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Apr 10 16:54:26 UTC 2021


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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #3 from b. <newbie-02 at gmx.de> ---
@klsu: if you select cells C1 or C2 and look at the input line you will see a
deviation, 
you may also get it visible with: '=RAWSUBTRACT(B2;E2)', 
calc does some 'tolerant compare' to cover such small imprecisions, but keeps
the odd value and uses it for downstream calculations, one can argue the hour
and the day whether well done or not, 
the source of evil is 'cancellation', and that no spreadsheet has good handling
for that so far ... :-(

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210410/9d23fc49/attachment.htm>


More information about the Libreoffice-bugs mailing list