DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26610>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26610 nested IF's in formulas produce #VALUE! error in excel Summary: nested IF's in formulas produce #VALUE! error in excel Product: POI Version: 2.0-pre3 Platform: All OS/Version: All Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] The formula document on the HSSF website instructed to report all occurrences of #VALUE! when attempting to programmatically assign a formula to a cell, so here goes: IF(A1 > 5, "big number", "small number") This formula works, and displays correctly when opened in Excel. #VALUE! is only displayed if the outer IF branches to an inner IF. For example: > IF(A1 > 5, "big number", IF(A1 < 2, "really small number", "small number")) #VALUE! is displayed if "A1 > 5" evaluates to false, and branches to the "else" argument, where there's a nested IF. If "A1 > 5" evaluates to true, the formula displays correctly, because there's no nested if in the "true" argument. #VALUE! is always displayed if both the true and false arguments contain nested IF's. -The cell displays #VALUE! -but if I type it in directly in Excel, the formula works -also, clicking in the formula bar of POI-generated formula, then hitting Enter, fixes the formula Thanks, -Sasha Borodin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
