poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 47198] New: -0.0 equals 0.0 in Excel, but not in POI
Date Fri, 15 May 2009 11:55:37 GMT

           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

View raw message