https://issues.apache.org/bugzilla/show_bug.cgi?id=56499
--- Comment #2 from Rick <[email protected]> --- I have the following code: Cell new_desc_cell = row.createCell(desc_col, Cell.CELL_TYPE_FORMULA); String desc_lookup = "VLOOKUP(" + colnumToName(key_col) + (row.getRowNum() + 1) + ",Desc!$a$2:$c$"+ desc_row_count + ",2,false)"; new_desc_cell.setCellFormula("IF(ISERROR(" + desc_lookup + "),\"\"," + desc_lookup + ")"); The formula is at least parsing, because it throws an error if the formula has an error. I'm not explicitly evaluating the formula. As you can see, I worked around the problem by using IF(ISERROR()) in place of IFERROR(). -- 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]
