apache poi - POI formula evaluation performance -

i using xls format of excel file consists of formula in it. evaluating formula using formulaevaluator.evaluateformulacellenum() method (i using poi 3.16) taking around 10sec evaluate formula in cell. tried hssfworkbook.evaluateallformulacells degrading performance. there way can improve time taken formula evaluation poi. help. using jdk6 , running on tomcat7.

i use formulaevaluator class , works fast , fine, both hssf , xssf. example :

formulaevaluator eval = workbook.getcreationhelper().createformulaevaluator(); cellvalue cellvalue = eval.evaluate(cell);