https://bz.apache.org/bugzilla/show_bug.cgi?id=65040
Bug ID: 65040
Summary: Cell IFERROR don't work with other formula cells with
POI
Product: POI
Version: 4.1.2-FINAL
Hardware: PC
Status: NEW
Severity: blocker
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 37667
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37667&action=edit
IFERROR Example
When I want to evaluate the formula cell with IFERROR cell, it don't work.
I attached a example Excel File
Ex.
In sheet 1 I got
A2 Cell with IFERROR
=IFERROR(SUM(B2,B3,"Some Error Here",aetezt);0)
In sheet2
I use this IFERROR cell to do a SUM in cell A2:
=SOMME(Sheet1!A2,Sheet1!C2,Sheet1!C3)
POI can't return the result of sheet2 A2 correctly:
Value Actual with POI : 0
Expected Value : 7
Could you please check this and correct it please ?
Best regards,
Yiao SUN
--
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]
