Description: When entering a formula such as "=(50000-50000/0.3)*0.3+25000" instead of -10000 it shows .0000 in the cell. This only appears to happen with 'General' or 'Text' format - others show the correct value. Steps to Reproduce: 1. Open new spreadsheet 2. Enter the formula "=(50000-50000/0.3)*0.3+25000" in a cell 3. Observe the text shown in the cell Actual Results: Shows .0000 in the cell Expected Results: Should be showing -10000 Reproducible: Always User Profile Reset: No Additional Info: Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.8 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); Calc: group
Confirmed. Already in earlier versions, earliest here 5.3.7. Odd.
I also noticed that when the cell is selected it shows "Average: .0000; Sum: .0000" in the status bar (both of those should be -10000).
The status bar shows values in the same format the cell cursor is on, so that's logical.
Investigating.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/be8da97976658ff19b4dd010bff328cd3f424c1b%5E%21 Resolves: tdf#126766 fix rounding correction at start of negative values It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/77215 for 6-3 https://gerrit.libreoffice.org/77216 for 6-2
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/7565f05affa2dd668de769a2ae259d2e8d2808e7%5E%21 Resolves: tdf#126766 fix rounding correction at start of negative values It will be available in 6.3.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://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-6-2": https://git.libreoffice.org/core/+/05b79e965481893ef7ffdbf4c6a77d90aeb68b20%5E%21 Resolves: tdf#126766 fix rounding correction at start of negative values It will be available in 6.2.7. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.