title: java POI XSSF FormulaEvaluator
body: <p>I am having a problem when i save my new excel file. I want it that when it gets saved the formula calculates itself but at the moment it is just returning a string in the excel file. The formula is correct. I don't know exactly to get the <code>FormulaEvaluator</code> to work.</p>
  
  <p>Here is where I enter my formula that returns a string:</p>
  
  <pre><code>dataRow1.createCell((short)5).setCellValue("=VLOOKUP(A"+rowCountVlookup+",'C:\\Users\\Admin\\Documents\\JCreator LE\\MyProjects\\WordCount\\classes\\[Pricing.xlsx]Sheet1'!$B$3:$E$41,4, FALSE)*E"+rowCountVlookup+"");
  </code></pre>
  
  <p>Any help would be much appreciated.</p>