https://bz.apache.org/bugzilla/show_bug.cgi?id=62904
--- Comment #6 from Yegor Kozlov <[email protected]> --- I checked in a follow-up to my previous commit. Now all tests pass including the commented ones, that failed in my previous commit. Excel has an optimization when evaluating the IF formula: depending on whether the logical condition is true/false, the PTGs for the 2nd or 3rd argument can be skipped altogether without evaluation. I had a hard time figuring out how it works in array mode until I realized that the "optimized if" logic is not applicable in array context: in array mode all arguments should be evaluated and put onto the stack and the 'skip' instructions should be ignored. Once I realized this and changed the code all failing tests started to pass. Regards, Yegor -- 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]
