Bug 64393

Summary: [PATCH] Corrects relational operators against MissingArgEval
Product: POI Reporter: John Lincoln White <jwhite>
Component: SS CommonAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 4.1.2-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
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.
Comment 1 Dominik Stadler 2020-05-16 13:06:59 UTC
Applied via r1877815 now, thanks for the patch and unit-tests.