poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55185] ISNUMBER function doesn't work in if statement
Date Tue, 09 Jul 2013 09:28:35 GMT

--- Comment #3 from srousseau@sodifrance.fr ---
(In reply to srousseau from comment #2)
> (In reply to Nick Burch from comment #1)
> > After changing a formula, you must trigger a recalculation to ensure the
> > cached value is correctly stored/set in the file
> > 
> > See http://poi.apache.org/spreadsheet/eval.html for instructions on how to
> > do this
> Great!!
>  It works with HSSFFormulaEvaluator.evaluateAllFormulaCells(myWorkBook).
> I upgrade from POI 3.0 to POI 3.9 and I didn't need to call this code. So I
> didn't know about "Formula Evaluation".
> Thanks a lot !
> Stephane


I dont't know what I've changed since last Tuesday but I doesn't work anymore.
I now see "toto" as result.
I'm using HSSFFormulaEvaluator.evaluateAllFormulaCells(book.getWorkbook()); and
book.getWorkbook().setForceFormulaRecalculation(true); but the cell value is
not refreshed. But I can see the call to evaluateFormulaCell for each formula

In excel, I have to click in the cell to refresh the cell value as in the

I run Excel 2010 with HSSFWorkbook.

So, if anybody has idea ...


St├ęphane Rousseau

You are receiving this mail because:
You are the assignee for the bug.
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message