title: Can EPPlus distinguish between blank cells and empty text cells in an Excel worksheet?
body: <p>I'm using the EPPlus .NET library (v4.0.4) to interpret saved Excel workbooks. In one such worksheet, some empty cells have been set to 'text' format using the Excel 'apostrophe' trick (that is, the user has entered a single apostrophe in those cells, so that Excel will display them as blank).</p>
  
  <p>Sample XML for two such cells is as follows:</p>
  
  <pre><code>  &lt;c r="F6" s="1" t="inlineStr"&gt;
      &lt;is&gt;
        &lt;t /&gt;
      &lt;/is&gt;
    &lt;/c&gt;
    &lt;c r="G6" s="1" /&gt;
  </code></pre>
  
  <p>Here, F6 has an apostrophe (i.e. is an empty text cell) and G6 is genuinely blank.</p>
  
  <p>Is is possible to read this 'inline string' (<code>inlineStr</code>) property using EPPlus or otherwise distinguish between these two cells? The ExcelRange / ExcelRangeBase classes have properties such as <code>Value</code>, <code>Formula</code>, <code>Style</code> etc but when examining objects representing the two cells above I can't see any difference between them.</p>
  
  <p>I know I could do this manually by reading the raw XML or by using an alternative library (maybe ClosedXML or similar), but if at all possible I would like to do this using EPPlus.</p>