Bug 46150

Summary: EvaluationCache.getPlainValueEntry() assertion fails
Product: POI Reporter: Frantisek Jandos <frantisek.jandos>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: P2    
Version: 3.2-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   

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