Issue 64851

Summary: sum precision differs for inline and cell arguments
Product: Calc Reporter: spapani <spapani>
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues, kozodaevroman, lars_o_hansen, www.openoffice.org
Version: OOo 2.0.2Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
testcase none

Description 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.
Comment 1 lars 2006-04-27 18:29:31 UTC
confirmed with 680_m164 on WinXP Pro SP2; =SUM(A1:A3) yields a different 
("wrong") result
Comment 2 frank 2006-05-12 14:58:13 UTC
Hi Eike,

one for you ?

Frank
Comment 3 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.
Comment 4 ooo 2006-05-12 22:17:52 UTC
Created attachment 36436 [details]
testcase
Comment 5 Marcus 2017-05-20 11:11:13 UTC
Reset assigne to the default "issues@openoffice.apache.org".