https://bugs.documentfoundation.org/show_bug.cgi?id=120939
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #2 from Eike Rathke <[email protected]> ---
The document contains values with precision errors, like the calculated value
400 in B5 was stored as office:value="400.000000000001"; the calculated value
400 in B7 was stored as office:value="399.999999999999".
A manual =BITXOR(399.999999999999, 1) also produces 398, same as =BITXOR(399,1)
Recalculating (Shift+Ctrl+F9) the document after load produces correct values
here on Linux.
Saving the recalculated document results in correct office:value="400" and
office:value="6400" in all cases.
The test case document was generated using LibreOffice/6.0.6.2$Windows_X86_64
Is this reproducible for others?
Btw, also the calculated value 6400 in B2 was stored as
office:value="6400.00000000001", the calculated value 6400 in B10 was stored as
office:value="6400"; which both are stored as office:value="6400" after
recalculating.
--
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
