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