https://issues.apache.org/ooo/show_bug.cgi?id=124613

[email protected] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|4.0.1                       |3.4.1

--- Comment #7 from [email protected] ---
yes(In reply to Edwin Sharp from comment #4)
> A6 and A12 look equal but are not. Why?

Yes, odd indeed. I thought it was the usual rounding error with floating point
numbers.

looks like this is connected to Issue 64851
if you replace A6  =SUM(A1:A4) with =SUM(A1;A2;A3;A4)
the result is correct

My former notice is incorrect, MS Excel shows correct result (it didn't copy
the formula, though)

shown difference in AOO is -4,54747350886464E-013 = -0,5^41 

"use precision" as shown has no effect on result, see issue 111493

it's not an new issue, already in AOO 3.4.1

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

Reply via email to