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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 = Σ<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 </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 = Σ<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 </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 = Σ<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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 </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 = Σ<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 </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 = Σ<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 </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 = Σ<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 = Σ<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 = Σ<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 = Σ<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 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 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 int getBuiltinFormat(java.lang.String 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<<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> 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> 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 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: [email protected] For additional commands, e-mail: [email protected]
