Issue 74209 - wrong computations with respect to equality
Summary: wrong computations with respect to equality
Status: CLOSED DUPLICATE of issue 69749
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-02-06 09:35 UTC by acarstoiu
Modified: 2013-08-07 15:14 UTC (History)
1 user (show)

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

Attachments
sample file (6.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-02-06 09:38 UTC, acarstoiu 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description acarstoiu 2007-02-06 09:35:08 UTC 
Hello.

Since the previous version (2.0.4) I noticed something peculiar which now 
turned out to be an actual bug. See the attached sample file.

The idea is that given a simple addition of non-integer numbers with opposite 
signs, the result is not recognized as being equal to what it should be, 
although it is displayed correctly...
The cells in question are A1 and A2. Their sum is computed in B4 and also 
entered by hand in B2. Surprise, C2 indicates inequality between the computed 
result and the would-be result.

Given the purpose of Calc, I consider this to be quite a severe bug.
Comment 1 acarstoiu 2007-02-06 09:38:00 UTC 
Created attachment 42776 [details]
sample file
Comment 2 frank 2007-02-06 10:24:06 UTC 
Hi Eike,

could we do something to fix it ?

Frank
Comment 3 ooo 2007-02-06 11:03:41 UTC 
The usual IEEE 754 floating-point behavior. If you increase the displayed
decimals in the number format of cell B4 to 14 digits you'll see that the result
is not 6.41 but 6.40999999999997 instead.

*** This issue has been marked as a duplicate of 69749 ***
Comment 4 ace_dent 2008-05-17 21:04:31 UTC 
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html
Comment 5 ace_dent 2008-05-17 23:06:31 UTC 
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew