title: JXL Named Area Formulas Display the Incorrect Value
body: <p>I am using JXL to write an Excel report. I need to use named areas for the report, and have formulas based off of them. However, when the Excel file loads, the values displayed are incorrect. If I click on the cell, and hit enter, the value changes and is correct. I can't figure out how to make the value appear correctly on load. Does anyone know a way to force Excel to re-evaluate, or to provide a default value for the Formula?</p>
  
  <p>Below is a simplified version of my code:</p>
  
  <pre><code>excelWorkbook.addNameArea("NamedArea", excelSheet, column1, row1, column2, row2);
  Formula formula = new Formula(columnNumber, rowNumber, "COUNT(NamedArea)");
  excelSheet.addCell(formula);
  </code></pre>