https://issues.apache.org/bugzilla/show_bug.cgi?id=51024
Giuseppe Nespolino <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- OS|Windows XP |All --- Comment #2 from Giuseppe Nespolino <[email protected]> --- I am experiencing this bug in poi-3.9 It happens to me with an xlsx file, so maybe the test case should consider XSSF workbook. The formula contains VLOOKUP(refereceArg;range;2;) so the parser believes it is a 4 args formula and when calling LookupUtils.resolveRangeLookupArg with a MissingArgEval it throws a runtime exception. I believe it is enough to add: if (valEval instanceof MissingArgEval) { return true; /* true is default is last arg is missing */ } in LookupUtils.resolveRangeLookupArg to solve this bug, or maybe it breaks something and it should be addressed at parser level or even at Var3or4ArgFunction, making args.length be 3 if last one is an instance of MissingArgEval. If needed i can attach an xlsx file and some code to reproduce the bug -- 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]
