https://bz.apache.org/bugzilla/show_bug.cgi?id=58966
Bug ID: 58966
Summary: Row.getCell doesn't retrieve the same value than what
VBA gives
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: jmc...@gmail.com
Hello,
I am having a problem with retrieving the right data from excel:
I have the cell D5 that contains the formula "=3000000/D10" and D10 cell
contains the formula "=1.41973/1.2939".
When I read this cell within VBA macro like this : Worksheets("My
sheet").Cells(5, 4), I get 2734111.41555084 but when I read it via POI in Java:
XSSFSheet sheet = workbook.getSheetAt(1);
final Iterator<Row> rowIterator = sheet.iterator();
Cell cell;
while (rowIterator.hasNext()) {
final Row row = rowIterator.next();
...
cell = row.getCell(col, Row.RETURN_BLANK_AS_NULL);
...
}
cell contains here 2734111.4155508447 (see the extra 47), which is wrong.
Indeed, when I type in a calculator 3000000/(1.41973/1.2939), the result is
2734111.4155508441745965782226198 ()
I expect to get the same result as VBA gives.
Regards,
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
