Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
MIME-Version: 1.0
References: <CAEwphwqvnA2=zXzuVVNJY=dm6nHS6XdfL+wC0BBP7OuW5Uro2A@mail.gmail.com>
 <CAFGkfm1yu1AUEKPviXHQqFUysW_tnuG15=DdgrTn7N0ocJe=gQ@mail.gmail.com>
 <CAEwphwq83UJwfVGcRgZP0iAODKMOfc1KZNtT2k4Cm-uQV2MnOg@mail.gmail.com>
 <CAFGkfm3D-JHd=SY2OTyKe2a+R3hTHb9CR5wxef2rX0To8p-vSg@mail.gmail.com>
 <CAEwphwoCqF-jZWMBx9O2hnVvREsgqKDgxGwcHtxzcwA6XABLKQ@mail.gmail.com>
 <CAFGkfm227KvARS6dandwmZdLEFvVfa-Y-rkVVtRLy+TQ5PGGBA@mail.gmail.com>
 <DM5PR09MB1194A107D438F8DFBD4697CFC7050@DM5PR09MB1194.namprd09.prod.outlook.com>
 <CAFGkfm3w6JpSQK+B8_1MrePA8+OMengM05L4Vvwtp-4bM3s6jw@mail.gmail.com>
In-Reply-To: <CAFGkfm3w6JpSQK+B8_1MrePA8+OMengM05L4Vvwtp-4bM3s6jw@mail.gmail.com>
From: Greg Woolsey <greg.woolsey@gmail.com>
Date: Wed, 19 Apr 2017 22:26:39 +0000
Message-ID: <CAEwphwpwJvdYrprEBUUsZGiK=OXTszmsjnmUpY3VR+fhv+1oZQ@mail.gmail.com>
Subject: Re: Evaluating Arbitrary Formula
To: POI Users List <user@poi.apache.org>
Content-Type: multipart/alternative; boundary=001a11c14b58453c5d054d8c85bc
archived-at: Wed, 19 Apr 2017 22:26:58 -0000

--001a11c14b58453c5d054d8c85bc
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

The class is org.apache.poi.ss.formula.ConditionalFormattingEvaluator in
poi-3.16.jar.

Use is something like this:

WorkbookEvaluatorProvider wbEvalProv =3D (WorkbookEvaluatorProvider)
workbook.getCreationHelper().createFormulaEvaluator();
ConditionalFormattingEvaluator cfEval =3D new
ConditionalFormattingEvaluator(workbook, wbEvalProv);
// if cell values have changed, clear cached format results
cfEvaluator.clearAllCachedValues();
List<EvaluationConditionalFormatRule> rules =3D
cfEvaluator.getConditionalFormattingForCell(cell);
// check rules list for null, do what you want with results
// EvaluationConditionalFormatRule provides a more user-friendly API to the
disparate underlying elements for a given match


On Wed, Apr 19, 2017 at 2:28 PM Blake Watson <blake.watson@pnmac.com> wrote=
:

> Greg,
> =E2=80=8B
> =E2=80=8BI'm having trouble figuring out how to use the conditional stuff=
. =E2=80=8BI can't
> seem to =3Dfind=3D ConditionalFormattingEvaluator in the POI jar.
>
> If I could find it, I'm not sure how I'd use it:
>
> ec =3D ConditionalFormattingEvaluator(Workbook wb, WorkbookEvaluatorProvi=
der
> provider);
>
> How do I create "provider"? I don't get the "IStabilityClass" thing.
>
> Once having it, I would guess I call:
>
> list =3D ec.getConditionalFormattingForCell(someCell);
>
> and for each item in the list:
>
> fmt =3D item.getFormatting();
>
> But does getConditionalFormattingForCell return all the formats POSSIBLE =
or
> only the ones that apply based on the spreadsheet's current state? And if
> the former, how do I eliminate the ones that apply?
>
> I feel like I'm looking completely in the wrong direction, but I haven't
> been able to locate any examples of how to use this.
>

--001a11c14b58453c5d054d8c85bc--