[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #15 from Mike Kaganski --- (In reply to b. from comment #14) > @Mike Kaganski: 'Kahan Summation' may! help as a: it's not limited to > different magnitude, and b: the difference running total / summands will > likely grow

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 b. changed: What|Removed |Added Hardware|x86-64 (AMD64) |All OS|Linux (All)

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #13 from TheWebMachine --- (In reply to Mike Kaganski from comment #12) > I don't care if we change the default visual representation to, say, 4 > decimals. Of course it's funny when a dev with 25 years of FP assembly does >

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #12 from Mike Kaganski --- I don't care if we change the default visual representation to, say, 4 decimals. Of course it's funny when a dev with 25 years of FP assembly does not recognize this specific thing when they see it,

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #11 from TheWebMachine --- I've been a dev for 25+ years and still code for embedded controllers with FAR LESS CAPABILITY to this day. I know how floating point in binary works (have you ever built floating point math in pure

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #10 from Mike Kaganski --- Created attachment 171164 --> https://bugs.documentfoundation.org/attachment.cgi?id=171164=edit A screenshot from Excel with sum shown with 12 decimals (In reply to TheWebMachine from comment #9)

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 TheWebMachine changed: What|Removed |Added Resolution|DUPLICATE |--- Ever confirmed|0

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #7 from Mike Kaganski --- Ah, now I read the numbers here, and see that this is not a dupe of tdf#137679. That one helps when there are numbers of different magnitude, which is not the case here. This one will not change, and

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #8 from Mike Kaganski --- https://wiki.documentfoundation.org/Faq/Calc/Accuracy -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #6 from Mike Kaganski --- (In reply to Michael Warner from comment #3) > (In reply to Uwe Auer from comment #2) > > From my perspective not a bug but consequence of floating point arithmetic. > > Which could be mitigated by

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 TheWebMachine changed: What|Removed |Added Resolution|--- |DUPLICATE

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #4 from Uwe Auer --- (In reply to Michael Warner from comment #3) > (In reply to Uwe Auer from comment #2) > > From my perspective not a bug but consequence of floating point arithmetic. > > Which could be mitigated by Calc

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #3 from Michael Warner --- (In reply to Uwe Auer from comment #2) > From my perspective not a bug but consequence of floating point arithmetic. Which could be mitigated by Calc rounding the result so that it has the same

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #2 from Uwe Auer --- >From my perspective not a bug but consequence of floating point arithmetic. -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [Bug 141614] EDITING: Calc shows incorrect SUM (deviation of 0.000000000002 added to/sub'd from total) in bottom right status bar

2021-04-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141614 --- Comment #1 from TheWebMachine --- Created attachment 171088 --> https://bugs.documentfoundation.org/attachment.cgi?id=171088=edit Screenshot example of incorrect SUM -- You are receiving this mail because: You are the assignee