Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: [Bug 55185] ISNUMBER function doesn't work in if statement
Date: Tue, 09 Jul 2013 09:28:35 +0000
Message-ID: <bug-55185-47293-Yx1aiLINMh@https.issues.apache.org/bugzilla/>
In-Reply-To: <bug-55185-47293@https.issues.apache.org/bugzilla/>
References: <bug-55185-47293@https.issues.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Auto-Submitted: auto-generated
MIME-Version: 1.0

https://issues.apache.org/bugzilla/show_bug.cgi?id=3D55185

--- 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
> >=20
> > See http://poi.apache.org/spreadsheet/eval.html for instructions on how=
 to
> > do this
>=20
> Great!!
>  It works with HSSFFormulaEvaluator.evaluateAllFormulaCells(myWorkBook).
>=20
> 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".
>=20
> Thanks a lot !
>=20
> Stephane

Hello,

I dont't know what I've changed since last Tuesday but I doesn't work anymo=
re.
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 formu=
la
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=C3=A9phane Rousseau

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