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
https://issues.apache.org/bugzilla/show_bug.cgi?id=56499

--- 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 =
row.getSheet().getWorkbook().getCreationHelper().createFormulaEvaluator();

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
behavior.

-- 
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


Mime
View raw message