https://issues.apache.org/bugzilla/show_bug.cgi?id=56499
Bug ID: 56499
Summary: IFERROR fails when written to spreadsheet
Product: POI
Version: 3.10
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
I'm building a spreadsheet and adding a formula to a cell.
If I do:
new_desc_cell.setCellFormula("IF(ISERROR(VLOOKUP(A5,Desc!$a$4:$c$60,2,false)),\"\",VLOOKUP(A5,Desc!$a$4:$c$60,2,false))");
it works.
If I do:
new_desc_cell.setCellFormula("IFERROR(VLOOKUP(A5,Desc!$a$4:$c$60,2,false),\"\")");
it appears to work, but when I open the spreadsheet in Excel 2010, I get a
#NAME? error. If I do a global replace of "IFERROR" with "IFERROR" (same
text), the problem goes away.
I can use the first as a workaround, of course.
--
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]
