title: Apache POI Formula Evaluator not computing cell containing formula
body: <p>I have an excel file that has formulas in some cells and some input fields based on which value is being computed in the Formula Cell.</p>
  
  <p>After setting the values in the respective cells using apache poi <code>setCellValue()</code> <strong>The Values are being set in the excel. This part is working</strong>. Then I am running </p>
  
  <pre><code>FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
  evaluator.evaluate(cell);
  </code></pre>
  
  <p>where the cell is the place where I have the formula and also it has some pre-computed value.</p>
  
  <p>My problem was that, after running the <code>FormulaEvaluator</code> when I am fetching the cell value using <code>cell.getNumericCellValue()</code> it is fetching me the pre-computed or older cell value instead of new computed values from the new values set in the cells.</p>