https://issues.apache.org/bugzilla/show_bug.cgi?id=48081 Summary: poi parsing excel accuracy is lost
Product: POI
Version: 2.5
Platform: Other
OS/Version: Linux
Status: NEW
Severity: critical
Priority: P2
Component: HSSF
AssignedTo:
dev@...
ReportedBy:
xunwei@...
hi!
I am so sorry my english is not very good.But I had an urgent problem need
to Solution by parsing excel with POI.
The description of the problem:
I have a project needs to parse excel in the number of amount.
For example,the amount is 1835.6, But I got such a result 1835.600000000001
when i used poi parsing it with the os linux 64-bit .
This is the code:
import org.apache.poi.hssf.usermodel.HSSFCell;
public double getNumberCellValueByPoi(HSSFSheet hssfsheet, int i, int j)
{
HSSFCell hssfcell = getCell(hssfsheet, i, j);
double value=hssfcell.getNumericCellValue();
return value;
}
The result output in the console is 1835.600000000001。But if i run the
project with the windows or linux 32-bit ,the result is right.
I need your reply quickly .Thank you very much.
--
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@...
For additional commands, e-mail:
dev-help@...
