Summary: | Calc Round Up is Rounding Down for some values | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | NOYB <JunkYardMail1> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | REOPENED --- | ||
Severity: | normal | CC: | buzea.bogdan |
Priority: | medium | ||
Version: | 7.6.0.3 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108252 | ||
Attachments: |
LibreOffice Calc Round Up Errors Screen Capture
LibreOffice Calc Round Up Errors (positional) |
Description
NOYB
2023-09-04 09:34:53 UTC
Created attachment 189334 [details]
LibreOffice Calc Round Up Errors Screen Capture
*** This bug has been marked as a duplicate of bug 154792 *** Precision of only 5 digits. So pathetic. And won't address it. LOLSMH 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 Created attachment 189353 [details]
LibreOffice Calc Round Up Errors (positional)
(In reply to NOYB from comment #4) > i.e. Everything beyond the specified digit+1 is ignored (treated as all > zeros; truncated prior to rounding). FWIW, that's not a completely accurate description. The value 0.276327000000664 requires 15 positions to the right of the decimal separator (which is a kind of limit for typical spreadsheet tools on common hardware); using a value of 14 decimal positions would have a different result in your test, and thus the aforementioned description would have to be expressed differently. I seem to remember that a while ago someone tried to fix errors in rounddown and roundup by preceding them with a 'roundsig' to 12 significant digits. If this is still active, you may be a victim of the mathematically questionable quality of such measures. |