This is in the nightly builds now and the upcoming 3.16 release. It probably should go in the release notes/change log on the web site, but hasn't yet.
The main change was revision r1782894 [1] in reference to issue 58131 [2]. There is now a ConditionalFormattingEvaluator class [3] to support these. You can see one use in the unit test [4], which uses a sample workbook [5] built from the publicly available Excel help examples for conditional formatting. For evaluating other arbitrary expressions, there are new variations of WorkbookEvaluator.evaluate(...) [6] to support these, which are used by the conditional formatting evaluator as well. Check out the code, JavaDocs, and tests, and feel free to ask questions and give any feedback you have. [1] https://svn.apache.org/viewvc?view=rev&rev=1782894 [2] https://bz.apache.org/bugzilla/show_bug.cgi?id=58131 [3] https://poi.apache.org/apidocs/org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html [4] http://svn.apache.org/repos/asf/poi/trunk/src/ooxml/testcases/org/apache/poi/ss/usermodel/ConditionalFormattingEvalTest.java [5] http://svn.apache.org/repos/asf/poi/trunk/test-data/spreadsheet/ConditionalFormattingSamples.xlsx [6] https://poi.apache.org/apidocs/org/apache/poi/ss/formula/WorkbookEvaluator.html > All of the evaluation stuff I can find works on a Cell object. I thought I > had seen something for evaluation of formula strings but I don't see it in > the FormulaEvaluator class (where I thought I had before). > > I feel like we might have to use the ?00BFormulaParser to get the Ptg[] but > I'm not sure what we do at that point. > > Hints? > > -- > > *Blake Watson* > > *PNMAC* > Application Development Manager > 5898 Condor Drive > Moorpark, CA 93021 > (805) 330.4911 x7742 > blake.wat...@pnmac.com <melanie.petros...@pnmac.com> > www.PennyMacUSA.com <http://www.pennymacusa.com/> > ransaction_X�u� �?
