https://issues.apache.org/bugzilla/show_bug.cgi?id=55875
Bug ID: 55875
Summary: After setting a cell to String type, the result of
getStringCellValue for some certain format cells is
not right
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: critical
Priority: P2
Component: POI Overall
Assignee: [email protected]
Reporter: [email protected]
Please try the following to replicate the bug.
......
Cell cell = row.getCell(0);
cell.setCellType(Cell.CELL_TYPE_STRING);
String s = cell.getStringCellValue();
......
With MS excel 2007, when the cell value is like, "123.567", and its cell format
is "General" in excel, the value of String s will be, "123.56699999999999". But
if the cell value is like "12.4567" or "12345.7", the value of String s will be
the same, "12.4567" or "12345.7".
Thanks!
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
