https://bz.apache.org/bugzilla/show_bug.cgi?id=56702
Herve <herve.gue...@knowesia.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|3.8-FINAL |3.12-FINAL
--- Comment #12 from Herve <herve.gue...@knowesia.com> ---
I got this bug with version 3.12final
Here is my context : I ask for the values of a range of cells (tab!A1:A4 for
instance).
In the Excel file, tab!A1 contains a formula with hlookup (or vlookup, i don't
remember) and I copy tab!A1 to tab!A1:A3
The result of A1 is a string, the result of A2 is an empty cell (it displays
0).
POI computed tab!A1 value ok,
and then raises the error on cell tab!A2.
I found that the exception was risen by HSSFCell.getNumericCellValue which was
called by DateUtil.isCellDateFormatted.
The issue I found is that HSSFCell.getNumericCellValue calls
checkFormulaCachedValueType(CELL_TYPE_NUMERIC, (FormulaRecord)fr) and
checkFormulaCachedValueType() returns stringtype for A2, despite the fact that
A2 contains a number.
I guess that the FormulaRecord of tab!A1 is the same as FormulaRecord of tab!A2
and as tab!A1 contains a string and caches this type,
checkFormulaCachedValueType returns also string for tab!A2.
I have not enough knowledge of POI code to propose a fix,
but I put the workaround I used there :
http://stackoverflow.com/questions/6508203/when-getting-cell-content-using-apache-poi-library-i-get-both-cannot-get-a-num/32376505#32376505
--
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
