Bug 46150 - EvaluationCache.getPlainValueEntry() assertion fails
Summary: EvaluationCache.getPlainValueEntry() assertion fails
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.2-dev
Hardware: PC Windows Vista
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2008-11-05 01:42 UTC by Frantisek Jandos
Modified: 2013-08-05 09:22 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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