https://bugs.documentfoundation.org/show_bug.cgi?id=157082
NOYB <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|DUPLICATE |--- Ever confirmed|0 |1 Status|CLOSED |REOPENED --- Comment #4 from NOYB <[email protected]> --- Don't believe this duplicate of the 154792 issue. This issue is seems to be with the digit position of the rounding. i.e. Everything beyond the specified digit+1 is ignored (treated as all zeros; truncated prior to rounding). Formula Actual Result Expected Result Difference '=ROUNDUP(0.276327000000664,1) 0.300000000000000 0.300000000000000 '=ROUNDUP(0.276327000000664,2) 0.280000000000000 0.280000000000000 '=ROUNDUP(0.276327000000664,3) 0.277000000000000 0.277000000000000 '=ROUNDUP(0.276327000000664,4) 0.276400000000000 0.276400000000000 '=ROUNDUP(0.276327000000664,5) 0.276330000000000 0.276330000000000 '=ROUNDUP(0.276327000000664,6) 0.276327000000000 0.276328000000000 -0.000001000000000 '=ROUNDUP(0.276327000000664,7) 0.276327000000000 0.276327100000000 -0.000000100000000 '=ROUNDUP(0.276327000000664,8) 0.276327000000000 0.276327010000000 -0.000000010000000 '=ROUNDUP(0.276327000000664,9) 0.276327000000000 0.276327001000000 -0.000000001000000 '=ROUNDUP(0.276327000000664,10) 0.276327000000000 0.276327000100000 -0.000000000100000 '=ROUNDUP(0.276327000000664,11) 0.276327000000000 0.276327000010000 -0.000000000010000 '=ROUNDUP(0.276327000000664,12) 0.276327000001000 0.276327000001000 '=ROUNDUP(0.276327000000664,13) 0.276327000000700 0.276327000000700 '=ROUNDUP(0.276327000000664,14) 0.276327000000670 0.276327000000670 '=ROUNDUP(0.276327000000664,15) 0.276327000000664 0.276327000000664 -- You are receiving this mail because: You are the assignee for the bug.
