[Bug 54509] Cells in shifting rows are not used in column-referencing formulas.

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=54509

--- Comment #2 from Sylvain Delafoy <sy...@gmail.com> ---
Looks like the difference comes from the software used to open the file. I
checked my example this morning with Excel 2010 and the latest libreoffice and
both showed 10. Unfortunately, I don't have access to the computer where I
noticed this problem to check excel's version.

However, if I add

System.out.println(new HSSFWorkbook(new
FileInputStream("out.xls")).getSheetAt(0).getRow(0).getCell(0).getNumericCellValue());

and use POI version 3.10.1 or 3.11-beta2 at the end of the test, the output is
7.

However, I wonder if it's a POI bug or not.

PS: My apologies to clean code, there is obviously a lot of stream closing to
be done. If this bug is reopened, I volunteer for writing a clean unit test.

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