poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1802770 [14/18] - in /poi/site/publish: ./ apidocs/ apidocs/org/apache/poi/common/usermodel/ apidocs/org/apache/poi/common/usermodel/fonts/ apidocs/org/apache/poi/common/usermodel/fonts/class-use/ apidocs/org/apache/poi/ddf/ apidocs/org/ap...
Date Mon, 24 Jul 2017 09:18:26 GMT
Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function1Arg.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function1Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function1Arg.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function1Arg.html Mon Jul 24 09:18:21 2017
@@ -132,11 +132,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Bin2Dec.html" title="class in org.apache.poi.ss.formula.functions">Bin2Dec</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel Bin2Dec() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -150,11 +146,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Code.html" title="class in org.apache.poi.ss.formula.functions">Code</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel CODE () function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -176,21 +168,13 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Bin.html" title="class in org.apache.poi.ss.formula.functions">Dec2Bin</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel Bin2Dec() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Hex.html" title="class in org.apache.poi.ss.formula.functions">Dec2Hex</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel DELTA() function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -206,11 +190,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html" title="class in org.apache.poi.ss.formula.functions">FactDouble</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel FACTDOUBLE() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -226,40 +206,25 @@
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hex2Dec.html" title="class in org.apache.poi.ss.formula.functions">Hex2Dec</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel HEX2DEC() function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hyperlink.html" title="class in org.apache.poi.ss.formula.functions">Hyperlink</a></strong></code>
-<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.</div>
+<div class="block">Implementation of Excel HYPERLINK function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Imaginary.html" title="class in org.apache.poi.ss.formula.functions">Imaginary</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel IMAGINARY() function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/ImReal.html" title="class in org.apache.poi.ss.formula.functions">ImReal</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel ImReal() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -276,7 +241,7 @@
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Oct2Dec.html" title="class in org.apache.poi.ss.formula.functions">Oct2Dec</a></strong></code>
-<div class="block">Implementation for Excel Oct2Dec() function.<p/></div>
+<div class="block">Implementation for Excel Oct2Dec() function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -298,19 +263,13 @@
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/T.html" title="class in org.apache.poi.ss.formula.functions">T</a></strong></code>
-<div class="block">Implementation of Excel T() function
- <p/>
- If the argument is a text or error value it is returned unmodified.</div>
+<div class="block">Implementation of Excel T() function</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Value.html" title="class in org.apache.poi.ss.formula.functions">Value</a></strong></code>
-<div class="block">Implementation for Excel VALUE() function.<p/>
-
- <b>Syntax</b>:<br/> <b>VALUE</b>(<b>text</b>)<br/>
-
- Converts the text argument to a number.</div>
+<div class="block">Implementation for Excel VALUE() function.</div>
 </td>
 </tr>
 </tbody>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function2Arg.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function2Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function2Arg.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function2Arg.html Mon Jul 24 09:18:21 2017
@@ -140,11 +140,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Complex.html" title="class in org.apache.poi.ss.formula.functions">Complex</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel COMPLEX () function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -163,31 +159,19 @@
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Bin.html" title="class in org.apache.poi.ss.formula.functions">Dec2Bin</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel Bin2Dec() function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Hex.html" title="class in org.apache.poi.ss.formula.functions">Dec2Hex</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel DELTA() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Delta.html" title="class in org.apache.poi.ss.formula.functions">Delta</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel DELTA() function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -203,10 +187,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hyperlink.html" title="class in org.apache.poi.ss.formula.functions">Hyperlink</a></strong></code>
-<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.</div>
+<div class="block">Implementation of Excel HYPERLINK function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -224,12 +205,7 @@
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Intercept.html" title="class in org.apache.poi.ss.formula.functions">Intercept</a></strong></code>
-<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/>
- (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>
+<div class="block">Implementation of Excel function INTERCEPT()</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -241,23 +217,13 @@
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Lookup.html" title="class in org.apache.poi.ss.formula.functions">Lookup</a></strong></code>
-<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.</div>
+<div class="block">Implementation of Excel function LOOKUP.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Match.html" title="class in org.apache.poi.ss.formula.functions">Match</a></strong></code>
-<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/>
-
- Returns a 1-based index specifying at what position in the <b>lookup_array</b> the specified
- <b>lookup_value</b> is found.<p/>
-
- Specific matching behaviour can be modified with the optional <b>match_type</b> parameter.</div>
+<div class="block">Implementation for the MATCH() Excel function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -267,7 +233,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Quotient.html" title="class in org.apache.poi.ss.formula.functions">Quotient</a></strong></code>
-<div class="block">Implementation for Excel QUOTIENT () function.<p/></div>
+<div class="block">Implementation for Excel QUOTIENT () function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -279,32 +245,19 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Rept.html" title="class in org.apache.poi.ss.formula.functions">Rept</a></strong></code>
-<div class="block">Implementation for Excel REPT () function.<p/>
- <p/>
- <b>Syntax</b>:<br/> <b>REPT  </b>(<b>text</b>,<b>number_times</b> )<br/>
- <p/>
- Repeats text a given number of times.</div>
+<div class="block">Implementation for Excel REPT () function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Roman.html" title="class in org.apache.poi.ss.formula.functions">Roman</a></strong></code>
-<div class="block">Implementation for Excel WeekNum() function.<p/>
- <p/>
- <b>Syntax</b>:<br/> <b>WeekNum  </b>(<b>Serial_num</b>,<b>Return_type</b>)<br/>
- <p/>
- Returns a number that indicates where the week falls numerically within a year.</div>
+<div class="block">Implementation for Excel WeekNum() function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Slope.html" title="class in org.apache.poi.ss.formula.functions">Slope</a></strong></code>
-<div class="block">Implementation of Excel function SLOPE()<p/>
-
- Calculates the SLOPE 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>SLOPE</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div>
+<div class="block">Implementation of Excel function SLOPE()</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -316,47 +269,25 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumx2my2.html" title="class in org.apache.poi.ss.formula.functions">Sumx2my2</a></strong></code>
-<div class="block">Implementation of Excel function SUMX2MY2()<p/>
-
- Calculates the sum of differences of squares in two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMX2MY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>-y<sub>i</sub><sup>2</sup>)</div>
+<div class="block">Implementation of Excel function SUMX2MY2()</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumx2py2.html" title="class in org.apache.poi.ss.formula.functions">Sumx2py2</a></strong></code>
-<div class="block">Implementation of Excel function SUMX2PY2()<p/>
-
- Calculates the sum of squares in two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMX2PY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>+y<sub>i</sub><sup>2</sup>)</div>
+<div class="block">Implementation of Excel function SUMX2PY2()</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumxmy2.html" title="class in org.apache.poi.ss.formula.functions">Sumxmy2</a></strong></code>
-<div class="block">Implementation of Excel function SUMXMY2()<p/>
-
- Calculates the sum of squares of differences between two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMXMY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub>-y<sub>i</sub>)<sup>2</sup></div>
+<div class="block">Implementation of Excel function SUMXMY2()</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/WeekNum.html" title="class in org.apache.poi.ss.formula.functions">WeekNum</a></strong></code>
-<div class="block">Implementation for Excel WeekNum() function.<p/>
- <p/>
- <b>Syntax</b>:<br/> <b>WeekNum  </b>(<b>Serial_num</b>,<b>Return_type</b>)<br/>
- <p/>
- Returns a number that indicates where the week falls numerically within a year.</div>
+<div class="block">Implementation for Excel WeekNum() function.</div>
 </td>
 </tr>
 <tr class="altColor">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function3Arg.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function3Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function3Arg.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function3Arg.html Mon Jul 24 09:18:21 2017
@@ -100,11 +100,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Complex.html" title="class in org.apache.poi.ss.formula.functions">Complex</a></strong></code>
-<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.</div>
+<div class="block">Implementation for Excel COMPLEX () function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -143,15 +139,7 @@
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hlookup.html" title="class in org.apache.poi.ss.formula.functions">Hlookup</a></strong></code>
-<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/>
-
- <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.</div>
+<div class="block">Implementation of the HLOOKUP() function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -169,23 +157,13 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Lookup.html" title="class in org.apache.poi.ss.formula.functions">Lookup</a></strong></code>
-<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.</div>
+<div class="block">Implementation of Excel function LOOKUP.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Match.html" title="class in org.apache.poi.ss.formula.functions">Match</a></strong></code>
-<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/>
-
- Returns a 1-based index specifying at what position in the <b>lookup_array</b> the specified
- <b>lookup_value</b> is found.<p/>
-
- Specific matching behaviour can be modified with the optional <b>match_type</b> parameter.</div>
+<div class="block">Implementation for the MATCH() Excel function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -197,8 +175,7 @@
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Substitute.html" title="class in org.apache.poi.ss.formula.functions">Substitute</a></strong></code>
-<div class="block">An implementation of the SUBSTITUTE function:<P/>
- Substitutes text in a text string with new text, some number of times.</div>
+<div class="block">An implementation of the SUBSTITUTE function:</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -216,15 +193,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Vlookup.html" title="class in org.apache.poi.ss.formula.functions">Vlookup</a></strong></code>
-<div class="block">Implementation of the VLOOKUP() function.<p/>
-
- VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.<br/>
-
- <b>Syntax</b>:<br/>
- <b>VLOOKUP</b>(<b>lookup_value</b>, <b>table_array</b>, <b>col_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.</div>
+<div class="block">Implementation of the VLOOKUP() function.</div>
 </td>
 </tr>
 </tbody>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function4Arg.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function4Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function4Arg.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function4Arg.html Mon Jul 24 09:18:21 2017
@@ -110,15 +110,7 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hlookup.html" title="class in org.apache.poi.ss.formula.functions">Hlookup</a></strong></code>
-<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/>
-
- <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.</div>
+<div class="block">Implementation of the HLOOKUP() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -130,38 +122,19 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Replace.html" title="class in org.apache.poi.ss.formula.functions">Replace</a></strong></code>
-<div class="block">An implementation of the Excel REPLACE() function:<p/>
- Replaces part of a text string based on the number of characters
- you specify, with another text string.<br/>
-
- <b>Syntax</b>:<br/>
- <b>REPLACE</b>(<b>oldText</b>, <b>startNum</b>, <b>numChars</b>, <b>newText</b>)<p/>
-
- <b>oldText</b>  The text string containing characters to replace<br/>
- <b>startNum</b> The position of the first character to replace (1-based)<br/>
- <b>numChars</b> The number of characters to replace<br/>
- <b>newText</b> The new text value to replace the removed section<br/></div>
+<div class="block">An implementation of the Excel REPLACE() function:</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Substitute.html" title="class in org.apache.poi.ss.formula.functions">Substitute</a></strong></code>
-<div class="block">An implementation of the SUBSTITUTE function:<P/>
- Substitutes text in a text string with new text, some number of times.</div>
+<div class="block">An implementation of the SUBSTITUTE function:</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Vlookup.html" title="class in org.apache.poi.ss.formula.functions">Vlookup</a></strong></code>
-<div class="block">Implementation of the VLOOKUP() function.<p/>
-
- VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.<br/>
-
- <b>Syntax</b>:<br/>
- <b>VLOOKUP</b>(<b>lookup_value</b>, <b>table_array</b>, <b>col_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.</div>
+<div class="block">Implementation of the VLOOKUP() function.</div>
 </td>
 </tr>
 </tbody>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/XYNumericFunction.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/XYNumericFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/XYNumericFunction.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/XYNumericFunction.html Mon Jul 24 09:18:21 2017
@@ -100,37 +100,19 @@
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumx2my2.html" title="class in org.apache.poi.ss.formula.functions">Sumx2my2</a></strong></code>
-<div class="block">Implementation of Excel function SUMX2MY2()<p/>
-
- Calculates the sum of differences of squares in two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMX2MY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>-y<sub>i</sub><sup>2</sup>)</div>
+<div class="block">Implementation of Excel function SUMX2MY2()</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumx2py2.html" title="class in org.apache.poi.ss.formula.functions">Sumx2py2</a></strong></code>
-<div class="block">Implementation of Excel function SUMX2PY2()<p/>
-
- Calculates the sum of squares in two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMX2PY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>+y<sub>i</sub><sup>2</sup>)</div>
+<div class="block">Implementation of Excel function SUMX2PY2()</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumxmy2.html" title="class in org.apache.poi.ss.formula.functions">Sumxmy2</a></strong></code>
-<div class="block">Implementation of Excel function SUMXMY2()<p/>
-
- Calculates the sum of squares of differences between two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMXMY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub>-y<sub>i</sub>)<sup>2</sup></div>
+<div class="block">Implementation of Excel function SUMXMY2()</div>
 </td>
 </tr>
 </tbody>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-summary.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-summary.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-summary.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-summary.html Mon Jul 24 09:18:21 2017
@@ -154,17 +154,13 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/BaseNumberUtils.html" title="class in org.apache.poi.ss.formula.functions">BaseNumberUtils</a></td>
 <td class="colLast">
-<div class="block">Some utils for converting from and to any base<p/></div>
+<div class="block">Some utils for converting from and to any base</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Bin2Dec.html" title="class in org.apache.poi.ss.formula.functions">Bin2Dec</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel Bin2Dec() function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -192,11 +188,7 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Code.html" title="class in org.apache.poi.ss.formula.functions">Code</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel CODE () function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -212,11 +204,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Complex.html" title="class in org.apache.poi.ss.formula.functions">Complex</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel COMPLEX () function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -274,31 +262,19 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Dec2Bin.html" title="class in org.apache.poi.ss.formula.functions">Dec2Bin</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel Bin2Dec() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Dec2Hex.html" title="class in org.apache.poi.ss.formula.functions">Dec2Hex</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel DELTA() function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Delta.html" title="class in org.apache.poi.ss.formula.functions">Delta</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel DELTA() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -330,16 +306,7 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/EOMonth.html" title="class in org.apache.poi.ss.formula.functions">EOMonth</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for the Excel EOMONTH() function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -355,11 +322,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html" title="class in org.apache.poi.ss.formula.functions">FactDouble</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel FACTDOUBLE() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -413,34 +376,19 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Hex2Dec.html" title="class in org.apache.poi.ss.formula.functions">Hex2Dec</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel HEX2DEC() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Hlookup.html" title="class in org.apache.poi.ss.formula.functions">Hlookup</a></td>
 <td class="colLast">
-<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/>
-
- <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.</div>
+<div class="block">Implementation of the HLOOKUP() function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Hyperlink.html" title="class in org.apache.poi.ss.formula.functions">Hyperlink</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation of Excel HYPERLINK function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -452,21 +400,13 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Imaginary.html" title="class in org.apache.poi.ss.formula.functions">Imaginary</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel IMAGINARY() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/ImReal.html" title="class in org.apache.poi.ss.formula.functions">ImReal</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation for Excel ImReal() function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -478,28 +418,13 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Indirect.html" title="class in org.apache.poi.ss.formula.functions">Indirect</a></td>
 <td class="colLast">
-<div class="block">Implementation for Excel function INDIRECT<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>ref_text</b> a string representation of the desired reference as it would
- 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>
+<div class="block">Implementation for Excel function INDIRECT</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Intercept.html" title="class in org.apache.poi.ss.formula.functions">Intercept</a></td>
 <td class="colLast">
-<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/>
- (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>
+<div class="block">Implementation of Excel function INTERCEPT()</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -528,23 +453,13 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Lookup.html" title="class in org.apache.poi.ss.formula.functions">Lookup</a></td>
 <td class="colLast">
-<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.</div>
+<div class="block">Implementation of Excel function LOOKUP.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Match.html" title="class in org.apache.poi.ss.formula.functions">Match</a></td>
 <td class="colLast">
-<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/>
-
- Returns a 1-based index specifying at what position in the <b>lookup_array</b> the specified
- <b>lookup_value</b> is found.<p/>
-
- Specific matching behaviour can be modified with the optional <b>match_type</b> parameter.</div>
+<div class="block">Implementation for the MATCH() Excel function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -610,7 +525,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Oct2Dec.html" title="class in org.apache.poi.ss.formula.functions">Oct2Dec</a></td>
 <td class="colLast">
-<div class="block">Implementation for Excel Oct2Dec() function.<p/></div>
+<div class="block">Implementation for Excel Oct2Dec() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -620,18 +535,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Offset.html" title="class in org.apache.poi.ss.formula.functions">Offset</a></td>
 <td class="colLast">
-<div class="block">Implementation for Excel function OFFSET()<p/>
-
- OFFSET returns an area reference that is a specified number of rows and columns from a
- reference cell or area.<p/>
-
- <b>Syntax</b>:<br/>
- <b>OFFSET</b>(<b>reference</b>, <b>rows</b>, <b>cols</b>, height, width)<p/>
- <b>reference</b> is the base reference.<br/>
- <b>rows</b> is the number of rows up or down from the base reference.<br/>
- <b>cols</b> is the number of columns left or right from the base reference.<br/>
- <b>height</b> (default same height as base reference) is the row count for the returned area reference.<br/>
- <b>width</b> (default same width as base reference) is the column count for the returned area reference.<br/></div>
+<div class="block">Implementation for Excel function OFFSET()</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -643,7 +547,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Quotient.html" title="class in org.apache.poi.ss.formula.functions">Quotient</a></td>
 <td class="colLast">
-<div class="block">Implementation for Excel QUOTIENT () function.<p/></div>
+<div class="block">Implementation for Excel QUOTIENT () function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -661,37 +565,19 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Replace.html" title="class in org.apache.poi.ss.formula.functions">Replace</a></td>
 <td class="colLast">
-<div class="block">An implementation of the Excel REPLACE() function:<p/>
- Replaces part of a text string based on the number of characters
- you specify, with another text string.<br/>
-
- <b>Syntax</b>:<br/>
- <b>REPLACE</b>(<b>oldText</b>, <b>startNum</b>, <b>numChars</b>, <b>newText</b>)<p/>
-
- <b>oldText</b>  The text string containing characters to replace<br/>
- <b>startNum</b> The position of the first character to replace (1-based)<br/>
- <b>numChars</b> The number of characters to replace<br/>
- <b>newText</b> The new text value to replace the removed section<br/></div>
+<div class="block">An implementation of the Excel REPLACE() function:</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Rept.html" title="class in org.apache.poi.ss.formula.functions">Rept</a></td>
 <td class="colLast">
-<div class="block">Implementation for Excel REPT () function.<p/>
- <p/>
- <b>Syntax</b>:<br/> <b>REPT  </b>(<b>text</b>,<b>number_times</b> )<br/>
- <p/>
- Repeats text a given number of times.</div>
+<div class="block">Implementation for Excel REPT () function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Roman.html" title="class in org.apache.poi.ss.formula.functions">Roman</a></td>
 <td class="colLast">
-<div class="block">Implementation for Excel WeekNum() function.<p/>
- <p/>
- <b>Syntax</b>:<br/> <b>WeekNum  </b>(<b>Serial_num</b>,<b>Return_type</b>)<br/>
- <p/>
- Returns a number that indicates where the week falls numerically within a year.</div>
+<div class="block">Implementation for Excel WeekNum() function.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -709,19 +595,13 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Slope.html" title="class in org.apache.poi.ss.formula.functions">Slope</a></td>
 <td class="colLast">
-<div class="block">Implementation of Excel function SLOPE()<p/>
-
- Calculates the SLOPE 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>SLOPE</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div>
+<div class="block">Implementation of Excel function SLOPE()</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Substitute.html" title="class in org.apache.poi.ss.formula.functions">Substitute</a></td>
 <td class="colLast">
-<div class="block">An implementation of the SUBSTITUTE function:<P/>
- Substitutes text in a text string with new text, some number of times.</div>
+<div class="block">An implementation of the SUBSTITUTE function:</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -751,45 +631,25 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Sumx2my2.html" title="class in org.apache.poi.ss.formula.functions">Sumx2my2</a></td>
 <td class="colLast">
-<div class="block">Implementation of Excel function SUMX2MY2()<p/>
-
- Calculates the sum of differences of squares in two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMX2MY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>-y<sub>i</sub><sup>2</sup>)</div>
+<div class="block">Implementation of Excel function SUMX2MY2()</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Sumx2py2.html" title="class in org.apache.poi.ss.formula.functions">Sumx2py2</a></td>
 <td class="colLast">
-<div class="block">Implementation of Excel function SUMX2PY2()<p/>
-
- Calculates the sum of squares in two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMX2PY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>+y<sub>i</sub><sup>2</sup>)</div>
+<div class="block">Implementation of Excel function SUMX2PY2()</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Sumxmy2.html" title="class in org.apache.poi.ss.formula.functions">Sumxmy2</a></td>
 <td class="colLast">
-<div class="block">Implementation of Excel function SUMXMY2()<p/>
-
- Calculates the sum of squares of differences between two arrays of the same size.<br/>
- <b>Syntax</b>:<br/>
- <b>SUMXMY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>
-
- result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub>-y<sub>i</sub>)<sup>2</sup></div>
+<div class="block">Implementation of Excel function SUMXMY2()</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/T.html" title="class in org.apache.poi.ss.formula.functions">T</a></td>
 <td class="colLast">
-<div class="block">Implementation of Excel T() function
- <p/>
- If the argument is a text or error value it is returned unmodified.</div>
+<div class="block">Implementation of Excel T() function</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -805,31 +665,19 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Today.html" title="class in org.apache.poi.ss.formula.functions">Today</a></td>
 <td class="colLast">
-<div class="block">Implementation of Excel TODAY() Function<br/></div>
+<div class="block">Implementation of Excel TODAY() Function<br></div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Value.html" title="class in org.apache.poi.ss.formula.functions">Value</a></td>
 <td class="colLast">
-<div class="block">Implementation for Excel VALUE() function.<p/>
-
- <b>Syntax</b>:<br/> <b>VALUE</b>(<b>text</b>)<br/>
-
- Converts the text argument to a number.</div>
+<div class="block">Implementation for Excel VALUE() function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Vlookup.html" title="class in org.apache.poi.ss.formula.functions">Vlookup</a></td>
 <td class="colLast">
-<div class="block">Implementation of the VLOOKUP() function.<p/>
-
- VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.<br/>
-
- <b>Syntax</b>:<br/>
- <b>VLOOKUP</b>(<b>lookup_value</b>, <b>table_array</b>, <b>col_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.</div>
+<div class="block">Implementation of the VLOOKUP() function.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -841,11 +689,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/WeekNum.html" title="class in org.apache.poi.ss.formula.functions">WeekNum</a></td>
 <td class="colLast">
-<div class="block">Implementation for Excel WeekNum() function.<p/>
- <p/>
- <b>Syntax</b>:<br/> <b>WeekNum  </b>(<b>Serial_num</b>,<b>Return_type</b>)<br/>
- <p/>
- Returns a number that indicates where the week falls numerically within a year.</div>
+<div class="block">Implementation for Excel WeekNum() function.</div>
 </td>
 </tr>
 <tr class="rowColor">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/package-summary.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/package-summary.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/package-summary.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/package-summary.html Mon Jul 24 09:18:21 2017
@@ -96,7 +96,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/EvaluationName.html" title="interface in org.apache.poi.ss.formula">EvaluationName</a></td>
 <td class="colLast">
-<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>
 </td>
@@ -104,7 +104,7 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/EvaluationSheet.html" title="interface in org.apache.poi.ss.formula">EvaluationSheet</a></td>
 <td class="colLast">
-<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>
 </td>
@@ -112,7 +112,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></td>
 <td class="colLast">
-<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>
 </td>
@@ -120,7 +120,7 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/ExternSheetReferenceToken.html" title="interface in org.apache.poi.ss.formula">ExternSheetReferenceToken</a></td>
 <td class="colLast">
-<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>
 </td>
@@ -128,7 +128,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/FormulaParsingWorkbook.html" title="interface in org.apache.poi.ss.formula">FormulaParsingWorkbook</a></td>
 <td class="colLast">
-<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>
 </td>
@@ -136,7 +136,7 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html" title="interface in org.apache.poi.ss.formula">FormulaRenderingWorkbook</a></td>
 <td class="colLast">
-<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>
 </td>
@@ -145,7 +145,7 @@
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/IStabilityClassifier.html" title="interface in org.apache.poi.ss.formula">IStabilityClassifier</a></td>
 <td class="colLast">
 <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'.</div>
 </td>
 </tr>
@@ -195,7 +195,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/BaseFormulaEvaluator.html" title="class in org.apache.poi.ss.formula">BaseFormulaEvaluator</a></td>
 <td class="colLast">
-<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>
 <tr class="rowColor">
@@ -208,17 +208,13 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/ConditionalFormattingEvaluator.html" title="class in org.apache.poi.ss.formula">ConditionalFormattingEvaluator</a></td>
 <td class="colLast">
-<div class="block">Evaluates Conditional Formatting constraints.<p/>
-
- For performance reasons, this class keeps a cache of all previously evaluated rules and cells.</div>
+<div class="block">Evaluates Conditional Formatting constraints.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/DataValidationEvaluator.html" title="class in org.apache.poi.ss.formula">DataValidationEvaluator</a></td>
 <td class="colLast">
-<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>
+<div class="block">Evaluates Data Validation constraints.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -265,7 +261,7 @@
 <tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderer.html" title="class in org.apache.poi.ss.formula">FormulaRenderer</a></td>
 <td class="colLast">
-<div class="block">Common logic for rendering formulas.<br/>
+<div class="block">Common logic for rendering formulas.<br>
 
  For POI internal use only</div>
 </td>
@@ -318,10 +314,7 @@
 <tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/formula/WorkbookEvaluator.html" title="class in org.apache.poi.ss.formula">WorkbookEvaluator</a></td>
 <td class="colLast">
-<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/package-use.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html Mon Jul 24 09:18:21 2017
@@ -252,7 +252,7 @@
 <tbody>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/BaseFormulaEvaluator.html#org.apache.poi.hssf.usermodel">BaseFormulaEvaluator</a>
-<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>
 <tr class="rowColor">
@@ -262,21 +262,21 @@
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationName.html#org.apache.poi.hssf.usermodel">EvaluationName</a>
-<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>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationSheet.html#org.apache.poi.hssf.usermodel">EvaluationSheet</a>
-<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>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationWorkbook.html#org.apache.poi.hssf.usermodel">EvaluationWorkbook</a>
-<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>
 </td>
@@ -289,14 +289,14 @@
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaParsingWorkbook.html#org.apache.poi.hssf.usermodel">FormulaParsingWorkbook</a>
-<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>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaRenderingWorkbook.html#org.apache.poi.hssf.usermodel">FormulaRenderingWorkbook</a>
-<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>
 </td>
@@ -304,7 +304,7 @@
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/IStabilityClassifier.html#org.apache.poi.hssf.usermodel">IStabilityClassifier</a>
 <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'.</div>
 </td>
 </tr>
@@ -348,7 +348,7 @@
 <tbody>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/BaseFormulaEvaluator.html#org.apache.poi.ss.formula">BaseFormulaEvaluator</a>
-<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>
 <tr class="rowColor">
@@ -362,9 +362,7 @@
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/DataValidationEvaluator.html#org.apache.poi.ss.formula">DataValidationEvaluator</a>
-<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>
+<div class="block">Evaluates Data Validation constraints.</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -403,21 +401,21 @@
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationName.html#org.apache.poi.ss.formula">EvaluationName</a>
-<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>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationSheet.html#org.apache.poi.ss.formula">EvaluationSheet</a>
-<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>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationWorkbook.html#org.apache.poi.ss.formula">EvaluationWorkbook</a>
-<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>
 </td>
@@ -435,14 +433,14 @@
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaParsingWorkbook.html#org.apache.poi.ss.formula">FormulaParsingWorkbook</a>
-<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>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaRenderingWorkbook.html#org.apache.poi.ss.formula">FormulaRenderingWorkbook</a>
-<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>
 </td>
@@ -460,7 +458,7 @@
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/IStabilityClassifier.html#org.apache.poi.ss.formula">IStabilityClassifier</a>
 <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'.</div>
 </td>
 </tr>
@@ -481,10 +479,7 @@
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/WorkbookEvaluator.html#org.apache.poi.ss.formula">WorkbookEvaluator</a>
-<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>
 <tr class="rowColor">
@@ -507,7 +502,7 @@
 <tbody>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationName.html#org.apache.poi.ss.formula.eval">EvaluationName</a>
-<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>
 </td>
@@ -543,7 +538,7 @@
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/IStabilityClassifier.html#org.apache.poi.ss.formula.eval.forked">IStabilityClassifier</a>
 <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'.</div>
 </td>
 </tr>
@@ -581,14 +576,14 @@
 <tbody>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/ExternSheetReferenceToken.html#org.apache.poi.ss.formula.ptg">ExternSheetReferenceToken</a>
-<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>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaRenderingWorkbook.html#org.apache.poi.ss.formula.ptg">FormulaRenderingWorkbook</a>
-<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>
 </td>
@@ -615,9 +610,7 @@
 <tbody>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/ConditionalFormattingEvaluator.html#org.apache.poi.ss.usermodel">ConditionalFormattingEvaluator</a>
-<div class="block">Evaluates Conditional Formatting constraints.<p/>
-
- For performance reasons, this class keeps a cache of all previously evaluated rules and cells.</div>
+<div class="block">Evaluates Conditional Formatting constraints.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -657,7 +650,7 @@
 <tbody>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/BaseFormulaEvaluator.html#org.apache.poi.xssf.streaming">BaseFormulaEvaluator</a>
-<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>
 <tr class="rowColor">
@@ -667,14 +660,14 @@
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationSheet.html#org.apache.poi.xssf.streaming">EvaluationSheet</a>
-<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>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationWorkbook.html#org.apache.poi.xssf.streaming">EvaluationWorkbook</a>
-<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>
 </td>
@@ -687,14 +680,14 @@
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaParsingWorkbook.html#org.apache.poi.xssf.streaming">FormulaParsingWorkbook</a>
-<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>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaRenderingWorkbook.html#org.apache.poi.xssf.streaming">FormulaRenderingWorkbook</a>
-<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>
 </td>
@@ -702,7 +695,7 @@
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/IStabilityClassifier.html#org.apache.poi.xssf.streaming">IStabilityClassifier</a>
 <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'.</div>
 </td>
 </tr>
@@ -726,7 +719,7 @@
 <tbody>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/BaseFormulaEvaluator.html#org.apache.poi.xssf.usermodel">BaseFormulaEvaluator</a>
-<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>
 <tr class="rowColor">
@@ -736,21 +729,21 @@
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationName.html#org.apache.poi.xssf.usermodel">EvaluationName</a>
-<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>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationSheet.html#org.apache.poi.xssf.usermodel">EvaluationSheet</a>
-<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>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/EvaluationWorkbook.html#org.apache.poi.xssf.usermodel">EvaluationWorkbook</a>
-<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>
 </td>
@@ -763,14 +756,14 @@
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaParsingWorkbook.html#org.apache.poi.xssf.usermodel">FormulaParsingWorkbook</a>
-<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>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaRenderingWorkbook.html#org.apache.poi.xssf.usermodel">FormulaRenderingWorkbook</a>
-<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>
 </td>
@@ -778,7 +771,7 @@
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/IStabilityClassifier.html#org.apache.poi.xssf.usermodel">IStabilityClassifier</a>
 <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'.</div>
 </td>
 </tr>
@@ -787,10 +780,7 @@
 </tr>
 <tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/WorkbookEvaluator.html#org.apache.poi.xssf.usermodel">WorkbookEvaluator</a>
-<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>
 <tr class="altColor">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/ptg/Ptg.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/ptg/Ptg.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/ptg/Ptg.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/ptg/Ptg.html Mon Jul 24 09:18:21 2017
@@ -108,7 +108,7 @@ extends java.lang.Object</pre>
  '<b>p</b>arse <b>t</b>hin<b>g</b>'.  Originally, the name referred to the single
  byte identifier at the start of the token, but in POI, <tt>Ptg</tt> encapsulates
  the whole formula token (initial byte + value data).
- <p/>
+ <p>
 
  <tt>Ptg</tt>s are logically arranged in a tree representing the structure of the
  parsed formula.  However, in BIFF files <tt>Ptg</tt>s are written/read in
@@ -399,7 +399,7 @@ extends java.lang.Object</pre>
                 int&nbsp;offset)</pre>
 <div class="block">Writes the ptgs to the data buffer, starting at the specified offset.
 
- <br/>
+ <br>
  The 2 byte encode length field is <b>not</b> written by this method.</div>
 <dl><dt><span class="strong">Returns:</span></dt><dd>number of bytes written</dd></dl>
 </li>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html Mon Jul 24 09:18:21 2017
@@ -101,48 +101,48 @@
 <pre>public final class <span class="strong">BuiltinFormats</span>
 extends java.lang.Object</pre>
 <div class="block">Utility to identify built-in formats.  The following is a list of the formats as
- returned by this class.<p/>
-<p/>
-       0, "General"<br/>
-       1, "0"<br/>
-       2, "0.00"<br/>
-       3, "#,##0"<br/>
-       4, "#,##0.00"<br/>
-       5, "$#,##0_);($#,##0)"<br/>
-       6, "$#,##0_);[Red]($#,##0)"<br/>
-       7, "$#,##0.00);($#,##0.00)"<br/>
-       8, "$#,##0.00_);[Red]($#,##0.00)"<br/>
-       9, "0%"<br/>
-       0xa, "0.00%"<br/>
-       0xb, "0.00E+00"<br/>
-       0xc, "# ?/?"<br/>
-       0xd, "# ??/??"<br/>
-       0xe, "m/d/yy"<br/>
-       0xf, "d-mmm-yy"<br/>
-       0x10, "d-mmm"<br/>
-       0x11, "mmm-yy"<br/>
-       0x12, "h:mm AM/PM"<br/>
-       0x13, "h:mm:ss AM/PM"<br/>
-       0x14, "h:mm"<br/>
-       0x15, "h:mm:ss"<br/>
-       0x16, "m/d/yy h:mm"<br/>
-<p/>
+ returned by this class.<p>
+<p>
+       0, "General"<br>
+       1, "0"<br>
+       2, "0.00"<br>
+       3, "#,##0"<br>
+       4, "#,##0.00"<br>
+       5, "$#,##0_);($#,##0)"<br>
+       6, "$#,##0_);[Red]($#,##0)"<br>
+       7, "$#,##0.00);($#,##0.00)"<br>
+       8, "$#,##0.00_);[Red]($#,##0.00)"<br>
+       9, "0%"<br>
+       0xa, "0.00%"<br>
+       0xb, "0.00E+00"<br>
+       0xc, "# ?/?"<br>
+       0xd, "# ??/??"<br>
+       0xe, "m/d/yy"<br>
+       0xf, "d-mmm-yy"<br>
+       0x10, "d-mmm"<br>
+       0x11, "mmm-yy"<br>
+       0x12, "h:mm AM/PM"<br>
+       0x13, "h:mm:ss AM/PM"<br>
+       0x14, "h:mm"<br>
+       0x15, "h:mm:ss"<br>
+       0x16, "m/d/yy h:mm"<br>
+<p>
        // 0x17 - 0x24 reserved for international and undocumented
-       0x25, "#,##0_);(#,##0)"<br/>
-       0x26, "#,##0_);[Red](#,##0)"<br/>
-       0x27, "#,##0.00_);(#,##0.00)"<br/>
-       0x28, "#,##0.00_);[Red](#,##0.00)"<br/>
-       0x29, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)"<br/>
-       0x2a, "_($* #,##0_);_($* (#,##0);_($* \"-\"_);_(@_)"<br/>
-       0x2b, "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)"<br/>
-       0x2c, "_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)"<br/>
-       0x2d, "mm:ss"<br/>
-       0x2e, "[h]:mm:ss"<br/>
-       0x2f, "mm:ss.0"<br/>
-       0x30, "##0.0E+0"<br/>
-       0x31, "@" - This is text format.<br/>
-       0x31  "text" - Alias for "@"<br/>
- <p/></div>
+       0x25, "#,##0_);(#,##0)"<br>
+       0x26, "#,##0_);[Red](#,##0)"<br>
+       0x27, "#,##0.00_);(#,##0.00)"<br>
+       0x28, "#,##0.00_);[Red](#,##0.00)"<br>
+       0x29, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)"<br>
+       0x2a, "_($* #,##0_);_($* (#,##0);_($* \"-\"_);_(@_)"<br>
+       0x2b, "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)"<br>
+       0x2c, "_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)"<br>
+       0x2d, "mm:ss"<br>
+       0x2e, "[h]:mm:ss"<br>
+       0x2f, "mm:ss.0"<br>
+       0x30, "##0.0E+0"<br>
+       0x31, "@" - This is text format.<br>
+       0x31  "text" - Alias for "@"<br>
+ <p></div>
 </li>
 </ul>
 </div>
@@ -212,7 +212,7 @@ extends java.lang.Object</pre>
 <tr class="altColor">
 <td class="colFirst"><code>static int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/BuiltinFormats.html#getBuiltinFormat(java.lang.String)">getBuiltinFormat</a></strong>(java.lang.String&nbsp;pFmt)</code>
-<div class="block">Get the format index that matches the given format string.<br/>
+<div class="block">Get the format index that matches the given format string.<br>
  Automatically converts "text" to excel's format string to represent text.</div>
 </td>
 </tr>
@@ -303,7 +303,7 @@ extends java.lang.Object</pre>
 <li class="blockList">
 <h4>getBuiltinFormat</h4>
 <pre>public static&nbsp;int&nbsp;getBuiltinFormat(java.lang.String&nbsp;pFmt)</pre>
-<div class="block">Get the format index that matches the given format string.<br/>
+<div class="block">Get the format index that matches the given format string.<br>
  Automatically converts "text" to excel's format string to represent text.</div>
 <dl><dt><span class="strong">Parameters:</span></dt><dd><code>pFmt</code> - string matching a built-in format</dd>
 <dt><span class="strong">Returns:</span></dt><dd>index of format or -1 if undefined.</dd></dl>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionFilterType.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionFilterType.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionFilterType.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionFilterType.html Mon Jul 24 09:18:21 2017
@@ -112,7 +112,7 @@ extends java.lang.Enum&lt;<a href="../..
 <div class="block">Used primarily for XSSF conditions, which defines a multitude of additional "filter" types
  for conditional formatting.  HSSF rules will always be null (not a filter type) or #FILTER.
  XSSF conditions will be null (not a filter type) or any value other than #FILTER.
- <p/>
+ <p>
  Instance names match the constants from <code>STCfType</code> for convenience.</div>
 </li>
 </ul>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html?rev=1802770&r1=1802769&r2=1802770&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html Mon Jul 24 09:18:21 2017
@@ -158,11 +158,7 @@ extends <a href="../../../../../org/apac
 <tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionFilterType.html" title="enum in org.apache.poi.ss.usermodel">ConditionFilterType</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionFilterType()">getConditionFilterType</a></strong>()</code>
-<div class="block">This is null if 
- <p/>
- <code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionType()"><code>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>
+<div class="block">This is null if</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -178,11 +174,7 @@ extends <a href="../../../../../org/apac
 <tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel">ConditionFilterData</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getFilterConfiguration()">getFilterConfiguration</a></strong>()</code>
-<div class="block">This is null if 
- <p/>
- <code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionFilterType()"><code>getConditionFilterType()</code></a> == null</code>
- <p/>
- This means it is always null for HSSF, which does not define the extended condition types.</div>
+<div class="block">This is null if</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -386,11 +378,11 @@ extends <a href="../../../../../org/apac
 <h4>getConditionFilterType</h4>
 <pre><a href="../../../../../org/apache/poi/ss/usermodel/ConditionFilterType.html" title="enum in org.apache.poi.ss.usermodel">ConditionFilterType</a>&nbsp;getConditionFilterType()</pre>
 <div class="block">This is null if 
- <p/>
+ <p>
  <code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionType()"><code>getConditionType()</code></a> != <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FILTER"><code>ConditionType.FILTER</code></a></code>
- <p/>
+ <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>.
- <p/>
+ <p>
  For XSSF filter rules, this will indicate the specific type of filter.</div>
 <dl><dt><span class="strong">Returns:</span></dt><dd>filter type for filter rules, or null if not a filter rule.</dd></dl>
 </li>
@@ -403,11 +395,11 @@ extends <a href="../../../../../org/apac
 <h4>getFilterConfiguration</h4>
 <pre><a href="../../../../../org/apache/poi/ss/usermodel/ConditionFilterData.html" title="interface in org.apache.poi.ss.usermodel">ConditionFilterData</a>&nbsp;getFilterConfiguration()</pre>
 <div class="block">This is null if 
- <p/>
+ <p>
  <code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionFilterType()"><code>getConditionFilterType()</code></a> == null</code>
- <p/>
+ <p>
  This means it is always null for HSSF, which does not define the extended condition types.
- <p/>
+ <p>
  This object contains the additional configuration information for XSSF filter conditions.</div>
 <dl><dt><span class="strong">Returns:</span></dt><dd>the Filter Configuration Data, or null if there isn't any</dd></dl>
 </li>
@@ -468,13 +460,13 @@ extends <a href="../../../../../org/apac
 <h4>getPriority</h4>
 <pre>int&nbsp;getPriority()</pre>
 <div class="block">The priority of the rule, if defined, otherwise 0.
- <p/>
+ <p>
  If priority is 0, just use definition order, as that's how older HSSF rules 
   are evaluated.
- <p/>
+ <p>
  For XSSF, this should always be set. For HSSF, only newer style rules
   have this set, older ones will return 0.
- <p/>
+ <p>
  If a rule is created but not yet added to a sheet, this value may not be valid.</div>
 <dl><dt><span class="strong">Returns:</span></dt><dd>rule priority</dd></dl>
 </li>



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


Mime
View raw message