[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 Winfried Donkers changed: What|Removed |Added Status|NEW

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 --- Comment #9 from Winfried Donkers --- Changing A1 from =ROUND(B1,0) to =ROUND(B1,1) produces correct result (1001). Also using either ROUNDUP(B1,0) or ROUNDDOWN(B1,0) produces a result of 1004 in A3.

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 --- Comment #8 from mwelin...@gmail.com --- C1=1024*1024*1024*1024*1024*4 IEEE-758 [for binary formats] doesn't do decimal digits. It does binary digits. C1 requires *one* binary digit of mantissa. On page 8 of the 2008 version of the

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 --- Comment #7 from m.a.riosv --- C1=1024*1024*1024*1024*1024*4 = 4503599627370496 If I'm counting well there are sixteen digits on the result. and if I'm not wrong IEEE 754 specification it's limited to

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 --- Comment #6 from mwelin...@gmail.com --- Bug 67026 is unrelated. That one is about problems arising from 1/10 not being exactly representable in binary. Old news. This one is about wrong code implementing ROUND causing it to

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 --- Comment #5 from m.a.riosv --- https://bugs.documentfoundation.org/show_bug.cgi?id=67026 -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 --- Comment #4 from mwelin...@gmail.com --- Still there in 5.2.3.3. OpenLeap 42.1. > Perhaps the calculation are beyond the precision limits. It isn't. (And if it had been, the result would have been 1000, not 1002.) -- You are

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 --- Comment #3 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 m.a.riosv changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 96821] ROUND changes integers when it should not

https://bugs.documentfoundation.org/show_bug.cgi?id=96821 A (Andy) changed: What|Removed |Added Status|UNCONFIRMED |NEW