How to get the cell unformatted value in POI XSSF event model?
<p>cell A1 has the <strong><em>formula "=A2"</em></strong> and is formatted to show 1 decimal point</p>

<p>cell A2 has the <strong><em>value 4.23</em></strong></p>

<p>cell A1 shows 4.2  (formatted display value)</p>

<p>cell A2 shows 4.23 (formatted display value)</p>

<p>My XSSF eventmodel sheetContentHandler class implements </p>

<blockquote>
  <p>public void cell(String cellReference, String formattedValue,
  XSSFComment comment)</p>
</blockquote>

<p>but formattedValue returns 4.2 for cell A1, and i want to retrieve the <strong>unformattedValue</strong> 4.23</p>

<p>How can i do this ?
(I can't change to usermodel, i have huge files)</p>