You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/01/10 15:16:29 UTC

[Bug 54402] New: [PATCH] Bug in IFERROR

https://issues.apache.org/bugzilla/show_bug.cgi?id=54402

            Bug ID: 54402
           Summary: [PATCH] Bug in IFERROR
           Product: POI
           Version: unspecified
          Hardware: Macintosh
                OS: Mac OS X 10.4
            Status: NEW
          Severity: normal
          Priority: P2
         Component: POI Overall
          Assignee: dev@poi.apache.org
          Reporter: johan.karlsteen@gmail.com
    Classification: Unclassified

Created attachment 29841
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=29841&action=edit
Bugfix in IFERROR

I found a bug in IFERROR.

It works good if you have a cell with for example: IFERROR(A1/A2,"error") and
A1/A2 is an error but if you have A3=A1/A2 and IFERROR(A3,"error") it will not
find the error.

I have attached a patch for this, basically I added the line:
arg = WorkbookEvaluator.dereferenceResult(arg, srcCellRow, srcCellCol);

I do not know if this is the correct way to do this but it works. Also added a
test case that fails with the old Iferror.java and works with the new one.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 54402] [PATCH] Bug in IFERROR

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54402

Nick Burch <ap...@gagravarr.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Thanks for this, patch applied (with a minor docs tweak) in r1431403.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org