|Summary:||[PATCH] Corrects relational operators against MissingArgEval|
|Product:||POI||Reporter:||John Lincoln White <jwhite>|
|Component:||SS Common||Assignee:||POI Developers List <dev>|
|Attachments:||Patch to treat MissingArgEval like BlankEval in RelationalOperationEval|
Description John Lincoln White 2020-04-30 01:09:11 UTC
Created attachment 37204 [details] Patch to treat MissingArgEval like BlankEval in RelationalOperationEval I investigated an issue with a formula in the form of: =ISERROR(C4,)=0 where the expected value is TRUE when C4 is an error. Further investigation showed that wherever ISERROR had no second argument, Excel treated it like a zero when comparing against other numbers. This patch modifies RelationalOperationEval to treat MissingArgEval the same way it treats BlankEval.