https://bz.apache.org/bugzilla/show_bug.cgi?id=55747
Nick Burch <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #12 from Nick Burch <[email protected]> --- I've spent a "fun" evening on this, and I think I've now got a unit test (failing unless bits commented out) describing the required situation. In org.apache.poi.hssf.usermodel.TestFormulaEvaluatorBugs#test55747_55324 I've got tests based on your test file, expanded a little bit, checking standalone MID, along with MID-in-IF As far as I can tell from that and the BiffViewer dumps, the rules seem to be: * MID used in IF 1st clause, or straight A1 ref in IF 1st clause: A1 = V * MID used in 2nd or 3rd clause that isn't used (evaluates other way): A1 = V * MID used in 2nd or 3rd clause that is used (evaluates that way): A1 = R <- thing we're doing wrong Does that match with your testing? If so, we'll need to have HSSFFormulaEvalutor tweak the types on evaluation. (We'd also need to identify any other types like that and fix them too) -- 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]
