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 2004/03/24 21:44:43 UTC

DO NOT REPLY [Bug 24925] - Nested IF Formula results in "#VALUE!" in Excel

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=24925>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=24925

Nested IF Formula results in "#VALUE!" in Excel

pete@quantrix.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Nested IF Formula results in|Nested IF Formula results in
                   |"#VALUE!" in Excel          |"#VALUE!" in Excel



------- Additional Comments From pete@quantrix.com  2004-03-24 20:44 -------
The problem is that cell references in the nested ifs were not getting their 
Token classes set properly because the recursion would bail out early when it 
reached nodes that were not AbstractFunctionPtgs.  In fact, we want to recurse 
into the entire tree to push out this token munging stuff.  NOTE: The second 
patch file i submitted is the one i am proposing.  The other one is just 
cruft.  Sorry.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org