title: GemBox Retrieving Calculated Values From a Spreadsheet or Flexcel
body: <p>According to their docs: GemBox.Spreadsheet can read and write formulas, but can not calculate formula results. When you open a XLS file in MS Excel, formula results will be calculated automaticaly.</p>
  
  <p>So if i create a spreadsheet with some injected values and save it to disk if i open the file in excel i can see the calculated values..</p>
  
  <p>if i open that file in gembox and look up the calculated cell's values i get a result of 0</p>
  
  <p>the same functionality exists in flexcel as well.. can't retrieve the calculated value from a given cell.. it returns zero..</p>
  
  <p>So what I'm doing is:</p>
  
  <ol>
  <li>Open an existing excel file</li>
  <li>Putting some numbers in to some cells</li>
  <li>Saving the file to disk under a different name (tried with the same file too)</li>
  <li>Opening the file again and looking in the total column which is a calculated cell</li>
  </ol>
  
  <p>The value is always 0.. I open the file in excel.. the value is calculated as expected.</p>