Bug 64393 - [PATCH] Corrects relational operators against MissingArgEval
Summary: [PATCH] Corrects relational operators against MissingArgEval
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 4.1.2-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-30 01:09 UTC by John Lincoln White
Modified: 2020-05-16 13:06 UTC (History)
0 users


Attachments
Patch to treat MissingArgEval like BlankEval in RelationalOperationEval (3.85 KB, patch)
2020-04-30 01:09 UTC, John Lincoln White 		Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.