Did you explicitly evaluate the cell? The example page on the website shows how to do that. The cached numeric value would only be useful _after_ you explicitly call evaluate(cell). At that point you also would be able to just use the evaluation result directly.
On Wed, Apr 10, 2019 at 10:30 AM Kumar Thotapally <kthotapa...@emmes.com> wrote: > I used getCachedFormulaResultType() and it returned the type to be Numeric > and numeric cell value returned a value 0.0 which is incorrect. > > When I get string value of the cell, it is returning reference to > calculation formula on a separate sheet within the workbook. > > In this particular spreadsheet, I know all the cells that are of type > formula. I am having difficulty getting the formula evaluated. > > > > -- > Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html