poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1782942 [2/10] - in /poi/site/publish/apidocs: ./ org/apache/poi/hssf/usermodel/ org/apache/poi/hssf/util/ org/apache/poi/ss/class-use/ org/apache/poi/ss/formula/ org/apache/poi/ss/formula/class-use/ org/apache/poi/ss/formula/eval/class-us...
Date Tue, 14 Feb 2017 09:47:19 GMT
Modified: poi/site/publish/apidocs/index-all.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/index-all.html?rev=1782942&r1=1782941&r2=1782942&view=diff
==============================================================================
--- poi/site/publish/apidocs/index-all.html (original)
+++ poi/site/publish/apidocs/index-all.html Tue Feb 14 09:47:17 2017
@@ -1432,6 +1432,14 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/FormulaShifter.html#adjustFormula(org.apache.poi.ss.formula.ptg.Ptg[],%20int)">adjustFormula(Ptg[], int)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html#adjustRegionRelativeReference(org.apache.poi.ss.formula.ptg.Ptg[],%20org.apache.poi.ss.util.CellReference,%20org.apache.poi.ss.util.CellRangeAddressBase)">adjustRegionRelativeReference(Ptg[], CellReference, CellRangeAddressBase)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html" title="class in org.apache.poi.ss.formula">WorkbookEvaluator</a></dt>
+<dd>
+<div class="block">Adjust formula relative references by the offset between the start of the given region and the given target cell.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html#adjustRegionRelativeReference(org.apache.poi.ss.formula.ptg.Ptg[],%20int,%20int)">adjustRegionRelativeReference(Ptg[], int, int)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html" title="class in org.apache.poi.ss.formula">WorkbookEvaluator</a></dt>
+<dd>
+<div class="block">Adjust the formula relative cell references by a given delta</div>
+</dd>
 <dt><a href="./org/apache/poi/sl/draw/geom/AdjustValue.html" title="class in org.apache.poi.sl.draw.geom"><span class="strong">AdjustValue</span></a> - Class in <a href="./org/apache/poi/sl/draw/geom/package-summary.html">org.apache.poi.sl.draw.geom</a></dt>
 <dd>
 <div class="block">Represents a shape adjust values (see section 20.1.9.5 in the spec)</div>
@@ -5047,6 +5055,11 @@
 <dd>
 <div class="block">Clear all content types.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#clearAllCachedFormats()">clearAllCachedFormats()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>
+<div class="block">Call this whenever rules are added, reordered, or removed, or a rule formula is changed 
+ (not the formula inputs but the formula expression itself)</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#clearAllCachedResultValues()">clearAllCachedResultValues()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFEvaluationWorkbook</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/BaseFormulaEvaluator.html#clearAllCachedResultValues()">clearAllCachedResultValues()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/BaseFormulaEvaluator.html" title="class in org.apache.poi.ss.formula">BaseFormulaEvaluator</a></dt>
@@ -5073,6 +5086,13 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFEvaluationWorkbook.html#clearAllCachedResultValues()">clearAllCachedResultValues()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFEvaluationWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFEvaluationWorkbook</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#clearAllCachedValues()">clearAllCachedValues()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>
+<div class="block">Call this whenever cell values change in the workbook, so condional formats are re-evaluated 
+ for all cells.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#clearAllCachedValues()">clearAllCachedValues()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/util/BitField.html#clearByte(byte)">clearByte(byte)</a></span> - Method in class org.apache.poi.util.<a href="./org/apache/poi/util/BitField.html" title="class in org.apache.poi.util">BitField</a></dt>
 <dd>
 <div class="block">Clear the bits.</div>
@@ -6326,6 +6346,14 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/format/CellNumberStringMod.html#compareTo(org.apache.poi.ss.format.CellNumberStringMod)">compareTo(CellNumberStringMod)</a></span> - Method in class org.apache.poi.ss.format.<a href="./org/apache/poi/ss/format/CellNumberStringMod.html" title="class in org.apache.poi.ss.format">CellNumberStringMod</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#compareTo(org.apache.poi.ss.formula.EvaluationConditionalFormatRule)">compareTo(EvaluationConditionalFormatRule)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>
+<div class="block">Per Excel Help, XSSF rule priority is sheet-wide, not just within the owning ConditionalFormatting object.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html#compareTo(org.apache.poi.ss.formula.EvaluationConditionalFormatRule.ValueAndFormat)">compareTo(EvaluationConditionalFormatRule.ValueAndFormat)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.ValueAndFormat</a></dt>
+<dd>
+<div class="block">Note: this class has a natural ordering that is inconsistent with equals.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/util/CellAddress.html#compareTo(org.apache.poi.ss.util.CellAddress)">compareTo(CellAddress)</a></span> - Method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a></dt>
 <dd>
 <div class="block">Compare this CellAddress using the "natural" row-major, column-minor ordering.</div>
@@ -6462,6 +6490,14 @@
 <dd>
 <div class="block">The ConditionalFormatting class encapsulates all settings of Conditional Formatting.</div>
 </dd>
+<dt><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula"><span class="strong">ConditionalFormattingEvaluator</span></a> - Class in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>
+<div class="block">Evaluates Conditional Formatting constraints.<p/>
+
+ For performance reasons, this class keeps a cache of all previously evaluated rules and cells.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#ConditionalFormattingEvaluator(org.apache.poi.ss.usermodel.Workbook,%20org.apache.poi.ss.formula.WorkbookEvaluatorProvider)">ConditionalFormattingEvaluator(Workbook, WorkbookEvaluatorProvider)</a></span> - Constructor for class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>&nbsp;</dd>
 <dt><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">ConditionalFormattingRule</span></a> - Interface in <a href="./org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></dt>
 <dd>
 <div class="block">Represents a description of a conditional formatting rule</div>
@@ -6482,6 +6518,15 @@
 </dd>
 <dt><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingThreshold.RangeType.html" title="enum in org.apache.poi.ss.usermodel"><span class="strong">ConditionalFormattingThreshold.RangeType</span></a> - Enum in <a href="./org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></dt>
 <dd>&nbsp;</dd>
+<dt><a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">ConditionFilterData</span></a> - Interface in <a href="./org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></dt>
+<dd>
+<div class="block">These values are needed by various conditional formatting evaluation filter types</div>
+</dd>
+<dt><a href="./org/apache/poi/ss/usermodel/ConditionFilterType.html" title="enum in org.apache.poi.ss.usermodel"><span class="strong">ConditionFilterType</span></a> - Enum in <a href="./org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></dt>
+<dd>
+<div class="block">Used primarily for XSSF conditions, which defines a multitude of additional "filter" types
+ for conditional formatting.</div>
+</dd>
 <dt><a href="./org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel"><span class="strong">ConditionType</span></a> - Class in <a href="./org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></dt>
 <dd>
 <div class="block">Represents a type of a conditional formatting rule</div>
@@ -11185,6 +11230,26 @@
 <dd>
 <div class="block">ValidationType enum</div>
 </dd>
+<dt><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula"><span class="strong">DataValidationEvaluator</span></a> - Class in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>
+<div class="block">Evaluates Data Validation constraints.<p/>
+
+ For performance reasons, this class keeps a cache of all previously retrieved <a href="./org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel"><code>DataValidation</code></a> instances.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#DataValidationEvaluator(org.apache.poi.ss.usermodel.Workbook,%20org.apache.poi.ss.formula.WorkbookEvaluatorProvider)">DataValidationEvaluator(Workbook, WorkbookEvaluatorProvider)</a></span> - Constructor for class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>&nbsp;</dd>
+<dt><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula"><span class="strong">DataValidationEvaluator.DataValidationContext</span></a> - Class in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#DataValidationEvaluator.DataValidationContext(org.apache.poi.ss.usermodel.DataValidation,%20org.apache.poi.ss.formula.DataValidationEvaluator,%20org.apache.poi.ss.util.CellRangeAddressBase,%20org.apache.poi.ss.util.CellReference)">DataValidationEvaluator.DataValidationContext(DataValidation, DataValidationEvaluator, CellRangeAddressBase, CellReference)</a></span> - Constructor for class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
+<dt><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.OperatorEnum.html" title="enum in org.apache.poi.ss.formula"><span class="strong">DataValidationEvaluator.OperatorEnum</span></a> - Enum in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>
+<div class="block">Not calling it OperatorType to avoid confusion for now with DataValidationConstraint.OperatorType.</div>
+</dd>
+<dt><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.ValidationEnum.html" title="enum in org.apache.poi.ss.formula"><span class="strong">DataValidationEvaluator.ValidationEnum</span></a> - Enum in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>
+<div class="block">Not calling it ValidationType to avoid confusion for now with DataValidationConstraint.ValidationType.</div>
+</dd>
 <dt><a href="./org/apache/poi/ss/usermodel/DataValidationHelper.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">DataValidationHelper</span></a> - Interface in <a href="./org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></dt>
 <dd>&nbsp;</dd>
 <dt><a href="./org/apache/poi/hssf/record/aggregates/DataValidityTable.html" title="class in org.apache.poi.hssf.record.aggregates"><span class="strong">DataValidityTable</span></a> - Class in <a href="./org/apache/poi/hssf/record/aggregates/package-summary.html">org.apache.poi.hssf.record.aggregates</a></dt>
@@ -13982,6 +14047,12 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/format/CellNumberStringMod.html#equals(java.lang.Object)">equals(Object)</a></span> - Method in class org.apache.poi.ss.format.<a href="./org/apache/poi/ss/format/CellNumberStringMod.html" title="class in org.apache.poi.ss.format">CellNumberStringMod</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#equals(java.lang.Object)">equals(Object)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>
+<div class="block">Defined as equal sheet name and formatting and rule indexes</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html#equals(java.lang.Object)">equals(Object)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.ValueAndFormat</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ExcelStyleDateFormatter.html#equals(java.lang.Object)">equals(Object)</a></span> - Method in class org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ExcelStyleDateFormatter.html" title="class in org.apache.poi.ss.usermodel">ExcelStyleDateFormatter</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/util/CellAddress.html#equals(java.lang.Object)">equals(Object)</a></span> - Method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a></dt>
@@ -14454,6 +14525,8 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/eval/UnaryPlusEval.html#evaluate(int,%20int,%20org.apache.poi.ss.formula.eval.ValueEval)">evaluate(int, int, ValueEval)</a></span> - Method in class org.apache.poi.ss.formula.eval.<a href="./org/apache/poi/ss/formula/eval/UnaryPlusEval.html" title="class in org.apache.poi.ss.formula.eval">UnaryPlusEval</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueFunction.html#evaluate(java.util.List)">evaluate(List&lt;EvaluationConditionalFormatRule.ValueAndFormat&gt;)</a></span> - Method in interface org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueFunction.html" title="interface in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.ValueFunction</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/functions/Address.html#evaluate(org.apache.poi.ss.formula.eval.ValueEval[],%20int,%20int)">evaluate(ValueEval[], int, int)</a></span> - Method in class org.apache.poi.ss.formula.functions.<a href="./org/apache/poi/ss/formula/functions/Address.html" title="class in org.apache.poi.ss.formula.functions">Address</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/functions/Bin2Dec.html#evaluate(int,%20int,%20org.apache.poi.ss.formula.eval.ValueEval)">evaluate(int, int, ValueEval)</a></span> - Method in class org.apache.poi.ss.formula.functions.<a href="./org/apache/poi/ss/formula/functions/Bin2Dec.html" title="class in org.apache.poi.ss.formula.functions">Bin2Dec</a></dt>
@@ -14741,6 +14814,16 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html#evaluate(org.apache.poi.ss.formula.EvaluationCell)">evaluate(EvaluationCell)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html" title="class in org.apache.poi.ss.formula">WorkbookEvaluator</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html#evaluate(java.lang.String,%20org.apache.poi.ss.util.CellReference)">evaluate(String, CellReference)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html" title="class in org.apache.poi.ss.formula">WorkbookEvaluator</a></dt>
+<dd>
+<div class="block">Evaluate a formula outside a cell value, e.g.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html#evaluate(java.lang.String,%20org.apache.poi.ss.util.CellReference,%20org.apache.poi.ss.util.CellRangeAddressBase)">evaluate(String, CellReference, CellRangeAddressBase)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/WorkbookEvaluator.html" title="class in org.apache.poi.ss.formula">WorkbookEvaluator</a></dt>
+<dd>
+<div class="block">Some expressions need to be evaluated in terms of an offset from the top left corner of a region,
+ such as some data validation and conditional format expressions, when those constraints apply
+ to contiguous cells.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/FormulaEvaluator.html#evaluate(org.apache.poi.ss.usermodel.Cell)">evaluate(Cell)</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/FormulaEvaluator.html" title="interface in org.apache.poi.ss.usermodel">FormulaEvaluator</a></dt>
 <dd>
 <div class="block">If cell contains a formula, the formula is evaluated and returned,
@@ -14858,6 +14941,29 @@
 <dd>
 <div class="block">Abstracts a cell for the purpose of formula evaluation.</div>
 </dd>
+<dt><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula"><span class="strong">EvaluationConditionalFormatRule</span></a> - Class in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>
+<div class="block">Abstracted and cached version of a Conditional Format rule for use with a
+ <a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula"><code>ConditionalFormattingEvaluator</code></a>.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#EvaluationConditionalFormatRule(org.apache.poi.ss.formula.WorkbookEvaluator,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.ConditionalFormatting,%20int,%20org.apache.poi.ss.usermodel.ConditionalFormattingRule,%20int,%20org.apache.poi.ss.util.CellRangeAddress[])">EvaluationConditionalFormatRule(WorkbookEvaluator, Sheet, ConditionalFormatting, int, ConditionalFormattingRule, int, CellRangeAddress[])</a></span> - Constructor for class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
+<dt><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.OperatorEnum.html" title="enum in org.apache.poi.ss.formula"><span class="strong">EvaluationConditionalFormatRule.OperatorEnum</span></a> - Enum in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>
+<div class="block">Not calling it OperatorType to avoid confusion for now with other classes.</div>
+</dd>
+<dt><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html" title="class in org.apache.poi.ss.formula"><span class="strong">EvaluationConditionalFormatRule.ValueAndFormat</span></a> - Class in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>
+<div class="block">Note: this class has a natural ordering that is inconsistent with equals.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html#EvaluationConditionalFormatRule.ValueAndFormat(java.lang.Double,%20java.lang.String)">EvaluationConditionalFormatRule.ValueAndFormat(Double, String)</a></span> - Constructor for class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.ValueAndFormat</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html#EvaluationConditionalFormatRule.ValueAndFormat(java.lang.String,%20java.lang.String)">EvaluationConditionalFormatRule.ValueAndFormat(String, String)</a></span> - Constructor for class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.ValueAndFormat</a></dt>
+<dd>&nbsp;</dd>
+<dt><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueFunction.html" title="interface in org.apache.poi.ss.formula"><span class="strong">EvaluationConditionalFormatRule.ValueFunction</span></a> - Interface in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
+<dd>
+<div class="block">instances evaluate the values for a region and return the positive matches for the function type.</div>
+</dd>
 <dt><a href="./org/apache/poi/ss/formula/eval/EvaluationException.html" title="class in org.apache.poi.ss.formula.eval"><span class="strong">EvaluationException</span></a> - Exception in <a href="./org/apache/poi/ss/formula/eval/package-summary.html">org.apache.poi.ss.formula.eval</a></dt>
 <dd>
 <div class="block">This class is used to simplify error handling logic <i>within</i> operator and function
@@ -19008,6 +19114,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xdgf/usermodel/section/geometry/SplineStart.html#getA()">getA()</a></span> - Method in class org.apache.poi.xdgf.usermodel.section.geometry.<a href="./org/apache/poi/xdgf/usermodel/section/geometry/SplineStart.html" title="class in org.apache.poi.xdgf.usermodel.section.geometry">SplineStart</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html#getAboveAverage()">getAboveAverage()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel">ConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html#getAboveAverage()">getAboveAverage()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/eval/AreaEval.html#getAbsoluteValue(int,%20int)">getAbsoluteValue(int, int)</a></span> - Method in interface org.apache.poi.ss.formula.eval.<a href="./org/apache/poi/ss/formula/eval/AreaEval.html" title="interface in org.apache.poi.ss.formula.eval">AreaEval</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html#getAbsoluteValue(int,%20int)">getAbsoluteValue(int, int)</a></span> - Method in class org.apache.poi.ss.formula.eval.<a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html" title="class in org.apache.poi.ss.formula.eval">AreaEvalBase</a></dt>
@@ -20624,6 +20734,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hemf/record/HemfText.ExtTextOutA.html#getBottom()">getBottom()</a></span> - Method in class org.apache.poi.hemf.record.<a href="./org/apache/poi/hemf/record/HemfText.ExtTextOutA.html" title="class in org.apache.poi.hemf.record">HemfText.ExtTextOutA</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html#getBottom()">getBottom()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel">ConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html#getBottom()">getBottom()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/RowRecord.html#getBottomBorder()">getBottomBorder()</a></span> - Method in class org.apache.poi.hssf.record.<a href="./org/apache/poi/hssf/record/RowRecord.html" title="class in org.apache.poi.hssf.record">RowRecord</a></dt>
 <dd>
 <div class="block">A bit that specifies whether any cell in the row has a medium or thick bottom border,
@@ -21344,6 +21458,10 @@
 <dd>
 <div class="block">Get a specific cell from a row.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/SheetUtil.html#getCell(org.apache.poi.ss.usermodel.Sheet,%20int,%20int)">getCell(Sheet, int, int)</a></span> - Static method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/SheetUtil.html" title="class in org.apache.poi.ss.util">SheetUtil</a></dt>
+<dd>
+<div class="block">Return the cell, without taking account of merged regions.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/util/SSCellRange.html#getCell(int,%20int)">getCell(int, int)</a></span> - Method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/SSCellRange.html" title="class in org.apache.poi.ss.util">SSCellRange</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xdgf/usermodel/XDGFShape.html#getCell(java.lang.String)">getCell(String)</a></span> - Method in class org.apache.poi.xdgf.usermodel.<a href="./org/apache/poi/xdgf/usermodel/XDGFShape.html" title="class in org.apache.poi.xdgf.usermodel">XDGFShape</a></dt>
@@ -22798,8 +22916,34 @@
 <dd>
 <div class="block">gets Conditional Formatting object at a particular index</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getConditionalFormattingForCell(org.apache.poi.ss.util.CellReference)">getConditionalFormattingForCell(CellReference)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>
+<div class="block">This checks all applicable <a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel"><code>ConditionalFormattingRule</code></a>s for the cell's sheet, 
+ in defined "priority" order, returning the matches if any.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getConditionalFormattingForCell(org.apache.poi.ss.usermodel.Cell)">getConditionalFormattingForCell(Cell)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>
+<div class="block">This checks all applicable <a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel"><code>ConditionalFormattingRule</code></a>s for the cell's sheet, 
+ in defined "priority" order, returning the matches if any.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/model/InternalSheet.html#getConditionalFormattingTable()">getConditionalFormattingTable()</a></span> - Method in class org.apache.poi.hssf.model.<a href="./org/apache/poi/hssf/model/InternalSheet.html" title="class in org.apache.poi.hssf.model">InternalSheet</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html#getConditionFilterType()">getConditionFilterType()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html" title="class in org.apache.poi.hssf.usermodel">HSSFConditionalFormattingRule</a></dt>
+<dd>
+<div class="block">always null (not a filter condition) or <a href="./org/apache/poi/ss/usermodel/ConditionFilterType.html#FILTER"><code>ConditionFilterType.FILTER</code></a> if it is.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionFilterType()">getConditionFilterType()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></dt>
+<dd>
+<div class="block">This is null if 
+ <p/>
+ <code><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionType()"><code>ConditionalFormattingRule.getConditionType()</code></a> != <a href="./org/apache/poi/ss/usermodel/ConditionType.html#FILTER"><code>ConditionType.FILTER</code></a></code>
+ <p/>
+ This is always <a href="./org/apache/poi/ss/usermodel/ConditionFilterType.html#FILTER"><code>ConditionFilterType.FILTER</code></a> for HSSF rules of type <a href="./org/apache/poi/ss/usermodel/ConditionType.html#FILTER"><code>ConditionType.FILTER</code></a>.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getConditionFilterType()">getConditionFilterType()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionalFormattingRule</a></dt>
+<dd>
+<div class="block">Will return null if <a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getConditionType()"><code>XSSFConditionalFormattingRule.getConditionType()</code></a> != <a href="./org/apache/poi/ss/usermodel/ConditionType.html#FILTER"><code>ConditionType.FILTER</code></a></div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/DVRecord.html#getConditionOperator()">getConditionOperator()</a></span> - Method in class org.apache.poi.hssf.record.<a href="./org/apache/poi/hssf/record/DVRecord.html" title="class in org.apache.poi.hssf.record">DVRecord</a></dt>
 <dd>
 <div class="block">get the condition operator</div>
@@ -25715,6 +25859,10 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/hwpf/model/types/DOPAbstractType.html#getEpc()">getEpc()</a></span> - Method in class org.apache.poi.hwpf.model.types.<a href="./org/apache/poi/hwpf/model/types/DOPAbstractType.html" title="class in org.apache.poi.hwpf.model.types">DOPAbstractType</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html#getEqualAverage()">getEqualAverage()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel">ConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html#getEqualAverage()">getEqualAverage()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/IconMultiStateThreshold.html#getEquals()">getEquals()</a></span> - Method in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/IconMultiStateThreshold.html" title="class in org.apache.poi.hssf.record.cf">IconMultiStateThreshold</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/CellValue.html#getError(int)">getError(int)</a></span> - Static method in class org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/CellValue.html" title="class in org.apache.poi.ss.usermodel">CellValue</a></dt>
@@ -25893,6 +26041,8 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hslf/usermodel/HSLFTextShape.html#getEscherTextboxWrapper()">getEscherTextboxWrapper()</a></span> - Method in class org.apache.poi.hslf.usermodel.<a href="./org/apache/poi/hslf/usermodel/HSLFTextShape.html" title="class in org.apache.poi.hslf.usermodel">HSLFTextShape</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getEvaluator()">getEvaluator()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hwpf/usermodel/HeaderStories.html#getEvenFooter()">getEvenFooter()</a></span> - Method in class org.apache.poi.hwpf.usermodel.<a href="./org/apache/poi/hwpf/usermodel/HeaderStories.html" title="class in org.apache.poi.hwpf.usermodel">HeaderStories</a></dt>
 <dd>
 <div class="block"><span class="strong">Deprecated.</span>
@@ -26713,6 +26863,18 @@
 <dd>
 <div class="block">Returns fill type.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html#getFilterConfiguration()">getFilterConfiguration()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html" title="class in org.apache.poi.hssf.usermodel">HSSFConditionalFormattingRule</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getFilterConfiguration()">getFilterConfiguration()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></dt>
+<dd>
+<div class="block">This is null if 
+ <p/>
+ <code><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionFilterType()"><code>ConditionalFormattingRule.getConditionFilterType()</code></a> == null</code>
+ <p/>
+ This means it is always null for HSSF, which does not define the extended condition types.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getFilterConfiguration()">getFilterConfiguration()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionalFormattingRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hwpf/model/types/PAPAbstractType.html#getFInnerTableCell()">getFInnerTableCell()</a></span> - Method in class org.apache.poi.hwpf.model.types.<a href="./org/apache/poi/hwpf/model/types/PAPAbstractType.html" title="class in org.apache.poi.hwpf.model.types">PAPAbstractType</a></dt>
 <dd>
 <div class="block">When 1, the end of paragraph mark is really an end of cell mark for a nested table cell.</div>
@@ -27881,6 +28043,10 @@
 <dd>
 <div class="block">get the index to the Format record (which FORMAT to use 0-based)</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getFormatRulesForSheet(java.lang.String)">getFormatRulesForSheet(String)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getFormatRulesForSheet(org.apache.poi.ss.usermodel.Sheet)">getFormatRulesForSheet(Sheet)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/common/UnicodeString.html#getFormatRun(int)">getFormatRun(int)</a></span> - Method in class org.apache.poi.hssf.record.common.<a href="./org/apache/poi/hssf/record/common/UnicodeString.html" title="class in org.apache.poi.hssf.record.common">UnicodeString</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/common/UnicodeString.html#getFormatRunCount()">getFormatRunCount()</a></span> - Method in class org.apache.poi.hssf.record.common.<a href="./org/apache/poi/hssf/record/common/UnicodeString.html" title="class in org.apache.poi.hssf.record.common">UnicodeString</a></dt>
@@ -27905,10 +28071,14 @@
 <dd>
 <div class="block">get whether the row has been formatted (even if its got all blank cells)</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getFormatting()">getFormatting()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/CFRuleBase.html#getFormattingBlockSize()">getFormattingBlockSize()</a></span> - Method in class org.apache.poi.hssf.record.<a href="./org/apache/poi/hssf/record/CFRuleBase.html" title="class in org.apache.poi.hssf.record">CFRuleBase</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/common/UnicodeString.ExtRst.html#getFormattingFontIndex()">getFormattingFontIndex()</a></span> - Method in class org.apache.poi.hssf.record.common.<a href="./org/apache/poi/hssf/record/common/UnicodeString.ExtRst.html" title="class in org.apache.poi.hssf.record.common">UnicodeString.ExtRst</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getFormattingIndex()">getFormattingIndex()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/common/UnicodeString.ExtRst.html#getFormattingOptions()">getFormattingOptions()</a></span> - Method in class org.apache.poi.hssf.record.common.<a href="./org/apache/poi/hssf/record/common/UnicodeString.ExtRst.html" title="class in org.apache.poi.hssf.record.common">UnicodeString.ExtRst</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormatting.html#getFormattingRanges()">getFormattingRanges()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormatting.html" title="class in org.apache.poi.hssf.usermodel">HSSFConditionalFormatting</a></dt>
@@ -27946,6 +28116,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html#getFormula1()">getFormula1()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html" title="class in org.apache.poi.hssf.usermodel">HSSFConditionalFormattingRule</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getFormula1()">getFormula1()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getFormula1()">getFormula1()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getFormula1()">getFormula1()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></dt>
 <dd>
 <div class="block">The formula used to evaluate the first operand for the conditional formatting rule.</div>
@@ -27966,6 +28140,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html#getFormula2()">getFormula2()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html" title="class in org.apache.poi.hssf.usermodel">HSSFConditionalFormattingRule</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getFormula2()">getFormula2()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getFormula2()">getFormula2()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getFormula2()">getFormula2()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></dt>
 <dd>
 <div class="block">The formula used to evaluate the second operand of the comparison when
@@ -31422,6 +31600,12 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/xdgf/usermodel/XDGFMasters.html#getMastersList()">getMastersList()</a></span> - Method in class org.apache.poi.xdgf.usermodel.<a href="./org/apache/poi/xdgf/usermodel/XDGFMasters.html" title="class in org.apache.poi.xdgf.usermodel">XDGFMasters</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getMatchingCells(org.apache.poi.ss.usermodel.Sheet,%20int,%20int)">getMatchingCells(Sheet, int, int)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>
+<div class="block">Conditional formatting rules can apply only to cells in the sheet to which they are attached.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getMatchingCells(org.apache.poi.ss.formula.EvaluationConditionalFormatRule)">getMatchingCells(EvaluationConditionalFormatRule)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/sl/draw/binding/CTPolarAdjustHandle.html#getMaxAng()">getMaxAng()</a></span> - Method in class org.apache.poi.sl.draw.binding.<a href="./org/apache/poi/sl/draw/binding/CTPolarAdjustHandle.html" title="class in org.apache.poi.sl.draw.binding">CTPolarAdjustHandle</a></dt>
 <dd>
 <div class="block">Gets the value of the maxAng property.</div>
@@ -33033,6 +33217,10 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/hwpf/model/io/HWPFOutputStream.html#getOffset()">getOffset()</a></span> - Method in class org.apache.poi.hwpf.model.io.<a href="./org/apache/poi/hwpf/model/io/HWPFOutputStream.html" title="class in org.apache.poi.hwpf.model.io">HWPFOutputStream</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getOffsetColumns()">getOffsetColumns()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getOffsetRows()">getOffsetRows()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/poifs/filesystem/DirectoryNode.html#getOFileSystem()">getOFileSystem()</a></span> - Method in class org.apache.poi.poifs.filesystem.<a href="./org/apache/poi/poifs/filesystem/DirectoryNode.html" title="class in org.apache.poi.poifs.filesystem">DirectoryNode</a></dt>
 <dd>
 <div class="block">If this is OPOIFS based, return the NPOIFSFileSystem
@@ -33096,6 +33284,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/DVConstraint.html#getOperator()">getOperator()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/DVConstraint.html" title="class in org.apache.poi.hssf.usermodel">DVConstraint</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getOperator()">getOperator()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getOperator()">getOperator()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/DataValidationConstraint.html#getOperator()">getOperator()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/DataValidationConstraint.html" title="interface in org.apache.poi.ss.usermodel">DataValidationConstraint</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#getOperator()">getOperator()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidationConstraint</a></dt>
@@ -34019,6 +34211,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hwmf/draw/HwmfDrawProperties.html#getPenWidth()">getPenWidth()</a></span> - Method in class org.apache.poi.hwmf.draw.<a href="./org/apache/poi/hwmf/draw/HwmfDrawProperties.html" title="class in org.apache.poi.hwmf.draw">HwmfDrawProperties</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html#getPercent()">getPercent()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel">ConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html#getPercent()">getPercent()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/DataBarFormatting.html#getPercentMax()">getPercentMax()</a></span> - Method in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/DataBarFormatting.html" title="class in org.apache.poi.hssf.record.cf">DataBarFormatting</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/DataBarFormatting.html#getPercentMin()">getPercentMin()</a></span> - Method in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/DataBarFormatting.html" title="class in org.apache.poi.hssf.record.cf">DataBarFormatting</a></dt>
@@ -34597,6 +34793,19 @@
 <dd>
 <div class="block">Gets the print setup object.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html#getPriority()">getPriority()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html" title="class in org.apache.poi.hssf.usermodel">HSSFConditionalFormattingRule</a></dt>
+<dd>
+<div class="block">we don't know priority for these, other than definition/model order, which appears to be what Excel uses.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getPriority()">getPriority()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getPriority()">getPriority()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></dt>
+<dd>
+<div class="block">HSSF just returns 0, XSSF uses the value stored in the model if present, 
+ otherwise uses 0.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getPriority()">getPriority()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionalFormattingRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hwpf/model/PieceDescriptor.html#getPrm()">getPrm()</a></span> - Method in class org.apache.poi.hwpf.model.<a href="./org/apache/poi/hwpf/model/PieceDescriptor.html" title="class in org.apache.poi.hwpf.model">PieceDescriptor</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hslf/model/OLEShape.html#getProgID()">getProgID()</a></span> - Method in class org.apache.poi.hslf.model.<a href="./org/apache/poi/hslf/model/OLEShape.html" title="class in org.apache.poi.hslf.model">OLEShape</a></dt>
@@ -34912,6 +35121,10 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingThreshold.html#getRangeType()">getRangeType()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingThreshold.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionalFormattingThreshold</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html#getRank()">getRank()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel">ConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html#getRank()">getRank()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hemf/record/AbstractHemfComment.html#getRawBytes()">getRawBytes()</a></span> - Method in class org.apache.poi.hemf.record.<a href="./org/apache/poi/hemf/record/AbstractHemfComment.html" title="class in org.apache.poi.hemf.record">AbstractHemfComment</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hwpf/model/TextPiece.html#getRawBytes()">getRawBytes()</a></span> - Method in class org.apache.poi.hwpf.model.<a href="./org/apache/poi/hwpf/model/TextPiece.html" title="class in org.apache.poi.hwpf.model">TextPiece</a></dt>
@@ -35741,6 +35954,8 @@
 <dd>
 <div class="block">The reference count of this blip.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getRef(org.apache.poi.ss.usermodel.Cell)">getRef(Cell)</a></span> - Static method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/OperationEvaluationContext.html#getRef3DEval(org.apache.poi.ss.formula.ptg.Ref3DPtg)">getRef3DEval(Ref3DPtg)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/OperationEvaluationContext.html" title="class in org.apache.poi.ss.formula">OperationEvaluationContext</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/OperationEvaluationContext.html#getRef3DEval(org.apache.poi.ss.formula.ptg.Ref3DPxg)">getRef3DEval(Ref3DPxg)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/OperationEvaluationContext.html" title="class in org.apache.poi.ss.formula">OperationEvaluationContext</a></dt>
@@ -35787,8 +36002,12 @@
 <dd>
 <div class="block">Gets the last stored region</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getRegion()">getRegion()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFDataValidation.html#getRegions()">getRegions()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFDataValidation.html" title="class in org.apache.poi.hssf.usermodel">HSSFDataValidation</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getRegions()">getRegions()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/DataValidation.html#getRegions()">getRegions()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel">DataValidation</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidation.html#getRegions()">getRegions()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidation.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidation</a></dt>
@@ -36873,10 +37092,18 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormatting.html#getRule(int)">getRule(int)</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormatting.html" title="class in org.apache.poi.hssf.usermodel">HSSFConditionalFormatting</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getRule()">getRule()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionalFormatting.html#getRule(int)">getRule(int)</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionalFormatting.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormatting</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormatting.html#getRule(int)">getRule(int)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormatting.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionalFormatting</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getRuleIndex()">getRuleIndex()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getRules(org.apache.poi.ss.usermodel.Sheet)">getRules(Sheet)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>
+<div class="block">lazy load by sheet since reading can be expensive</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xwpf/usermodel/PositionInParagraph.html#getRun()">getRun()</a></span> - Method in class org.apache.poi.xwpf.usermodel.<a href="./org/apache/poi/xwpf/usermodel/PositionInParagraph.html" title="class in org.apache.poi.xwpf.usermodel">PositionInParagraph</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xwpf/usermodel/XWPFParagraph.html#getRun(org.openxmlformats.schemas.wordprocessingml.x2006.main.CTR)">getRun(CTR)</a></span> - Method in class org.apache.poi.xwpf.usermodel.<a href="./org/apache/poi/xwpf/usermodel/XWPFParagraph.html" title="class in org.apache.poi.xwpf.usermodel">XWPFParagraph</a></dt>
@@ -37368,6 +37595,8 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationCell.html#getSheet()">getSheet()</a></span> - Method in interface org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationCell.html" title="interface in org.apache.poi.ss.formula">EvaluationCell</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getSheet()">getSheet()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationWorkbook.html#getSheet(int)">getSheet(int)</a></span> - Method in interface org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/Cell.html#getSheet()">getSheet()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></dt>
@@ -37498,6 +37727,8 @@
 <dd>
 <div class="block">Returns the index of the given sheet</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getSheetIndex()">getSheetIndex()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationWorkbook.html#getSheetIndex(org.apache.poi.ss.formula.EvaluationSheet)">getSheetIndex(EvaluationSheet)</a></span> - Method in interface org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex(String)</a></span> - Method in interface org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></dt>
@@ -38932,6 +39163,8 @@
 <dd>
 <div class="block">Returns the spreadsheet version (EXCLE97) of this workbook</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationWorkbook.html#getSpreadsheetVersion()">getSpreadsheetVersion()</a></span> - Method in interface org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/FormulaParsingWorkbook.html#getSpreadsheetVersion()">getSpreadsheetVersion()</a></span> - Method in interface org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/FormulaParsingWorkbook.html" title="interface in org.apache.poi.ss.formula">FormulaParsingWorkbook</a></dt>
 <dd>
 <div class="block">Returns an enum holding spreadhseet properties specific to an Excel version (
@@ -39051,6 +39284,10 @@
 <dd>
 <div class="block">gets the status bar text</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html#getStdDev()">getStdDev()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel">ConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html#getStdDev()">getStdDev()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionFilterData.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionFilterData</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hwpf/model/types/StdfBaseAbstractType.html#getSti()">getSti()</a></span> - Method in class org.apache.poi.hwpf.model.types.<a href="./org/apache/poi/hwpf/model/types/StdfBaseAbstractType.html" title="class in org.apache.poi.hwpf.model.types">StdfBaseAbstractType</a></dt>
 <dd>
 <div class="block">An unsigned integer that specifies the invariant style identifier for application-defined styles, or 0x0FFE for user-defined styles</div>
@@ -39063,6 +39300,16 @@
 <dd>
 <div class="block">style kind</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html#getStopIfTrue()">getStopIfTrue()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html" title="class in org.apache.poi.hssf.usermodel">HSSFConditionalFormattingRule</a></dt>
+<dd>
+<div class="block">Always true for HSSF files, per Microsoft Excel documentation</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getStopIfTrue()">getStopIfTrue()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></dt>
+<dd>
+<div class="block">Always true for HSSF rules, optional flag for XSSF rules.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getStopIfTrue()">getStopIfTrue()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionalFormattingRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/poifs/filesystem/DirectoryEntry.html#getStorageClsid()">getStorageClsid()</a></span> - Method in interface org.apache.poi.poifs.filesystem.<a href="./org/apache/poi/poifs/filesystem/DirectoryEntry.html" title="interface in org.apache.poi.poifs.filesystem">DirectoryEntry</a></dt>
 <dd>
 <div class="block">Gets the storage clsid of the directory entry</div>
@@ -39733,6 +39980,8 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/sl/usermodel/LineDecoration.html#getTailWidth()">getTailWidth()</a></span> - Method in interface org.apache.poi.sl.usermodel.<a href="./org/apache/poi/sl/usermodel/LineDecoration.html" title="interface in org.apache.poi.sl.usermodel">LineDecoration</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getTarget()">getTarget()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/charts/ManualLayout.html#getTarget()">getTarget()</a></span> - Method in interface org.apache.poi.ss.usermodel.charts.<a href="./org/apache/poi/ss/usermodel/charts/ManualLayout.html" title="interface in org.apache.poi.ss.usermodel.charts">ManualLayout</a></dt>
 <dd>
 <div class="block">Returns current layout target.</div>
@@ -40835,6 +41084,8 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/sl/usermodel/PictureData.html#getType()">getType()</a></span> - Method in interface org.apache.poi.sl.usermodel.<a href="./org/apache/poi/sl/usermodel/PictureData.html" title="interface in org.apache.poi.sl.usermodel">PictureData</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#getType()">getType()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/ptg/AttrPtg.html#getType()">getType()</a></span> - Method in class org.apache.poi.ss.formula.ptg.<a href="./org/apache/poi/ss/formula/ptg/AttrPtg.html" title="class in org.apache.poi.ss.formula.ptg">AttrPtg</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xdgf/usermodel/XDGFShape.html#getType()">getType()</a></span> - Method in class org.apache.poi.xdgf.usermodel.<a href="./org/apache/poi/xdgf/usermodel/XDGFShape.html" title="class in org.apache.poi.xdgf.usermodel">XDGFShape</a></dt>
@@ -41230,18 +41481,37 @@
 <dd>
 <div class="block">Gets the value of the val property.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html#getValidation()">getValidation()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.DataValidationContext.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator.DataValidationContext</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFDataValidation.html#getValidationConstraint()">getValidationConstraint()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFDataValidation.html" title="class in org.apache.poi.hssf.usermodel">HSSFDataValidation</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/DataValidation.html#getValidationConstraint()">getValidationConstraint()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel">DataValidation</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidation.html#getValidationConstraint()">getValidationConstraint()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidation.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidation</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#getValidationContextForCell(org.apache.poi.ss.util.CellReference)">getValidationContextForCell(CellReference)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#getValidationForCell(org.apache.poi.ss.util.CellReference)">getValidationForCell(CellReference)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>
+<div class="block">Finds and returns the <a href="./org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel"><code>DataValidation</code></a> for the cell, if there is
+ one.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/DVConstraint.html#getValidationType()">getValidationType()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/DVConstraint.html" title="class in org.apache.poi.hssf.usermodel">DVConstraint</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/DataValidationConstraint.html#getValidationType()">getValidationType()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/DataValidationConstraint.html" title="interface in org.apache.poi.ss.usermodel">DataValidationConstraint</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#getValidationType()">getValidationType()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidationConstraint</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#getValidationValuesForCell(org.apache.poi.ss.util.CellReference)">getValidationValuesForCell(CellReference)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>
+<div class="block">If <a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#getValidationForCell(org.apache.poi.ss.util.CellReference)"><code>DataValidationEvaluator.getValidationForCell(CellReference)</code></a> returns an instance, and the
+ <a href="./org/apache/poi/ss/usermodel/DataValidationConstraint.ValidationType.html" title="class in org.apache.poi.ss.usermodel"><code>DataValidationConstraint.ValidationType</code></a> is <a href="./org/apache/poi/ss/usermodel/DataValidationConstraint.ValidationType.html#LIST"><code>DataValidationConstraint.ValidationType.LIST</code></a>, return the valid
+ values, whether they are from a static list or cell range.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#getValidationValuesForConstraint(org.apache.poi.ss.formula.DataValidationEvaluator.DataValidationContext)">getValidationValuesForConstraint(DataValidationEvaluator.DataValidationContext)</a></span> - Static method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>
+<div class="block">static so enums can reference it without creating a whole instance</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/PrintSetupRecord.html#getValidSettings()">getValidSettings()</a></span> - Method in class org.apache.poi.hssf.record.<a href="./org/apache/poi/hssf/record/PrintSetupRecord.html" title="class in org.apache.poi.hssf.record">PrintSetupRecord</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFPrintSetup.html#getValidSettings()">getValidSettings()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFPrintSetup.html" title="class in org.apache.poi.hssf.usermodel">HSSFPrintSetup</a></dt>
@@ -41352,6 +41622,8 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html#getValue(int,%20int,%20int)">getValue(int, int, int)</a></span> - Method in class org.apache.poi.ss.formula.eval.<a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html" title="class in org.apache.poi.ss.formula.eval">AreaEvalBase</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html#getValue()">getValue()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.ValueAndFormat</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/functions/Countif.ErrorMatcher.html#getValue()">getValue()</a></span> - Method in class org.apache.poi.ss.formula.functions.<a href="./org/apache/poi/ss/formula/functions/Countif.ErrorMatcher.html" title="class in org.apache.poi.ss.formula.functions">Countif.ErrorMatcher</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/ptg/BoolPtg.html#getValue()">getValue()</a></span> - Method in class org.apache.poi.ss.formula.ptg.<a href="./org/apache/poi/ss/formula/ptg/BoolPtg.html" title="class in org.apache.poi.ss.formula.ptg">BoolPtg</a></dt>
@@ -42067,6 +42339,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/CollaboratingWorkbooksEnvironment.html#getWorkbookEvaluator(java.lang.String)">getWorkbookEvaluator(String)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/CollaboratingWorkbooksEnvironment.html" title="class in org.apache.poi.ss.formula">CollaboratingWorkbooksEnvironment</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#getWorkbookEvaluator()">getWorkbookEvaluator()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#getWorkbookEvaluator()">getWorkbookEvaluator()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html#getWorkbookName()">getWorkbookName()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getWorkbookType()">getWorkbookType()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a></dt>
@@ -43236,6 +43512,10 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/format/CellNumberStringMod.html#hashCode()">hashCode()</a></span> - Method in class org.apache.poi.ss.format.<a href="./org/apache/poi/ss/format/CellNumberStringMod.html" title="class in org.apache.poi.ss.format">CellNumberStringMod</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html#hashCode()">hashCode()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a></dt>
+<dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html#hashCode()">hashCode()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.ValueAndFormat</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ExcelStyleDateFormatter.html#hashCode()">hashCode()</a></span> - Method in class org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ExcelStyleDateFormatter.html" title="class in org.apache.poi.ss.usermodel">ExcelStyleDateFormatter</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/util/CellAddress.html#hashCode()">hashCode()</a></span> - Method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a></dt>
@@ -46701,6 +46981,8 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/functions/IfFunc.html#IfFunc()">IfFunc()</a></span> - Constructor for class org.apache.poi.ss.formula.functions.<a href="./org/apache/poi/ss/formula/functions/IfFunc.html" title="class in org.apache.poi.ss.formula.functions">IfFunc</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.OperatorEnum.html#IGNORED">IGNORED</a></span> - Static variable in enum org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.OperatorEnum.html" title="enum in org.apache.poi.ss.formula">DataValidationEvaluator.OperatorEnum</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/DataValidationConstraint.OperatorType.html#IGNORED">IGNORED</a></span> - Static variable in class org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/DataValidationConstraint.OperatorType.html" title="class in org.apache.poi.ss.usermodel">DataValidationConstraint.OperatorType</a></dt>
 <dd>
 <div class="block">default value to supply when the operator type is not used</div>
@@ -50213,6 +50495,16 @@
 <div class="block">Determines if the given coordinates lie within the bounds 
  of this range.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(org.apache.poi.ss.util.CellReference)">isInRange(CellReference)</a></span> - Method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></dt>
+<dd>
+<div class="block">Determines if the given <a href="./org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util"><code>CellReference</code></a> lies within the bounds 
+ of this range.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(org.apache.poi.ss.usermodel.Cell)">isInRange(Cell)</a></span> - Method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></dt>
+<dd>
+<div class="block">Determines if the given <a href="./org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel"><code>Cell</code></a> lies within the bounds 
+ of this range.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#isInsertColumnsLocked()">isInsertColumnsLocked()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#isInsertHyperlinksLocked()">isInsertHyperlinksLocked()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
@@ -50420,6 +50712,8 @@
 <div class="block"><i>POI 3.16 - will be removed, not used in POI itself</i></div>
 </div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html#isNumber()">isNumber()</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.ValueAndFormat.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.ValueAndFormat</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/formula/functions/LogicalFunction.html#ISNUMBER">ISNUMBER</a></span> - Static variable in class org.apache.poi.ss.formula.functions.<a href="./org/apache/poi/ss/formula/functions/LogicalFunction.html" title="class in org.apache.poi.ss.formula.functions">LogicalFunction</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/charts/ChartDataSource.html#isNumeric()">isNumeric()</a></span> - Method in interface org.apache.poi.ss.usermodel.charts.<a href="./org/apache/poi/ss/usermodel/charts/ChartDataSource.html" title="interface in org.apache.poi.ss.usermodel.charts">ChartDataSource</a></dt>
@@ -51406,6 +51700,10 @@
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/poifs/crypt/dsig/SignatureConfig.html#isTspOldProtocol()">isTspOldProtocol()</a></span> - Method in class org.apache.poi.poifs.crypt.dsig.<a href="./org/apache/poi/poifs/crypt/dsig/SignatureConfig.html" title="class in org.apache.poi.poifs.crypt.dsig">SignatureConfig</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#isType(org.apache.poi.ss.usermodel.Cell,%20org.apache.poi.ss.usermodel.CellType)">isType(Cell, CellType)</a></span> - Static method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>
+<div class="block">Note that this assumes the cell cached value is up to date and in sync with data edits</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/LabelRecord.html#isUnCompressedUnicode()">isUnCompressedUnicode()</a></span> - Method in class org.apache.poi.hssf.record.<a href="./org/apache/poi/hssf/record/LabelRecord.html" title="class in org.apache.poi.hssf.record">LabelRecord</a></dt>
 <dd>
 <div class="block">is this uncompressed unicode (16bit)?  Or just 8-bit compressed?</div>
@@ -51486,6 +51784,23 @@
 <dd>
 <div class="block">Whether date windowing is based on 1/2/1904 or 1/1/1900.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.OperatorEnum.html#isValid(java.lang.Double,%20java.lang.Double,%20java.lang.Double)">isValid(Double, Double, Double)</a></span> - Method in enum org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.OperatorEnum.html" title="enum in org.apache.poi.ss.formula">DataValidationEvaluator.OperatorEnum</a></dt>
+<dd>
+<div class="block">Evaluates comparison using operator instance rules</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.ValidationEnum.html#isValid(org.apache.poi.ss.usermodel.Cell,%20org.apache.poi.ss.formula.DataValidationEvaluator.DataValidationContext)">isValid(Cell, DataValidationEvaluator.DataValidationContext)</a></span> - Static method in enum org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.ValidationEnum.html" title="enum in org.apache.poi.ss.formula">DataValidationEvaluator.ValidationEnum</a></dt>
+<dd>
+<div class="block">Validates against the type defined in context, as an index of the enum values array.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.OperatorEnum.html#isValid(C,%20C,%20C)">isValid(C, C, C)</a></span> - Method in enum org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/EvaluationConditionalFormatRule.OperatorEnum.html" title="enum in org.apache.poi.ss.formula">EvaluationConditionalFormatRule.OperatorEnum</a></dt>
+<dd>
+<div class="block">Evaluates comparison using operator instance rules</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#isValidCell(org.apache.poi.ss.util.CellReference)">isValidCell(CellReference)</a></span> - Method in class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></dt>
+<dd>
+<div class="block">Use the validation returned by <a href="./org/apache/poi/ss/formula/DataValidationEvaluator.html#getValidationForCell(org.apache.poi.ss.util.CellReference)"><code>DataValidationEvaluator.getValidationForCell(CellReference)</code></a> if you
+ want the error display details.</div>
+</dd>

[... 114 lines stripped ...]


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message