poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56499] IFERROR fails when written to spreadsheet
Date Mon, 12 May 2014 16:54:34 GMT

--- Comment #4 from Rick <rick@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 correct.

2. Evaluated before write.  Got an evaluator: 
FormulaEvaluator    evaluator =

After setting cell formula, called evaluator.evaluate() for each cell.

No change to behavior.

3. After the evaluation (in step 2), wrote the spreadsheet, no change to

You are receiving this mail because:
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message