Created attachment 37667 [details] 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
my college added tests and example in ticket https://bz.apache.org/bugzilla/show_bug.cgi?id=65058 and https://bz.apache.org/bugzilla/show_bug.cgi?id=65059