[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 Eike Rathke changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||7679 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 Eike Rathke changed: What|Removed |Added Version|7.2.4.1 release |7.2.0.0.beta1+ CC||er...@redhat.com --- Comment #8 from Eike Rathke --- This is what you get when repeatedly adding binary floating point values. See also https://erack.de/bookmarks/D.html#010203 Note also what happens to the displayed values when column E is widened. Fwiw, Gnumeric quite agrees (with marginal different values) in that results are not 0 as it does not try to eliminate accuracy problems. Note that only changing the display format to a rounding one just hides the proliferation of accuracy errors. In fact you have to round all intermediate values in column E starting from the bottom to make this work, like in E72 =ROUND(SUM(C72;E73;A72);2) and copy that up. Or instead of SUM() use the + operator that is implemented to try to tie values to 0 for marginal minimal accuracy differences, like =C72+E73+A72 and copy that up. I also see no change in 7.2.4, I get the same display values in 7.2.0; however, I do see the difference compared with 7.1.8 and earlier. I assume this is due to the Kahan summation algorithm being implemented for SUM() and some other functions taking cell ranges, see https://wiki.documentfoundation.org/ReleaseNotes/7.2#Calc and bug 137679, where previously SUM() for the first and one subsequent value did something similar as the + operator. Maybe we can add that back as a special case for single values like they are used here. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 --- Comment #7 from stragu --- This is not XLS-specific: I could confirm with the same versions listed above with the file saved as ODS. I can confirm that the workaround is to change the format from "general" to something else. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 stragu changed: What|Removed |Added OS|Windows (All) |All Blocks||109352, 107575 Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #6 from stragu --- Confirmed with: Version: 7.2.4.1 / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Version: 7.3.0.0.beta1 / LibreOffice Community Build ID: 436f14c25ec1847646b953cf13d0db4f7ca3be57 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 17a4f4d5e4d49189b43e748271d2d4fa330eef9b CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded But I _don't_ reproduce with: Version: 7.0.6.2 Build ID: 00(Build:2) CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Ubuntu package version: 1:7.0.6-0ubuntu0.18.04.1_lo1 Calc: threaded Version: 7.1.8.1 / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded I am surprised this issue arises with the 7.2.4.1 release, as it was a security fix release with one single issue corrected... Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107575 [Bug 107575] [META] Number format bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=109352 [Bug 109352] [META] Sum function bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 --- Comment #5 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 --- Comment #4 from marcel.deneumost...@gmail.com --- Info requested. 1) Version: 7.2.4.1 (x64) / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: fr-BE (fr_BE); UI: fr-FR Calc: threaded 2) 7.2.3.2 release 3) See the attached file "test.xls" where all numbers are formatted as "Standard". For example, if I open the file on my PC Window 10, I see for cell E4 "-2,7E-13" iso 0. 4) See the attached file "screenshot 2021-12-22 150229.jpg", just what I see on my PC. Regards. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 --- Comment #3 from marcel.deneumost...@gmail.com --- Created attachment 177096 --> https://bugs.documentfoundation.org/attachment.cgi?id=177096=edit file test.xls -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 --- Comment #2 from marcel.deneumost...@gmail.com --- Created attachment 177095 --> https://bugs.documentfoundation.org/attachment.cgi?id=177095=edit Screenshot open test.xls file -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146367] LibreOffice calc, problem with the number FORMATTING since upgrade to 7.2.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=146367 stragu changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||stephane.guil...@member.fsf ||.org Ever confirmed|0 |1 --- Comment #1 from stragu --- Hi Marcel Thank you for the report. I couldn't reproduce with: Version: 7.2.4.1 / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Can you please: - share the information included in Help > About LibreOffice... (it might be "Aide > À propos de LibreOffice..." en français). There is a button to copy everything. - tell us which version you updated from (the version you were using before installing 7.2.4.1) - provide us with a simple example file that shows the issue, or more precise steps to reproduce (including what values are in the cells you referenced). Thank you! -- You are receiving this mail because: You are the assignee for the bug.
