You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/05/15 13:55:37 UTC

DO NOT REPLY [Bug 47198] New: -0.0 equals 0.0 in Excel, but not in POI

https://issues.apache.org/bugzilla/show_bug.cgi?id=47198

           Summary: -0.0 equals 0.0 in Excel, but not in POI
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: major
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: tgdahle@origin.no


Created an attachment (id=23664)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23664)
Test case XLS demonstrates error when parsed

When opening the attached file in Excel 2007, 0.0 is evaluated to be equal to
both 0.0 and -0.0. However, in POI, 0.0 and -0.0 are not equal. This causes IF
to make the wrong decision.

When parsing the file in POI, I get true for the first comparison, false for
the second.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 47198] -0.0 equals 0.0 in Excel, but not in POI

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47198


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #1 from Josh Micich <jo...@gildedtree.com>  2009-05-21 23:27:02 PST ---
Nicely spotted.

fixed in svn r777392 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=777392 )

junit added

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org