Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html Mon Jul 24 09:18:21 2017 @@ -100,12 +100,12 @@ <br> <pre>public class <span class="strong">ConditionalFormattingEvaluator</span> extends java.lang.Object</pre> -<div class="block">Evaluates Conditional Formatting constraints.<p/> +<div class="block">Evaluates Conditional Formatting constraints.<p> For performance reasons, this class keeps a cache of all previously evaluated rules and cells. Be sure to call <a href="../../../../../org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#clearAllCachedFormats()"><code>clearAllCachedFormats()</code></a> if any conditional formats are modified, added, or deleted, and <a href="../../../../../org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html#clearAllCachedValues()"><code>clearAllCachedValues()</code></a> whenever cell values change. - <p/></div> + <p></div> </li> </ul> </div> @@ -273,7 +273,7 @@ extends java.lang.Object</pre> <pre>public void clearAllCachedValues()</pre> <div class="block">Call this whenever cell values change in the workbook, so condional formats are re-evaluated for all cells. - <p/> + <p> TODO: eventually this should work like <code>EvaluationCache.notifyUpdateCell(int, int, EvaluationCell)</code> and only clear values that need recalculation based on the formula dependency tree.</div> </li> @@ -300,10 +300,10 @@ extends java.lang.Object</pre> <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. This is a property currently not exposed from <code>CTCfRule</code> in <code>XSSFConditionalFormattingRule</code>. - <p/> + <p> Most cells will have zero or one applied rule, but it is possible to define multiple rules that apply at the same time to the same cell, thus the List result. - <p/> + <p> Note that to properly apply conditional rules, care must be taken to offset the base formula by the relative position of the current cell, or the wrong value is checked. This is handled by <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)"><code>WorkbookEvaluator.evaluate(String, CellReference, CellRangeAddressBase)</code></a>.</div> @@ -323,10 +323,10 @@ extends java.lang.Object</pre> <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. This is a property currently not exposed from <code>CTCfRule</code> in <code>XSSFConditionalFormattingRule</code>. - <p/> + <p> Most cells will have zero or one applied rule, but it is possible to define multiple rules that apply at the same time to the same cell, thus the List result. - <p/> + <p> Note that to properly apply conditional rules, care must be taken to offset the base formula by the relative position of the current cell, or the wrong value is checked. This is handled by <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)"><code>WorkbookEvaluator.evaluate(String, CellReference, CellRangeAddressBase)</code></a>.</div> @@ -378,9 +378,9 @@ extends java.lang.Object</pre> int ruleIndex)</pre> <div class="block">Conditional formatting rules can apply only to cells in the sheet to which they are attached. The POI data model does not have a back-reference to the owning sheet, so it must be passed in separately. - <p/> + <p> We could overload this with convenience methods taking a sheet name and sheet index as well. - <p/></div> + <p></div> <dl><dt><span class="strong">Parameters:</span></dt><dd><code>sheet</code> - containing the rule</dd><dd><code>conditionalFormattingIndex</code> - of the <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormatting.html" title="interface in org.apache.poi.ss.usermodel"><code>ConditionalFormatting</code></a> instance in the sheet's array</dd><dd><code>ruleIndex</code> - of the <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel"><code>ConditionalFormattingRule</code></a> instance within the <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormatting.html" title="interface in org.apache.poi.ss.usermodel"><code>ConditionalFormatting</code></a></dd> <dt><span class="strong">Returns:</span></dt><dd>unmodifiable List of all cells in the rule's region matching the rule's condition</dd></dl> </li>
Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/DataValidationEvaluator.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/DataValidationEvaluator.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/DataValidationEvaluator.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/DataValidationEvaluator.html Mon Jul 24 09:18:21 2017 @@ -100,12 +100,12 @@ <br> <pre>public class <span class="strong">DataValidationEvaluator</span> extends java.lang.Object</pre> -<div class="block">Evaluates Data Validation constraints.<p/> +<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. Be sure to call <a href="../../../../../org/apache/poi/ss/formula/DataValidationEvaluator.html#clearAllCachedValues()"><code>clearAllCachedValues()</code></a> if any workbook validation definitions are added, modified, or deleted. - <p/> + <p> Changing cell values should be fine, as long as the corresponding <a href="../../../../../org/apache/poi/ss/formula/WorkbookEvaluator.html#clearAllCachedResultValues()"><code>WorkbookEvaluator.clearAllCachedResultValues()</code></a> is called as well.</div> </li> @@ -342,10 +342,10 @@ extends java.lang.Object</pre> <div class="block">If <a href="../../../../../org/apache/poi/ss/formula/DataValidationEvaluator.html#getValidationForCell(org.apache.poi.ss.util.CellReference)"><code>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. - <p/> + <p> For all other validation types, or no validation at all, this method returns null. - <p/> + <p> This method could throw an exception if the validation type is not LIST, but since this method is mostly useful in UI contexts, null seems the easier path.</div> @@ -375,7 +375,7 @@ extends java.lang.Object</pre> <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>getValidationForCell(CellReference)</code></a> if you want the error display details. This is the validation checked by this method, which attempts to replicate Excel's data validation rules. - <p/> + <p> Note that to properly apply some validations, care must be taken to offset the base validation formula by the relative position of the current cell, or the wrong value is checked.</div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationCell.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationCell.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationCell.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationCell.html Mon Jul 24 09:18:21 2017 @@ -92,7 +92,7 @@ <br> <pre>public interface <span class="strong">EvaluationCell</span></pre> <div class="block">Abstracts a cell for the purpose of formula evaluation. This interface represents both formula - and non-formula cells.<br/> + and non-formula cells.<br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html Mon Jul 24 09:18:21 2017 @@ -433,7 +433,7 @@ implements java.lang.Comparable<<a hr <pre>public int compareTo(<a href="../../../../../org/apache/poi/ss/formula/EvaluationConditionalFormatRule.html" title="class in org.apache.poi.ss.formula">EvaluationConditionalFormatRule</a> o)</pre> <div class="block">Per Excel Help, XSSF rule priority is sheet-wide, not just within the owning ConditionalFormatting object. This can be seen by creating 4 rules applying to two different ranges and examining the XML. - <p/> + <p> HSSF priority is based on definition/persistence order.</div> <dl> <dt><strong>Specified by:</strong></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationName.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationName.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationName.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationName.html Mon Jul 24 09:18:21 2017 @@ -91,7 +91,7 @@ <hr> <br> <pre>public interface <span class="strong">EvaluationName</span></pre> -<div class="block">Abstracts a name record for formula evaluation.<br/> +<div class="block">Abstracts a name record for formula evaluation.<br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationSheet.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationSheet.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationSheet.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationSheet.html Mon Jul 24 09:18:21 2017 @@ -92,7 +92,7 @@ <br> <pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a> public interface <span class="strong">EvaluationSheet</span></pre> -<div class="block">Abstracts a sheet for the purpose of formula evaluation.<br/> +<div class="block">Abstracts a sheet for the purpose of formula evaluation.<br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.html Mon Jul 24 09:18:21 2017 @@ -96,7 +96,7 @@ <br> <pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a> public interface <span class="strong">EvaluationWorkbook</span></pre> -<div class="block">Abstracts a workbook for the purpose of formula evaluation.<br/> +<div class="block">Abstracts a workbook for the purpose of formula evaluation.<br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/ExternSheetReferenceToken.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/ExternSheetReferenceToken.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/ExternSheetReferenceToken.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/ExternSheetReferenceToken.html Mon Jul 24 09:18:21 2017 @@ -95,7 +95,7 @@ <hr> <br> <pre>public interface <span class="strong">ExternSheetReferenceToken</span></pre> -<div class="block">Should be implemented by any <a href="../../../../../org/apache/poi/ss/formula/ptg/Ptg.html" title="class in org.apache.poi.ss.formula.ptg"><code>Ptg</code></a> subclass that needs has an extern sheet index <br/> +<div class="block">Should be implemented by any <a href="../../../../../org/apache/poi/ss/formula/ptg/Ptg.html" title="class in org.apache.poi.ss.formula.ptg"><code>Ptg</code></a> subclass that needs has an extern sheet index <br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaParser.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaParser.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaParser.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaParser.html Mon Jul 24 09:18:21 2017 @@ -109,9 +109,9 @@ extends java.lang.Object</pre> <term> ::= <factor> [ <mulop> <factor> ]* <factor> ::= <number> | (<expression>) | <cellRef> | <function> <function> ::= <functionName> ([expression [, expression]*]) - <p/> + <p> For POI internal use only - <p/></div> + <p></div> </li> </ul> </div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaParsingWorkbook.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaParsingWorkbook.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaParsingWorkbook.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaParsingWorkbook.html Mon Jul 24 09:18:21 2017 @@ -95,7 +95,7 @@ <hr> <br> <pre>public interface <span class="strong">FormulaParsingWorkbook</span></pre> -<div class="block">Abstracts a workbook for the purpose of formula parsing.<br/> +<div class="block">Abstracts a workbook for the purpose of formula parsing.<br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderer.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderer.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderer.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderer.html Mon Jul 24 09:18:21 2017 @@ -100,7 +100,7 @@ <br> <pre>public class <span class="strong">FormulaRenderer</span> extends java.lang.Object</pre> -<div class="block">Common logic for rendering formulas.<br/> +<div class="block">Common logic for rendering formulas.<br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderingWorkbook.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderingWorkbook.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderingWorkbook.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderingWorkbook.html Mon Jul 24 09:18:21 2017 @@ -95,7 +95,7 @@ <hr> <br> <pre>public interface <span class="strong">FormulaRenderingWorkbook</span></pre> -<div class="block">Abstracts a workbook for the purpose of converting formula to text.<br/> +<div class="block">Abstracts a workbook for the purpose of converting formula to text.<br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/IStabilityClassifier.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/IStabilityClassifier.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/IStabilityClassifier.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/IStabilityClassifier.html Mon Jul 24 09:18:21 2017 @@ -92,11 +92,11 @@ <br> <pre>public interface <span class="strong">IStabilityClassifier</span></pre> <div class="block">Used to help optimise cell evaluation result caching by allowing applications to specify which - parts of a workbook are <em>final</em>.<br/> + parts of a workbook are <em>final</em>.<br> The term <b>final</b> is introduced here to denote immutability or 'having constant definition'. This classification refers to potential actions (on the evaluated workbook) by the evaluating - application. It does not refer to operations performed by the evaluator (<a href="../../../../../org/apache/poi/ss/formula/WorkbookEvaluator.html" title="class in org.apache.poi.ss.formula"><code>WorkbookEvaluator</code></a>).<br/> - <br/> + application. It does not refer to operations performed by the evaluator (<a href="../../../../../org/apache/poi/ss/formula/WorkbookEvaluator.html" title="class in org.apache.poi.ss.formula"><code>WorkbookEvaluator</code></a>).<br> + <br> <b>General guidelines</b>: <ul> <li>a plain value cell can be marked as 'final' if it will not be changed after the first call Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/WorkbookDependentFormula.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/WorkbookDependentFormula.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/WorkbookDependentFormula.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/WorkbookDependentFormula.html Mon Jul 24 09:18:21 2017 @@ -96,7 +96,7 @@ <br> <pre>public interface <span class="strong">WorkbookDependentFormula</span></pre> <div class="block">Should be implemented by any <a href="../../../../../org/apache/poi/ss/formula/ptg/Ptg.html" title="class in org.apache.poi.ss.formula.ptg"><code>Ptg</code></a> subclass that needs a workbook to render its formula. - <br/> + <br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/WorkbookEvaluator.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/WorkbookEvaluator.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/WorkbookEvaluator.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/WorkbookEvaluator.html Mon Jul 24 09:18:21 2017 @@ -101,11 +101,11 @@ <pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a> public final class <span class="strong">WorkbookEvaluator</span> extends java.lang.Object</pre> -<div class="block">Evaluates formula cells.<p/> +<div class="block">Evaluates formula cells.<p> For performance reasons, this class keeps a cache of all previously calculated intermediate cell values. Be sure to call <a href="../../../../../org/apache/poi/ss/formula/WorkbookEvaluator.html#clearAllCachedResultValues()"><code>clearAllCachedResultValues()</code></a> if any workbook cells are changed between - calls to evaluate~ methods on this class.<br/> + calls to evaluate~ methods on this class.<br> For POI internal use only</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/BaseFormulaEvaluator.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/BaseFormulaEvaluator.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/BaseFormulaEvaluator.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/BaseFormulaEvaluator.html Mon Jul 24 09:18:21 2017 @@ -116,10 +116,7 @@ <tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFFormulaEvaluator.html" title="class in org.apache.poi.hssf.usermodel">HSSFFormulaEvaluator</a></strong></code> -<div class="block">Evaluates formula cells.<p/> - - For performance reasons, this class keeps a cache of all previously calculated intermediate - cell values.</div> +<div class="block">Evaluates formula cells.</div> </td> </tr> </tbody> @@ -188,10 +185,7 @@ <tr class="rowColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFFormulaEvaluator.html" title="class in org.apache.poi.xssf.usermodel">XSSFFormulaEvaluator</a></strong></code> -<div class="block">Evaluates formula cells.<p/> - - For performance reasons, this class keeps a cache of all previously calculated intermediate - cell values.</div> +<div class="block">Evaluates formula cells.</div> </td> </tr> </tbody> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/WorkbookEvaluatorProvider.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/WorkbookEvaluatorProvider.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/WorkbookEvaluatorProvider.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/WorkbookEvaluatorProvider.html Mon Jul 24 09:18:21 2017 @@ -116,10 +116,7 @@ <tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFFormulaEvaluator.html" title="class in org.apache.poi.hssf.usermodel">HSSFFormulaEvaluator</a></strong></code> -<div class="block">Evaluates formula cells.<p/> - - For performance reasons, this class keeps a cache of all previously calculated intermediate - cell values.</div> +<div class="block">Evaluates formula cells.</div> </td> </tr> </tbody> @@ -139,7 +136,7 @@ <tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/BaseFormulaEvaluator.html" title="class in org.apache.poi.ss.formula">BaseFormulaEvaluator</a></strong></code> -<div class="block">Common functionality across file formats for evaluating formula cells.<p/></div> +<div class="block">Common functionality across file formats for evaluating formula cells.</div> </td> </tr> </tbody> @@ -205,10 +202,7 @@ <tr class="rowColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFFormulaEvaluator.html" title="class in org.apache.poi.xssf.usermodel">XSSFFormulaEvaluator</a></strong></code> -<div class="block">Evaluates formula cells.<p/> - - For performance reasons, this class keeps a cache of all previously calculated intermediate - cell values.</div> +<div class="block">Evaluates formula cells.</div> </td> </tr> </tbody> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/constant/ConstantValueParser.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/constant/ConstantValueParser.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/constant/ConstantValueParser.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/constant/ConstantValueParser.html Mon Jul 24 09:18:21 2017 @@ -102,7 +102,7 @@ extends java.lang.Object</pre> <div class="block">To support Constant Values (2.5.7) as required by the CRN record. This class is also used for two dimensional arrays which are encoded by - EXTERNALNAME (5.39) records and Array tokens.<p/></div> + EXTERNALNAME (5.39) records and Array tokens.<p></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Josh Micich</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/constant/ErrorConstant.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/constant/ErrorConstant.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/constant/ErrorConstant.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/constant/ErrorConstant.html Mon Jul 24 09:18:21 2017 @@ -100,7 +100,7 @@ <br> <pre>public class <span class="strong">ErrorConstant</span> extends java.lang.Object</pre> -<div class="block">Represents a constant error code value as encoded in a constant values array. <p/> +<div class="block">Represents a constant error code value as encoded in a constant values array. <p> This class is a type-safe wrapper for a 16-bit int value performing a similar job to <tt>ErrorEval</tt>.</div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/BoolEval.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/BoolEval.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/BoolEval.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/BoolEval.html Mon Jul 24 09:18:21 2017 @@ -167,7 +167,7 @@ implements <a href="../../../../../../or <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/eval/BoolEval.html" title="class in org.apache.poi.ss.formula.eval">BoolEval</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/eval/BoolEval.html#valueOf(boolean)">valueOf</a></strong>(boolean b)</code> -<div class="block">Convenience method for the following:<br/> +<div class="block">Convenience method for the following:<br> <code>(b ? BoolEval.TRUE : BoolEval.FALSE)</code></div> </td> </tr> @@ -226,7 +226,7 @@ implements <a href="../../../../../../or <li class="blockList"> <h4>valueOf</h4> <pre>public static <a href="../../../../../../org/apache/poi/ss/formula/eval/BoolEval.html" title="class in org.apache.poi.ss.formula.eval">BoolEval</a> valueOf(boolean b)</pre> -<div class="block">Convenience method for the following:<br/> +<div class="block">Convenience method for the following:<br> <code>(b ? BoolEval.TRUE : BoolEval.FALSE)</code></div> <dl><dt><span class="strong">Returns:</span></dt><dd>the <tt>BoolEval</tt> instance representing <tt>b</tt>.</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/EvaluationException.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/EvaluationException.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/EvaluationException.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/EvaluationException.html Mon Jul 24 09:18:21 2017 @@ -116,7 +116,7 @@ extends java.lang.Exception</pre> <div class="block">This class is used to simplify error handling logic <i>within</i> operator and function implementations. Note - <tt>OperationEval.evaluate()</tt> and <tt>Function.evaluate()</tt> - method signatures do not throw this exception so it cannot propagate outside.<p/> + method signatures do not throw this exception so it cannot propagate outside.<p> Here is an example coded without <tt>EvaluationException</tt>, to show how it can help: <pre> @@ -147,9 +147,9 @@ extends java.lang.Exception</pre> </pre> In this example, if any error is encountered while processing the arguments, an error is returned immediately. This code is difficult to refactor due to all the points where errors - are returned.<br/> + are returned.<br> Using <tt>EvaluationException</tt> allows the error returning code to be consolidated to one - place.<p/> + place.<p> <pre> public Eval evaluate(Eval[] args, int srcRow, short srcCol) { try { @@ -187,14 +187,14 @@ private double sumValues(ValueEval[] val return temp; } </pre> - It is not mandatory to use EvaluationException, doing so might give the following advantages:<br/> - - Methods can more easily be extracted, allowing for re-use.<br/> + It is not mandatory to use EvaluationException, doing so might give the following advantages:<br> + - Methods can more easily be extracted, allowing for re-use.<br> - Type management (typecasting etc) is simpler because error conditions have been separated from - intermediate calculation values.<br/> - - Fewer local variables are required. Local variables can have stronger types.<br/> + intermediate calculation values.<br> + - Fewer local variables are required. Local variables can have stronger types.<br> - It is easier to mimic common Excel error handling behaviour (exit upon encountering first error), because exceptions conveniently propagate up the call stack regardless of execution - points or the number of levels of nested calls.<p/> + points or the number of levels of nested calls.<p> <b>Note</b> - Only standard evaluation errors are represented by <tt>EvaluationException</tt> ( i.e. conditions expected to be encountered when evaluating arbitrary Excel formulas). Conditions Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/OperandResolver.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/OperandResolver.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/OperandResolver.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/OperandResolver.html Mon Jul 24 09:18:21 2017 @@ -144,7 +144,7 @@ extends java.lang.Object</pre> <tr class="rowColor"> <td class="colFirst"><code>static int</code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/eval/OperandResolver.html#coerceValueToInt(org.apache.poi.ss.formula.eval.ValueEval)">coerceValueToInt</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/eval/ValueEval.html" title="interface in org.apache.poi.ss.formula.eval">ValueEval</a> ev)</code> -<div class="block">Applies some conversion rules if the supplied value is not already an integer.<br/> +<div class="block">Applies some conversion rules if the supplied value is not already an integer.<br> Value is first coerced to a <tt>double</tt> ( See <tt>coerceValueToDouble()</tt> ).</div> </td> </tr> @@ -164,10 +164,8 @@ extends java.lang.Object</pre> <tr class="altColor"> <td class="colFirst"><code>static java.lang.Double</code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/eval/OperandResolver.html#parseDouble(java.lang.String)">parseDouble</a></strong>(java.lang.String pText)</code> -<div class="block">Converts a string to a double using standard rules that Excel would use.<br/> - Tolerates leading and trailing spaces, <p/> - - Doesn't support currency prefixes, commas, percentage signs or arithmetic operations strings.</div> +<div class="block">Converts a string to a double using standard rules that Excel would use.<br> + Tolerates leading and trailing spaces,</div> </td> </tr> </table> @@ -249,10 +247,10 @@ extends java.lang.Object</pre> Note that the row area (A1:B1) does not include column C and the column area (D2:D3) does not include row 4, so the values in C1(=25) and D4(=400) are not accessible to the formula - as written, but in the 4 cells A2:B3, the row and column selection works ok.<p/> + as written, but in the 4 cells A2:B3, the row and column selection works ok.<p> The same concept is extended to references across sheets, such that even multi-row, - multi-column areas can be useful.<p/> + multi-column areas can be useful.<p> Of course with carefully (or carelessly) chosen parameters, cyclic references can occur and hence this method <b>can</b> throw a 'circular reference' EvaluationException. Note that @@ -276,14 +274,14 @@ extends java.lang.Object</pre> <h4>coerceValueToInt</h4> <pre>public static int coerceValueToInt(<a href="../../../../../../org/apache/poi/ss/formula/eval/ValueEval.html" title="interface in org.apache.poi.ss.formula.eval">ValueEval</a> ev) throws <a href="../../../../../../org/apache/poi/ss/formula/eval/EvaluationException.html" title="class in org.apache.poi.ss.formula.eval">EvaluationException</a></pre> -<div class="block">Applies some conversion rules if the supplied value is not already an integer.<br/> +<div class="block">Applies some conversion rules if the supplied value is not already an integer.<br> Value is first coerced to a <tt>double</tt> ( See <tt>coerceValueToDouble()</tt> ). - Note - <tt>BlankEval</tt> is converted to <code>0</code>.<p/> + Note - <tt>BlankEval</tt> is converted to <code>0</code>.<p> - Excel typically converts doubles to integers by truncating toward negative infinity.<br/> - The equivalent java code is:<br/> - <code>return (int)Math.floor(d);</code><br/> - <b>not</b>:<br/> + Excel typically converts doubles to integers by truncating toward negative infinity.<br> + The equivalent java code is:<br> + <code>return (int)Math.floor(d);</code><br> + <b>not</b>:<br> <code>return (int)d; // wrong - rounds toward zero</code></div> <dl><dt><span class="strong">Throws:</span></dt> <dd><code><a href="../../../../../../org/apache/poi/ss/formula/eval/EvaluationException.html" title="class in org.apache.poi.ss.formula.eval">EvaluationException</a></code></dd></dl> @@ -317,21 +315,21 @@ extends java.lang.Object</pre> <li class="blockList"> <h4>parseDouble</h4> <pre>public static java.lang.Double parseDouble(java.lang.String pText)</pre> -<div class="block">Converts a string to a double using standard rules that Excel would use.<br/> - Tolerates leading and trailing spaces, <p/> +<div class="block">Converts a string to a double using standard rules that Excel would use.<br> + Tolerates leading and trailing spaces, <p> Doesn't support currency prefixes, commas, percentage signs or arithmetic operations strings. - Some examples:<br/> - " 123 " -> 123.0<br/> - ".123" -> 0.123<br/> - "1E4" -> 1000<br/> - "-123" -> -123.0<br/> - These not supported yet:<br/> - " $ 1,000.00 " -> 1000.0<br/> - "$1.25E4" -> 12500.0<br/> - "5**2" -> 500<br/> - "250%" -> 2.5<br/></div> + Some examples:<br> + " 123 " -> 123.0<br> + ".123" -> 0.123<br> + "1E4" -> 1000<br> + "-123" -> -123.0<br> + These not supported yet:<br> + " $ 1,000.00 " -> 1000.0<br> + "$1.25E4" -> 12500.0<br> + "5**2" -> 500<br> + "250%" -> 2.5<br></div> <dl><dt><span class="strong">Returns:</span></dt><dd><code>null</code> if the specified text cannot be parsed as a number</dd></dl> </li> </ul> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/PercentEval.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/PercentEval.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/PercentEval.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/PercentEval.html Mon Jul 24 09:18:21 2017 @@ -109,7 +109,7 @@ <br> <pre>public final class <span class="strong">PercentEval</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a></pre> -<div class="block">Implementation of Excel formula token '%'. <p/></div> +<div class="block">Implementation of Excel formula token '%'. <p></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Josh Micich</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/BoolEval.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/BoolEval.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/BoolEval.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/BoolEval.html Mon Jul 24 09:18:21 2017 @@ -117,7 +117,7 @@ <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/eval/BoolEval.html" title="class in org.apache.poi.ss.formula.eval">BoolEval</a></code></td> <td class="colLast"><span class="strong">BoolEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/BoolEval.html#valueOf(boolean)">valueOf</a></strong>(boolean b)</code> -<div class="block">Convenience method for the following:<br/> +<div class="block">Convenience method for the following:<br> <code>(b ? BoolEval.TRUE : BoolEval.FALSE)</code></div> </td> </tr> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/EvaluationException.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/EvaluationException.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/EvaluationException.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/EvaluationException.html Mon Jul 24 09:18:21 2017 @@ -175,7 +175,7 @@ <tr class="rowColor"> <td class="colFirst"><code>static int</code></td> <td class="colLast"><span class="strong">OperandResolver.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/OperandResolver.html#coerceValueToInt(org.apache.poi.ss.formula.eval.ValueEval)">coerceValueToInt</a></strong>(<a href="../../../../../../../org/apache/poi/ss/formula/eval/ValueEval.html" title="interface in org.apache.poi.ss.formula.eval">ValueEval</a> ev)</code> -<div class="block">Applies some conversion rules if the supplied value is not already an integer.<br/> +<div class="block">Applies some conversion rules if the supplied value is not already an integer.<br> Value is first coerced to a <tt>double</tt> ( See <tt>coerceValueToDouble()</tt> ).</div> </td> </tr> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/ValueEval.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/ValueEval.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/ValueEval.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/class-use/ValueEval.html Mon Jul 24 09:18:21 2017 @@ -538,7 +538,7 @@ <tr class="altColor"> <td class="colFirst"><code>static int</code></td> <td class="colLast"><span class="strong">OperandResolver.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/OperandResolver.html#coerceValueToInt(org.apache.poi.ss.formula.eval.ValueEval)">coerceValueToInt</a></strong>(<a href="../../../../../../../org/apache/poi/ss/formula/eval/ValueEval.html" title="interface in org.apache.poi.ss.formula.eval">ValueEval</a> ev)</code> -<div class="block">Applies some conversion rules if the supplied value is not already an integer.<br/> +<div class="block">Applies some conversion rules if the supplied value is not already an integer.<br> Value is first coerced to a <tt>double</tt> ( See <tt>coerceValueToDouble()</tt> ).</div> </td> </tr> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html Mon Jul 24 09:18:21 2017 @@ -127,7 +127,7 @@ extends java.lang.Object</pre> <tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html#copyUpdatedCells(org.apache.poi.ss.usermodel.Workbook)">copyUpdatedCells</a></strong>(<a href="../../../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a> workbook)</code> -<div class="block">Copies the values of all updated cells (modified by calls to <a href="../../../../../../../org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html#updateCell(java.lang.String,%20int,%20int,%20org.apache.poi.ss.formula.eval.ValueEval)"><code>updateCell(String, int, int, ValueEval)</code></a>) to the supplied <tt>workbook</tt>.<br/> +<div class="block">Copies the values of all updated cells (modified by calls to <a href="../../../../../../../org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html#updateCell(java.lang.String,%20int,%20int,%20org.apache.poi.ss.formula.eval.ValueEval)"><code>updateCell(String, int, int, ValueEval)</code></a>) to the supplied <tt>workbook</tt>.<br> Typically, the supplied <tt>workbook</tt> is a writable copy of the 'master workbook', but at the very least it must contain sheets with the same names.</div> </td> @@ -220,7 +220,7 @@ extends java.lang.Object</pre> <li class="blockList"> <h4>copyUpdatedCells</h4> <pre>public void copyUpdatedCells(<a href="../../../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a> workbook)</pre> -<div class="block">Copies the values of all updated cells (modified by calls to <a href="../../../../../../../org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html#updateCell(java.lang.String,%20int,%20int,%20org.apache.poi.ss.formula.eval.ValueEval)"><code>updateCell(String, int, int, ValueEval)</code></a>) to the supplied <tt>workbook</tt>.<br/> +<div class="block">Copies the values of all updated cells (modified by calls to <a href="../../../../../../../org/apache/poi/ss/formula/eval/forked/ForkedEvaluator.html#updateCell(java.lang.String,%20int,%20int,%20org.apache.poi.ss.formula.eval.ValueEval)"><code>updateCell(String, int, int, ValueEval)</code></a>) to the supplied <tt>workbook</tt>.<br> Typically, the supplied <tt>workbook</tt> is a writable copy of the 'master workbook', but at the very least it must contain sheets with the same names.</div> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/BaseNumberUtils.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/BaseNumberUtils.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/BaseNumberUtils.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/BaseNumberUtils.html Mon Jul 24 09:18:21 2017 @@ -100,7 +100,7 @@ <br> <pre>public class <span class="strong">BaseNumberUtils</span> extends java.lang.Object</pre> -<div class="block"><p>Some utils for converting from and to any base<p/></div> +<div class="block"><p>Some utils for converting from and to any base<p></div> <dl><dt><span class="strong">Author:</span></dt> <dd>cedric dot walter @ gmail dot com</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Bin2Dec.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Bin2Dec.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Bin2Dec.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Bin2Dec.html Mon Jul 24 09:18:21 2017 @@ -110,16 +110,16 @@ <pre>public class <span class="strong">Bin2Dec</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel Bin2Dec() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>Bin2Dec </b>(<b>number</b>)<br/> - <p/> +<div class="block">Implementation for Excel Bin2Dec() function.<p> + <p> + <b>Syntax</b>:<br> <b>Bin2Dec </b>(<b>number</b>)<br> + <p> Converts a binary number to decimal. - <p/> + <p> Number is the binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation. - <p/> + <p> Remark If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! error value.</div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Code.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Code.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Code.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Code.html Mon Jul 24 09:18:21 2017 @@ -109,12 +109,12 @@ <br> <pre>public class <span class="strong">Code</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a></pre> -<div class="block">Implementation for Excel CODE () function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>CODE </b>(<b>text</b> )<br/> - <p/> +<div class="block">Implementation for Excel CODE () function.<p> + <p> + <b>Syntax</b>:<br> <b>CODE </b>(<b>text</b> )<br> + <p> Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer. - <p/> + <p> text The text for which you want the code of the first character.</div> <dl><dt><span class="strong">Author:</span></dt> <dd>cedric dot walter @ gmail dot com</dd></dl> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Complex.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Complex.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Complex.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Complex.html Mon Jul 24 09:18:21 2017 @@ -105,25 +105,25 @@ <pre>public class <span class="strong">Complex</span> extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel COMPLEX () function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>COMPLEX </b>(<b>real_num</b>,<b>i_num</b>,<b>suffix </b> )<br/> - <p/> +<div class="block">Implementation for Excel COMPLEX () function.<p> + <p> + <b>Syntax</b>:<br> <b>COMPLEX </b>(<b>real_num</b>,<b>i_num</b>,<b>suffix </b> )<br> + <p> Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. - <p/> - <p/> + <p> + <p> All complex number functions accept "i" and "j" for suffix, but neither "I" nor "J". Using uppercase results in the #VALUE! error value. All functions that accept two or more complex numbers require that all suffixes match. - <p/> + <p> <b>real_num</b> The real coefficient of the complex number. If this argument is nonnumeric, this function returns the #VALUE! error value. - <p/> - <p/> + <p> + <p> <b>i_num</b> The imaginary coefficient of the complex number. If this argument is nonnumeric, this function returns the #VALUE! error value. - <p/> - <p/> + <p> + <p> <b>suffix</b> The suffix for the imaginary component of the complex number. <ul> <li>If omitted, suffix is assumed to be "i".</li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Days360.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Days360.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Days360.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Days360.html Mon Jul 24 09:18:21 2017 @@ -112,31 +112,31 @@ extends java.lang.Object</pre> <code>DAYS360(start_date,end_date,[method])</code> <ul> - <li>Start_date, end_date (required):<br/> - The two dates between which you want to know the number of days.<br/> + <li>Start_date, end_date (required):<br> + The two dates between which you want to know the number of days.<br> If start_date occurs after end_date, the DAYS360 function returns a negative number.</li> - <li>Method (optional):<br/> + <li>Method (optional):<br> A logical value that specifies whether to use the U.S. or European method in the calculation</li> - <li>Method set to false or omitted:<br/> + <li>Method set to false or omitted:<br> the DAYS360 function uses the U.S. (NASD) method. If the starting date is the 31st of a month, it becomes equal to the 30th of the same month. If the ending date is the 31st of a month and the starting date is earlier than the 30th of a month, the ending date becomes equal to the 1st of the next month, otherwise the ending date becomes equal to the 30th of the same month. - The month February and leap years are handled in the following way:<br/> + The month February and leap years are handled in the following way:<br> On a non-leap year the function <code>=DAYS360("2/28/93", "3/1/93", FALSE)</code> returns 1 day - because the DAYS360 function ignores the extra days added to February.<br/> + because the DAYS360 function ignores the extra days added to February.<br> On a leap year the function <code>=DAYS360("2/29/96","3/1/96", FALSE)</code> returns 1 day for the same reason.</li> - <li>Method Set to true:<br/> + <li>Method Set to true:<br> When you set the method parameter to TRUE, the DAYS360 function uses the European method. Starting dates or ending dates that occur on the 31st of a month become equal to the 30th of - the same month. The month February and leap years are handled in the following way:<br/> + the same month. The month February and leap years are handled in the following way:<br> On a non-leap year the function <code>=DAYS360("2/28/93", "3/1/93", TRUE)</code> returns 3 days because the DAYS360 function is counting the extra days added to February to give - February 30 days.<br/> + February 30 days.<br> On a leap year the function <code>=DAYS360("2/29/96", "3/1/96", TRUE)</code> returns 2 days for the same reason.</li> </ul></div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Dec2Bin.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Dec2Bin.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Dec2Bin.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Dec2Bin.html Mon Jul 24 09:18:21 2017 @@ -105,18 +105,18 @@ <pre>public class <span class="strong">Dec2Bin</span> extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel Bin2Dec() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>Bin2Dec </b>(<b>number</b>,<b>[places]</b> )<br/> - <p/> +<div class="block">Implementation for Excel Bin2Dec() function.<p> + <p> + <b>Syntax</b>:<br> <b>Bin2Dec </b>(<b>number</b>,<b>[places]</b> )<br> + <p> Converts a decimal number to binary. - <p/> + <p> The DEC2BIN function syntax has the following arguments: <ul> <li>Number Required. The decimal integer you want to convert. If number is negative, valid place values are ignored and DEC2BIN returns a 10-character (10-bit) binary number in which the most significant bit is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.</li> <li>Places Optional. The number of characters to use. If places is omitted, DEC2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).</li> </ul> - <p/> + <p> Remarks <ul> <li>If number < -512 or if number > 511, DEC2BIN returns the #NUM! error value.</li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Dec2Hex.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Dec2Hex.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Dec2Hex.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Dec2Hex.html Mon Jul 24 09:18:21 2017 @@ -105,10 +105,10 @@ <pre>public final class <span class="strong">Dec2Hex</span> extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel DELTA() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>DEC2HEX </b>(<b>number</b>,<b>places</b> )<br/> - <p/> +<div class="block">Implementation for Excel DELTA() function.<p> + <p> + <b>Syntax</b>:<br> <b>DEC2HEX </b>(<b>number</b>,<b>places</b> )<br> + <p> Converts a decimal number to hexadecimal. The decimal integer you want to convert. If number is negative, places is ignored Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Delta.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Delta.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Delta.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Delta.html Mon Jul 24 09:18:21 2017 @@ -110,10 +110,10 @@ <pre>public final class <span class="strong">Delta</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel DELTA() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>DELTA </b>(<b>number1</b>,<b>number2</b> )<br/> - <p/> +<div class="block">Implementation for Excel DELTA() function.<p> + <p> + <b>Syntax</b>:<br> <b>DELTA </b>(<b>number1</b>,<b>number2</b> )<br> + <p> Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function. Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/EOMonth.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/EOMonth.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/EOMonth.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/EOMonth.html Mon Jul 24 09:18:21 2017 @@ -105,13 +105,13 @@ <pre>public class <span class="strong">EOMonth</span> extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for the Excel EOMONTH() function.<p/> - <p/> - EOMONTH() returns the date of the last day of a month..<p/> - <p/> - <b>Syntax</b>:<br/> - <b>EOMONTH</b>(<b>start_date</b>,<b>months</b>)<p/> - <p/> +<div class="block">Implementation for the Excel EOMONTH() function.<p> + <p> + EOMONTH() returns the date of the last day of a month..<p> + <p> + <b>Syntax</b>:<br> + <b>EOMONTH</b>(<b>start_date</b>,<b>months</b>)<p> + <p> <b>start_date</b> is the starting date of the calculation <b>months</b> is the number of months to be added to <b>start_date</b>, to give a new date. For this new date, <b>EOMONTH</b> returns the date of Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Errortype.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Errortype.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Errortype.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Errortype.html Mon Jul 24 09:18:21 2017 @@ -111,10 +111,10 @@ extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a></pre> <div class="block">Implementation for the ERROR.TYPE() Excel function. <p> - <b>Syntax:</b><br/> + <b>Syntax:</b><br> <b>ERROR.TYPE</b>(<b>errorValue</b>)</p> <p> - Returns a number corresponding to the error type of the supplied argument.<p/> + Returns a number corresponding to the error type of the supplied argument.<p> <p> <table border="1" cellpadding="1" cellspacing="1" summary="Return values for ERROR.TYPE()"> <tr><td>errorValue</td><td>Return Value</td></tr> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FactDouble.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FactDouble.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FactDouble.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FactDouble.html Mon Jul 24 09:18:21 2017 @@ -110,14 +110,14 @@ <pre>public class <span class="strong">FactDouble</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel FACTDOUBLE() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>FACTDOUBLE </b>(<b>number</b>)<br/> - <p/> +<div class="block">Implementation for Excel FACTDOUBLE() function.<p> + <p> + <b>Syntax</b>:<br> <b>FACTDOUBLE </b>(<b>number</b>)<br> + <p> Returns the double factorial of a number. - <p/> + <p> Number is the value for which to return the double factorial. If number is not an integer, it is truncated. - <p/> + <p> Remarks <ul> <li>If number is nonnumeric, FACTDOUBLE returns the #VALUE! error value.</li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FinanceLib.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FinanceLib.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FinanceLib.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FinanceLib.html Mon Jul 24 09:18:21 2017 @@ -106,7 +106,7 @@ extends java.lang.Object</pre> This class is a functon library for common fiscal functions. <b>Glossary of terms/abbreviations:</b> - <br/> + <br> <ul> <li><em>FV:</em> Future Value</li> <li><em>PV:</em> Present Value</li> @@ -123,7 +123,7 @@ extends java.lang.Object</pre> <li>MS Excel function reference: http://office.microsoft.com/en-us/assistance/CH062528251033.aspx</li> </ol> <h3>Implementation Notes:</h3> - Symbols used in the formulae that follow:<br/> + Symbols used in the formulae that follow:<br> <ul> <li>p: present value</li> <li>f: future value</li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FreeRefFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FreeRefFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FreeRefFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/FreeRefFunction.html Mon Jul 24 09:18:21 2017 @@ -98,8 +98,8 @@ <div class="block">For most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed. However, a select few Excel functions have the ability to access cells that were not part of any reference passed as an - argument.<br/> - Two important functions with this feature are <b>INDIRECT</b> and <b>OFFSET</b><p/> + argument.<br> + Two important functions with this feature are <b>INDIRECT</b> and <b>OFFSET</b><p> When POI evaluates formulas, each reference argument is capable of evaluating any cell inside its range. Actually, even cells outside the reference range but on the same sheet can be Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hex2Dec.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hex2Dec.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hex2Dec.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hex2Dec.html Mon Jul 24 09:18:21 2017 @@ -110,12 +110,12 @@ <pre>public class <span class="strong">Hex2Dec</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel HEX2DEC() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>HEX2DEC </b>(<b>number</b>)<br/> - <p/> +<div class="block">Implementation for Excel HEX2DEC() function.<p> + <p> + <b>Syntax</b>:<br> <b>HEX2DEC </b>(<b>number</b>)<br> + <p> Converts a hexadecimal number to decimal. - <p/> + <p> Number is the hexadecimal number you want to convert. Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation. Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hlookup.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hlookup.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hlookup.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hlookup.html Mon Jul 24 09:18:21 2017 @@ -104,18 +104,18 @@ <br> <pre>public final class <span class="strong">Hlookup</span> extends java.lang.Object</pre> -<div class="block">Implementation of the HLOOKUP() function.<p/> +<div class="block">Implementation of the HLOOKUP() function.<p> - HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.<br/> + HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.<br> - <b>Syntax</b>:<br/> - <b>HLOOKUP</b>(<b>lookup_value</b>, <b>table_array</b>, <b>row_index_num</b>, range_lookup)<p/> + <b>Syntax</b>:<br> + <b>HLOOKUP</b>(<b>lookup_value</b>, <b>table_array</b>, <b>row_index_num</b>, range_lookup)<p> - <b>lookup_value</b> The value to be found in the first column of the table array.<br/> - <b>table_array</b> An area reference for the lookup data. <br/> - <b>row_index_num</b> a 1 based index specifying which row value of the lookup data will be returned.<br/> + <b>lookup_value</b> The value to be found in the first column of the table array.<br> + <b>table_array</b> An area reference for the lookup data. <br> + <b>row_index_num</b> a 1 based index specifying which row value of the lookup data will be returned.<br> <b>range_lookup</b> If TRUE (default), HLOOKUP finds the largest value less than or equal to - the lookup_value. If FALSE, only exact matches will be considered<br/></div> + the lookup_value. If FALSE, only exact matches will be considered<br></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Josh Micich</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hyperlink.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hyperlink.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hyperlink.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Hyperlink.html Mon Jul 24 09:18:21 2017 @@ -104,16 +104,16 @@ <br> <pre>public final class <span class="strong">Hyperlink</span> extends java.lang.Object</pre> -<div class="block">Implementation of Excel HYPERLINK function.<p/> +<div class="block">Implementation of Excel HYPERLINK function.<p> In Excel this function has special behaviour - it causes the displayed cell value to behave like - a hyperlink in the GUI. From an evaluation perspective however, it is very simple.<p/> + a hyperlink in the GUI. From an evaluation perspective however, it is very simple.<p> - <b>Syntax</b>:<br/> - <b>HYPERLINK</b>(<b>link_location</b>, friendly_name)<p/> + <b>Syntax</b>:<br> + <b>HYPERLINK</b>(<b>link_location</b>, friendly_name)<p> - <b>link_location</b> The URL of the hyperlink <br/> - <b>friendly_name</b> (optional) the value to display<p/> + <b>link_location</b> The URL of the hyperlink <br> + <b>friendly_name</b> (optional) the value to display<p> Returns last argument. Leaves type unchanged (does not convert to <a href="../../../../../../org/apache/poi/ss/formula/eval/StringEval.html" title="class in org.apache.poi.ss.formula.eval"><code>StringEval</code></a>).</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/ImReal.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/ImReal.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/ImReal.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/ImReal.html Mon Jul 24 09:18:21 2017 @@ -110,14 +110,14 @@ <pre>public class <span class="strong">ImReal</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel ImReal() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>ImReal </b>(<b>Inumber</b>)<br/> - <p/> +<div class="block">Implementation for Excel ImReal() function.<p> + <p> + <b>Syntax</b>:<br> <b>ImReal </b>(<b>Inumber</b>)<br> + <p> Returns the real coefficient of a complex number in x + yi or x + yj text format. - <p/> + <p> Inumber A complex number for which you want the real coefficient. - <p/> + <p> Remarks <ul> <li>If inumber is not in the form x + yi or x + yj, this function returns the #NUM! error value.</li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Imaginary.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Imaginary.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Imaginary.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Imaginary.html Mon Jul 24 09:18:21 2017 @@ -110,14 +110,14 @@ <pre>public class <span class="strong">Imaginary</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel IMAGINARY() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>IMAGINARY </b>(<b>Inumber</b>)<br/> - <p/> +<div class="block">Implementation for Excel IMAGINARY() function.<p> + <p> + <b>Syntax</b>:<br> <b>IMAGINARY </b>(<b>Inumber</b>)<br> + <p> Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. - <p/> + <p> Inumber is a complex number for which you want the imaginary coefficient. - <p/> + <p> Remarks <ul> <li>Use COMPLEX to convert real and imaginary coefficients into a complex number.</li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Index.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Index.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Index.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Index.html Mon Jul 24 09:18:21 2017 @@ -108,7 +108,7 @@ implements <a href="../../../../../../or <div class="block">Implementation for the Excel function INDEX <p> - Syntax : <br/> + Syntax : <br> INDEX ( reference, row_num[, column_num [, area_num]])</br> INDEX ( array, row_num[, column_num]) <table border="0" cellpadding="1" cellspacing="0" summary="Parameter descriptions"> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Indirect.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Indirect.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Indirect.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Indirect.html Mon Jul 24 09:18:21 2017 @@ -105,15 +105,15 @@ <pre>public final class <span class="strong">Indirect</span> extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel function INDIRECT<p/> +<div class="block">Implementation for Excel function INDIRECT<p> - INDIRECT() returns the cell or area reference denoted by the text argument.<p/> + INDIRECT() returns the cell or area reference denoted by the text argument.<p> <b>Syntax</b>:</br> - <b>INDIRECT</b>(<b>ref_text</b>,isA1Style)<p/> + <b>INDIRECT</b>(<b>ref_text</b>,isA1Style)<p> <b>ref_text</b> a string representation of the desired reference as it would - normally be written in a cell formula.<br/> + normally be written in a cell formula.<br> <b>isA1Style</b> (default TRUE) specifies whether the ref_text should be interpreted as A1-style or R1C1-style.</div> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Intercept.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Intercept.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Intercept.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Intercept.html Mon Jul 24 09:18:21 2017 @@ -109,12 +109,12 @@ <br> <pre>public final class <span class="strong">Intercept</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a></pre> -<div class="block">Implementation of Excel function INTERCEPT()<p/> +<div class="block">Implementation of Excel function INTERCEPT()<p> - Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values<br/> + Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values<br> (http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html) - <b>Syntax</b>:<br/> - <b>INTERCEPT</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div> + <b>Syntax</b>:<br> + <b>INTERCEPT</b>(<b>arrayX</b>, <b>arrayY</b>)<p></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Johan Karlsteen</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/LinearRegressionFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/LinearRegressionFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/LinearRegressionFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/LinearRegressionFunction.html Mon Jul 24 09:18:21 2017 @@ -111,12 +111,12 @@ extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a></pre> <div class="block">Base class for linear regression functions. - Calculates the linear regression line that is used to predict y values from x values<br/> + Calculates the linear regression line that is used to predict y values from x values<br> (http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html) - <b>Syntax</b>:<br/> - <b>INTERCEPT</b>(<b>arrayX</b>, <b>arrayY</b>)<p/> + <b>Syntax</b>:<br> + <b>INTERCEPT</b>(<b>arrayX</b>, <b>arrayY</b>)<p> or - <b>SLOPE</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div> + <b>SLOPE</b>(<b>arrayX</b>, <b>arrayY</b>)<p></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Johan Karlsteen</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/LogicalFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/LogicalFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/LogicalFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/LogicalFunction.html Mon Jul 24 09:18:21 2017 @@ -136,15 +136,7 @@ extends <a href="../../../../../../org/a <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISERR">ISERR</a></strong></code> -<div class="block">Implementation of Excel <tt>ISERR()</tt> function.<p/> - - <b>Syntax</b>:<br/> - <b>ISERR</b>(<b>value</b>)<p/> - - <b>value</b> The value to be tested<p/> - - Returns the logical value <tt>TRUE</tt> if value refers to any error value except - <tt>'#N/A'</tt>; otherwise, it returns <tt>FALSE</tt>.</div> +<div class="block">Implementation of Excel <tt>ISERR()</tt> function.</div> </td> </tr> <tr class="altColor"> @@ -158,14 +150,7 @@ extends <a href="../../../../../../org/a <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISNA">ISNA</a></strong></code> -<div class="block">Implementation for Excel ISNA() function.<p/> - - <b>Syntax</b>:<br/> - <b>ISNA</b>(<b>value</b>)<p/> - - <b>value</b> The value to be tested<br/> - <br/> - Returns <tt>TRUE</tt> if the specified value is '#N/A', <tt>FALSE</tt> otherwise.</div> +<div class="block">Implementation for Excel ISNA() function.</div> </td> </tr> <tr class="rowColor"> @@ -318,12 +303,12 @@ extends <a href="../../../../../../org/a <li class="blockList"> <h4>ISERR</h4> <pre>public static final <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> ISERR</pre> -<div class="block">Implementation of Excel <tt>ISERR()</tt> function.<p/> +<div class="block">Implementation of Excel <tt>ISERR()</tt> function.<p> - <b>Syntax</b>:<br/> - <b>ISERR</b>(<b>value</b>)<p/> + <b>Syntax</b>:<br> + <b>ISERR</b>(<b>value</b>)<p> - <b>value</b> The value to be tested<p/> + <b>value</b> The value to be tested<p> Returns the logical value <tt>TRUE</tt> if value refers to any error value except <tt>'#N/A'</tt>; otherwise, it returns <tt>FALSE</tt>.</div> @@ -336,13 +321,13 @@ extends <a href="../../../../../../org/a <li class="blockList"> <h4>ISNA</h4> <pre>public static final <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> ISNA</pre> -<div class="block">Implementation for Excel ISNA() function.<p/> +<div class="block">Implementation for Excel ISNA() function.<p> - <b>Syntax</b>:<br/> - <b>ISNA</b>(<b>value</b>)<p/> + <b>Syntax</b>:<br> + <b>ISNA</b>(<b>value</b>)<p> - <b>value</b> The value to be tested<br/> - <br/> + <b>value</b> The value to be tested<br> + <br> Returns <tt>TRUE</tt> if the specified value is '#N/A', <tt>FALSE</tt> otherwise.</div> </li> </ul> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Lookup.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Lookup.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Lookup.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Lookup.html Mon Jul 24 09:18:21 2017 @@ -104,16 +104,16 @@ <br> <pre>public final class <span class="strong">Lookup</span> extends java.lang.Object</pre> -<div class="block">Implementation of Excel function LOOKUP.<p/> +<div class="block">Implementation of Excel function LOOKUP.<p> LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column. - <b>Syntax</b>:<br/> - <b>VLOOKUP</b>(<b>lookup_value</b>, <b>lookup_vector</b>, result_vector)<p/> + <b>Syntax</b>:<br> + <b>VLOOKUP</b>(<b>lookup_value</b>, <b>lookup_vector</b>, result_vector)<p> - <b>lookup_value</b> The value to be found in the lookup vector.<br/> - <b>lookup_vector</> An area reference for the lookup data. <br/> - <b>result_vector</b> Single row or single column area reference from which the result value is chosen.<br/></div> + <b>lookup_value</b> The value to be found in the lookup vector.<br> + <b>lookup_vector</> An area reference for the lookup data. <br> + <b>result_vector</b> Single row or single column area reference from which the result value is chosen.<br></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Josh Micich</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Match.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Match.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Match.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Match.html Mon Jul 24 09:18:21 2017 @@ -104,13 +104,13 @@ <br> <pre>public final class <span class="strong">Match</span> extends java.lang.Object</pre> -<div class="block">Implementation for the MATCH() Excel function.<p/> +<div class="block">Implementation for the MATCH() Excel function.<p> - <b>Syntax:</b><br/> - <b>MATCH</b>(<b>lookup_value</b>, <b>lookup_array</b>, match_type)<p/> + <b>Syntax:</b><br> + <b>MATCH</b>(<b>lookup_value</b>, <b>lookup_array</b>, match_type)<p> Returns a 1-based index specifying at what position in the <b>lookup_array</b> the specified - <b>lookup_value</b> is found.<p/> + <b>lookup_value</b> is found.<p> Specific matching behaviour can be modified with the optional <b>match_type</b> parameter. @@ -128,8 +128,8 @@ extends java.lang.Object</pre> be ordered, MATCH() can produce incorrect results if this requirement is not met. Observed behaviour in Excel is to return the lowest index value for which every item after that index breaks the match rule.<br> - The (ascending) sort order expected by MATCH() is:<br/> - numbers (low to high), strings (A to Z), boolean (FALSE to TRUE)<br/> + The (ascending) sort order expected by MATCH() is:<br> + numbers (low to high), strings (A to Z), boolean (FALSE to TRUE)<br> MATCH() ignores all elements in the lookup_array with a different type to the lookup_value. Type conversion of the lookup_array elements is never performed.</div> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Oct2Dec.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Oct2Dec.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Oct2Dec.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Oct2Dec.html Mon Jul 24 09:18:21 2017 @@ -110,18 +110,18 @@ <pre>public class <span class="strong">Oct2Dec</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block"><p>Implementation for Excel Oct2Dec() function.<p/> +<div class="block"><p>Implementation for Excel Oct2Dec() function.<p> <p> Converts an octal number to decimal. </p> <p> - <b>Syntax</b>:<br/> <b>Oct2Dec </b>(<b>number</b> ) + <b>Syntax</b>:<br> <b>Oct2Dec </b>(<b>number</b> ) </p> - <p/> + <p> Number is the octal number you want to convert. Number may not contain more than 10 octal characters (30 bits). The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation.. - <p/> + <p> If number is not a valid octal number, OCT2DEC returns the #NUM! error value.</div> <dl><dt><span class="strong">Author:</span></dt> <dd>cedric dot walter @ gmail dot com</dd></dl> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
