Issue 64851 - sum precision differs for inline and cell arguments
sum precision differs for inline and cell arguments
 Status: ACCEPTED None Calc Application code (show other issues) OOo 2.0.2 All All P4 Trivial --- AOO issues mailing list oooqa

 Reported: 2006-04-27 14:58 UTC by spapani 2017-05-20 11:11 UTC (History) 4 users (show) issues kozodaevroman lars_o_hansen www.openoffice.org ENHANCEMENT --- ---

Attachments
 spapani 2006-04-27 14:58:44 UTC ```In Calc, entering in a cell the formula [decimal separator is the comma , ] =SUM(-2,1;1495,87;-1493,77) gives (for scientific formatting) 0,00E+000 . Putting exactly the same three values in cells A1, A2 and A3 of the spreadsheet and using the formula =SUM(A1:A3) gives (for the same formatting as above) -9,10E-014 while =A1+A2+A3 gives again 0,00E+000 I understand the problem of finite precision math, however the three computations above should give the same result. The same issue can be reproduced with other triplets of numbers.``` lars 2006-04-27 18:29:31 UTC ```confirmed with 680_m164 on WinXP Pro SP2; =SUM(A1:A3) yields a different ("wrong") result``` frank 2006-05-12 14:58:13 UTC ```Hi Eike, one for you ? Frank``` ooo 2006-05-12 22:16:41 UTC ```It depends on the order of evaluation. Changing that gives different results, see attachment. This isn't even a defect, I'm taking it as a cosmetical make-up. Btw, it's the same in Excel, just that they calculate sum(a1:a3) in the same order as a1+a2+a3, we don't, due to internal processing. A user may expect to see identical results in this case, so it might be worth to change it. But certainly not a P3.``` ooo 2006-05-12 22:17:52 UTC ```Created attachment 36436 [details] testcase``` Marcus 2017-05-20 11:11:13 UTC `Reset assigne to the default "issues@openoffice.apache.org".`