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
https://issues.apache.org/bugzilla/show_bug.cgi?id=55185

--- 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

Hello,

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
cell.

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

I run Excel 2010 with HSSFWorkbook.

So, if anybody has idea ...

Regards

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


Mime
View raw message