[Libreoffice-bugs] [Bug 126970] Calc: calculation: cancellation and operand ordering effects in calc | was: Function "SUM()" work doesn't correct if final result is zero

2023-08-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=126970 --- Comment #11 from b. --- @ady: I think to remember that Calc does not calculate in the sequence as listed -> unpredictable results. IEEE: 4904.28 has undershot representation ~ 4904.27997453, -4857.88 has overshot repr

[Libreoffice-bugs] [Bug 126970] Calc: calculation: cancellation and operand ordering effects in calc | was: Function "SUM()" work doesn't correct if final result is zero

2023-04-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=126970 BogdanB changed: What|Removed |Added Blocks||108253 Referenced Bugs: https://bugs

[Libreoffice-bugs] [Bug 126970] Calc: calculation: cancellation and operand ordering effects in calc | was: Function "SUM()" work doesn't correct if final result is zero

2023-04-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=126970 --- Comment #10 from ady --- =SUM(-46.4;4904.28;-4857.88) -> not zero. =SUM(4904.28;-4857.88;-46.4) -> zero. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 126970] Calc: calculation: cancellation and operand ordering effects in calc | was: Function "SUM()" work doesn't correct if final result is zero

2023-04-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=126970 --- Comment #9 from ady --- Opening attachment 153465 from comment 2 with LO 7.4.6 or with LO 7.6.alpha, force recalculation, the results of cells with SUM() are all shown as zero for me. WFM? -- You are receiving this mail because: You

[Libreoffice-bugs] [Bug 126970] Calc: calculation: cancellation and operand ordering effects in calc | was: Function "SUM()" work doesn't correct if final result is zero

2023-04-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=126970 BogdanB changed: What|Removed |Added Summary|calc: calculation: |Calc: calculation: |