The IF function in HSSF API is a bit tricky... but it does work to some extent. I agree that it doesn't work in most of the usual scenarios. Like it doesn't evaluate AND / OR conditions in the logical_test, it gives problem evaluating nested IF conditions etc.
Yet I have tried to use it to the fullest possible extent.... post your problem and lets see if we can solve it. Regards, Sumit Colin Zhao <[EMAIL PROTECTED]> 03/25/2006 11:39 AM Please respond to "POI Users List" <poi-user@jakarta.apache.org> To poi-user@jakarta.apache.org cc Subject Function evaluation with IF Has anyone tried the IF function evaluation? It doesn't seem to work yet. I was going through the source code and have no clue how it is implemented or to be implemented. --------------------------------- Blab-away for as little as 1ยข/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice. +=========================================================+ This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. +=========================================================+