poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Woolsey <greg.wool...@gmail.com>
Subject Re: Cell Calculations by reference to other cells in hidden sheets within the same workbook
Date Wed, 10 Apr 2019 17:43:43 GMT
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 <kthotapally@emmes.com>

> 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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message