poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54636] getNumericCellValue return different result for visually equal numbers
Date Tue, 05 Mar 2013 19:14:17 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=54636

--- Comment #6 from Yujun Liang <yujunliang@hotmail.com> ---
Created attachment 30020
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=30020&action=edit
Modified file.

I added one more cell A3, value = 97.9162345%, format = "#,##0.000%"

So the file contents becomes,

           A             Display value with focus   Reading with POI
1     97.916%             97.916%                   0.97915999999999   
2     97.916%             97.916%                   0.97916 
3     97.916%             97.9162345%               0.979162345

Any idea why cell A2 is not 0.97915999999999 by POI?

-- 
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


Mime
View raw message