Issue 64851 - sum precision differs for inline and cell arguments
Summary: sum precision differs for inline and cell arguments
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P4 Trivial with 23 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-04-27 14:58 UTC by spapani
Modified: 2017-05-20 11:11 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
testcase (8.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-05-12 22:17 UTC, ooo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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".