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


Josh Micich <[EMAIL PROTECTED]> changed:

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




--- Comment #3 from Josh Micich <[EMAIL PROTECTED]>  2008-05-27 23:30:09 PST ---
Fix applied in svn r660828.

It seems that POI's operand class transformation differed from a lot Excel's. 
A new test case (TestRVA.java) shows many of those differences.

It seems that in the function metadata for IRR, the first parameter should be
operand class 'array' (not 'reference').  However, this was not nearly enough
to get all the test cases working.

Some changes were made to the Ptg class hierarchy (to make the distinction
between classified and base tokens clearer).  Amongst other changes
FormulaParser was fixed to produce a parse tree on the fly while parsing (as
opposed to storing tokens in a flat list.

As of this fix, POI still has some differences with Excel with regard to
operand class transformation, but no significant examples have been found (i.e.
in the cases where POI gets it wrong, Excel still seems to read/evaluate the
formula OK).


-- 
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to