|Summary:||-0.0 equals 0.0 in Excel, but not in POI|
|Product:||POI||Reporter:||Torbjørn G. Dahle <tgdahle>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
|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.