title: How to read result of HYPERLINK() function in POI
body: <p>Apache Poi can evaluate and return results of functions in formulas. However for the special function HYPERLINK(), it only returns the "display value", not the actual calculated hyperlink value. </p>
  
  <p>I have an Excel file which contains complex computed hyperlinks which combine results from a number of different fields in the workbook, thus it would be nice to be able to read the resulting URL for the hyperlink, however with default <a href="http://poi.apache.org/spreadsheet/eval.html" rel="nofollow">formula evaluation</a> I only get the "display value", not the actual URL.</p>
  
  <p>Is there a way I can compute the formula in a way so I can read the actual URL?</p>