[Libreoffice-bugs] [Bug 123408] the sum of this selection is wrong, an offset of 1/100.
https://bugs.documentfoundation.org/show_bug.cgi?id=123408 m.a.riosv changed: What|Removed |Added CC||andrew...@biagionelli.com --- Comment #4 from m.a.riosv --- *** Bug 129220 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123408] the sum of this selection is wrong, an offset of 1/100.
https://bugs.documentfoundation.org/show_bug.cgi?id=123408 Oliver Brinzing changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #3 from Oliver Brinzing --- (In reply to Eike Rathke from comment #2) > That is due to loss of precision when using the IEEE 754 floating point > format. IMHO we can set this issue to RESOLVED/NOTABUG -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123408] the sum of this selection is wrong, an offset of 1/100.
https://bugs.documentfoundation.org/show_bug.cgi?id=123408 --- Comment #2 from Eike Rathke --- That is due to loss of precision when using the IEEE 754 floating point format. All computer software not using binary coded decimals or other means to correct precision round-offs suffers from it. See http://0.30004.com/ https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/ If you format the cells involved to two decimals, for example 0.00 then that format will be used in the status bar as well and the result displayed accordingly rounded. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123408] the sum of this selection is wrong, an offset of 1/100.
https://bugs.documentfoundation.org/show_bug.cgi?id=123408 --- Comment #1 from pierre klein --- Created attachment 149227 --> https://bugs.documentfoundation.org/attachment.cgi?id=149227=edit this is a copy a of the screen, problem highlited in yellow this is a copy a of the screen, problem highlited in yellow -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs