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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
