| Summary: | Rounding display error for 15 digits integers | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Cœur <coeur> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | erack, h3734236, miguelangelrv |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=160985 | ||
| Whiteboard: | target:5.2.0 target:5.1.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | File with list of inputted numbers and how they are shown | ||
|
Description
Cœur
2016-01-06 07:23:28 UTC
Created attachment 121803 [details]
File with list of inputted numbers and how they are shown
I can confirm this on Libreoffice 5.1.0.1 Linux. Attached is a file containing the value inputted and the result shown.
You might have to change the format from default to -12345 to see all the numbers
You can find some information in https://bugs.documentfoundation.org/show_bug.cgi?id=94394#c1 the comment is from a main calc developer. This is slightly different though because the entered number can be represented and displayed as is, but our conversion to decimal digits stops the bin-dec correction after 14 decimal digits and starts normal rounding after that. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0f6203edf74832f84d8263d7a544d679203a4efc tdf#96918 display accurate integer double values up to (2^53)-1 It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a3f5f4f6369552a3da870de1ed4ea9d8c628c7a8 unit test for tdf#96918 display accurate integer double values It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review https://gerrit.libreoffice.org/21429 for 5-1 https://gerrit.libreoffice.org/21435 for 5-1-0 https://gerrit.libreoffice.org/21430 for 5-0 Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fdf982f70b2944053d995baaa3d78c7cdc4bbc4b handle negative decimal places for rounding, tdf#96918 related It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5299400e5cce3060a0de85bb4dedd065b5ad1f41 unit test for negative decimal places rounding, tdf#96918 related It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e480172cb91b4adca6a7fcd42f68c2ff2874fe54&h=libreoffice-5-1 tdf#96918 display accurate integer double values up to (2^53)-1 It will be available in 5.1.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-1-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ab0ef85c7dbc0f8f25cb39ebcce4d5aa038d2f56&h=libreoffice-5-1-0 tdf#96918 display accurate integer double values up to (2^53)-1 It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |