You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2008/09/17 02:01:01 UTC

DO NOT REPLY [Bug 45732] Formula Value

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


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #1 from Josh Micich <jo...@gildedtree.com>  2008-09-16 17:01:00 PST ---
It looks like POI calculates NPER OK.  Excel gives a result of #NUM! for the
example parameters, and so does POI. FinanceLib.nper has not changed in a long
time (2005), so recent versions of POI should be OK too.

You didn't attach any example code, but I am guessing that you were using the
method HSSFFormulaEvaluator.evaluateFormulaCell(), and calling
HSSFCell.getNumericCellValue() to check the result.  Prior to svn r694631 POI
did not write error result codes back to the cached formula value, so this
could explain your observations.

A new test case (TestNper.testEvaluate_bug_45732) has been checked in (svn
696109) which produces behaviour like you have described.

Note also, since svn r694631 a new method has become available:
HSSFCell.getCachedFormulaResultType(), which can take the trial and error out
of determining which getter method value type to use when reading formula cell
cached values. 


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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