Bug 47198

Summary: -0.0 equals 0.0 in Excel, but not in POI
Product: POI Reporter: Torbjørn G. Dahle <tgdahle>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: major    
Priority: P2    
Version: 3.5-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Attachments: Test case XLS demonstrates error when parsed

Description Torbjørn G. Dahle 2009-05-15 04:55:35 UTC 
Created attachment 23664 [details]
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.
Comment 1 Josh Micich 2009-05-21 23:27:02 UTC 
Nicely spotted.

fixed in svn r777392

junit added