poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Stadler <dominik.stad...@gmx.at>
Subject Re: When IF() has an invalid (but unused) parameter.
Date Tue, 03 May 2016 17:59:16 GMT
Yes, it can be seen as bug as we usually try to mimic Excel-behavior
closely.

Can you report a bug together with sample code that shows how it can be
reproduced?

Thanks... Dominik.

On Mon, May 2, 2016 at 6:04 PM, Blake Watson <blake.watson@pnmac.com> wrote:

> Hello, folks--
>
> POI has a particular behavior that differs from Excel and tends to trip up
> my users. Let's say there's an IF():
>
> IF(cond1,ref1,0)
>
> If *cond1* is true, it should return the value of ref1, and if false, it
> should return 0. In Excel, if cond1 is false, 0 will be returned,
> regardless of what's in *ref1*. In POI, if ref1 is #REF, then evaluating
> the cell returns #REF, even if cond1 is false.
>
> As a result, ref1 has to be wrapped in IFERRORs.
>
> My questions are:
>
> 1) Do I have that correct? I've noticed this behavior repeatedly, and it
> can be a bear to figure out, but it's possible, of course, that I
> misunderstand what's going on.
>
> 2) Isn't that, essentially, a bug? Shouldn't the eval return what Excel
> would return?
>
> --
>
> *Blake Watson*
>
> *PNMAC*
> Application Development Manager
> 5898 Condor Drive
> Moorpark, CA 93021
> (805) 330.4911 x7742
> blake.watson@pnmac.com <melanie.petrosyan@pnmac.com>
> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message