|Summary:||EvaluationCache.getPlainValueEntry() assertion fails|
|Product:||POI||Reporter:||Frantisek Jandos <frantisek.jandos>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
Description Frantisek Jandos 2008-11-05 01:42:30 UTC
If I run full workbook recalculation, using HSSFFormulaEvaluator.evaluateAllFormulaCells() I got ISE from EvaluationCache.getPlainValueEntry() method, telling me "value changed". This is due to comparison of Double.NaN == Double.NaN which result is false.
Comment 1 Josh Micich 2008-11-05 09:46:41 UTC
It's easy enough to handle this extra case (NaN), but I was of the understanding that Excel uses error code (#NUM!) whenever an IEEE floating point operation resulted in NaN. At the moment, I am guessing that the bug is probably elsewhere. Could you attach a sample spreadsheet which shows this problem?
Comment 2 Dominik Stadler 2013-08-05 09:22:21 UTC
no response in a long time => resolving for now, please reopen with more information ifnthis is still an issue