public final void reCalc ( ) { parent . getFormulaEvaluator ( ) . clearAllCachedResultValues ( ) ; try { parent . getFormulaEvaluator ( ) . evaluateAll ( ) ; } catch ( Exception ex ) { // skip the formula exception when recalc but log it LOG . log ( Level . SEVERE , " recalc formula error : " + ex . getLocalizedMessage ( ) , ex ) ; } }
recalc whole workbook .