java - Recalculating formulas in spreadsheet using Apache POI -

i'm trying use poi xssf evaluate excel formulas. values not have saved, , may have calculate many formulas, i'm trying in same cell.

the problem cell value seems stuck on first formula entered after recalculate

formulaevaluator evaluator = wb.getcreationhelper().createformulaevaluator(); xssfcell formulacell = row.createcell(6); formulacell.setcellformula("date(2011,10,6)"); cellvalue cellvalue = evaluator.evaluate(formulacell); system.out.println(cellvalue.getnumbervalue());  formulacell.setcellformula("date(1911,3,4)"); cellvalue = evaluator.evaluate(formulacell); system.out.println(cellvalue.getnumbervalue()); 

this outputs 40822.0 40822.0 (excel equivalent of 10/6/2011) both times instead of reevaluating new formula.

if use formulaevaluator more once, need line in between uses, or else uses same result each time.

formulaevaluator.clearallcachedresultvalues()