Saturday, July 7, 2012

Formula Evaluation in Apache POI (or jxls)

Wasted an afternoon on this. If you create formulas in Apache POI or jxls, you need to force Excel to recalculate, otherwise you get the value from your template.  See link below !

Formula Evaluation: wb.setForceFormulaRecalculation(true);