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 <[email protected]> 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 > [email protected] <[email protected]> > www.PennyMacUSA.com <http://www.pennymacusa.com/> >
