title: C# EPPLUS can't get cell value
body: <p>I have Cell "A1" with the value of 1.00, set by a formula</p>
  
  <p>I want to save this value to a variable.</p>
  
  <p>I tried:</p>
  
  <pre><code>ws.Cells["A1"].Value
  ws.Cells["A1"].Text
  ws.Cells["A1"].GetValue&lt;double&gt;
  ws.Cells["A1"].Value.ToString()
  </code></pre>
  
  <p>None of these work as I either get an error or I don't get my number at all (console.writeline outputs a blank).</p>
  
  <p>I tried searching online and I get what I tried above. I know I'm referencing the cell correctly because I can actually set the value just fine.</p>
  
  <p>So how do I actually get my value of 1.00 and save it in a double variable?</p>
  
  <p>EDIT: my code, where the worksheet in the filePath has "A1" value of 1.00</p>
  
  <pre><code>using (var pck = new ExcelPackage(filePath))
  {
     var ws = pck.Workbook.Worksheets[1];
  
     var test1 = ws.Cells["A1"].Value;
     var test2 = ws.Cells["A1"].Text;
     var test3 = ws.Cells["A1"].GetValue&lt;double&gt;();
  
     Console.WriteLine(test1);
     Console.WriteLine(test2);
     Console.WriteLine(test3);
   }
  </code></pre>
  
  <p>output is:</p>
  
  <pre><code>[blank]
  [blank]
  0
  </code></pre>
  
  <p>EDIT2: The value of 1.00 is from a formula</p>