[Bug 56499] IFERROR fails when written to spreadsheet

https://bz.apache.org/bugzilla/show_bug.cgi?id=56499 Dominik Stadler changed: What|Removed |Added Attachment #31611|0 |1 is

[Bug 56499] IFERROR fails when written to spreadsheet

https://bz.apache.org/bugzilla/show_bug.cgi?id=56499 --- Comment #8 from Dominik Stadler --- Some analysis: * IFERROR is not part of the default set of Excel functions, but is marked as "external" in the parsed formula: Ptg[7]=org.apache.poi.ss.formula.ptg.FuncVarPtg

[Bug 56499] IFERROR fails when written to spreadsheet

https://issues.apache.org/bugzilla/show_bug.cgi?id=56499 --- Comment #2 from Rick r...@wisefam.com --- I have the following code: Cellnew_desc_cell = row.createCell(desc_col, Cell.CELL_TYPE_FORMULA); Stringdesc_lookup = VLOOKUP( + colnumToName(key_col) + (row.getRowNum() + 1)

[Bug 56499] IFERROR fails when written to spreadsheet

https://issues.apache.org/bugzilla/show_bug.cgi?id=56499 Nick Burch apa...@gagravarr.org changed: What|Removed |Added Status|NEW |NEEDINFO ---

[Bug 56499] IFERROR fails when written to spreadsheet

https://issues.apache.org/bugzilla/show_bug.cgi?id=56499 --- Comment #3 from Nick Burch apa...@gagravarr.org --- A few things to try: * Write the iferror formula, save, load, see if POI sees the formula string correctly * Evaluate, see it it works * Evaluate, save, see if Excel is then happy

[Bug 56499] IFERROR fails when written to spreadsheet

https://issues.apache.org/bugzilla/show_bug.cgi?id=56499 Rick r...@wisefam.com changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #7 from

[Bug 56499] IFERROR fails when written to spreadsheet

https://issues.apache.org/bugzilla/show_bug.cgi?id=56499 --- Comment #6 from Rick r...@wisefam.com --- Created attachment 31611 -- https://issues.apache.org/bugzilla/attachment.cgi?id=31611action=edit Example code -- You are receiving this mail because: You are the assignee for the bug.

[Bug 56499] IFERROR fails when written to spreadsheet

https://issues.apache.org/bugzilla/show_bug.cgi?id=56499 --- Comment #5 from Rick r...@wisefam.com --- Created attachment 31610 -- https://issues.apache.org/bugzilla/attachment.cgi?id=31610action=edit Resulting spreadsheet -- You are receiving this mail because: You are the assignee for the

[Bug 56499] IFERROR fails when written to spreadsheet

https://issues.apache.org/bugzilla/show_bug.cgi?id=56499 --- Comment #4 from Rick r...@wisefam.com --- 1. Wrote the formula, reloaded it. Got back: Formula: IFERROR(VLOOKUP(A6,Desc!$A$2:$C$42,2,FALSE),) Value: Use default names - New list of Store names provided in operations The values are

[Bug 56499] IFERROR fails when written to spreadsheet

https://issues.apache.org/bugzilla/show_bug.cgi?id=56499 Rick r...@wisefam.com changed: What|Removed |Added CC||r...@wisefam.com