Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Offset.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Offset.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Offset.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Offset.html Mon Jul 24 09:18:21 2017 @@ -105,18 +105,18 @@ <pre>public final class <span class="strong">Offset</span> extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></pre> -<div class="block">Implementation for Excel function OFFSET()<p/> +<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/> + 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> + <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> <dl><dt><span class="strong">Author:</span></dt> <dd>Josh Micich</dd></dl> </li>
Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Quotient.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Quotient.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Quotient.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Quotient.html Mon Jul 24 09:18:21 2017 @@ -110,16 +110,16 @@ <pre>public class <span class="strong">Quotient</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block"><p>Implementation for Excel QUOTIENT () function.<p/> +<div class="block"><p>Implementation for Excel QUOTIENT () function.<p> + <p> + <b>Syntax</b>:<br> <b>QUOTIENT</b>(<b>Numerator</b>,<b>Denominator</b>)<br> <p> - <b>Syntax</b>:<br/> <b>QUOTIENT</b>(<b>Numerator</b>,<b>Denominator</b>)<br/> - <p/> <p> Numerator is the dividend. Denominator is the divisor. Returns the integer portion of a division. Use this function when you want to discard the remainder of a division. - <p/> + <p> If either enumerator/denominator is non numeric, QUOTIENT returns the #VALUE! error value. If denominator is equals to zero, QUOTIENT returns the #DIV/0! error value.</div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Replace.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Replace.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Replace.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Replace.html Mon Jul 24 09:18:21 2017 @@ -109,17 +109,17 @@ <br> <pre>public final class <span class="strong">Replace</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed4ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed4ArgFunction</a></pre> -<div class="block">An implementation of the Excel REPLACE() function:<p/> +<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/> + 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>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> + <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> <dl><dt><span class="strong">Author:</span></dt> <dd>Manda Wilson < wilson at c bio dot msk cc dot org ></dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Rept.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Rept.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Rept.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Rept.html Mon Jul 24 09:18:21 2017 @@ -109,10 +109,10 @@ <br> <pre>public class <span class="strong">Rept</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a></pre> -<div class="block">Implementation for Excel REPT () function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>REPT </b>(<b>text</b>,<b>number_times</b> )<br/> - <p/> +<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. Use REPT to fill a cell with a number of instances of a text string. text : text The text that you want to repeat. Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Roman.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Roman.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Roman.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Roman.html Mon Jul 24 09:18:21 2017 @@ -109,13 +109,13 @@ <br> <pre>public class <span class="strong">Roman</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a></pre> -<div class="block">Implementation for Excel WeekNum() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>WeekNum </b>(<b>Serial_num</b>,<b>Return_type</b>)<br/> - <p/> +<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. - <p/> - <p/> + <p> + <p> Serial_num is a date within the week. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Slope.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Slope.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Slope.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Slope.html Mon Jul 24 09:18:21 2017 @@ -109,12 +109,12 @@ <br> <pre>public final class <span class="strong">Slope</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a></pre> -<div class="block">Implementation of Excel function SLOPE()<p/> +<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/> + 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> + <b>Syntax</b>:<br> + <b>SLOPE</b>(<b>arrayX</b>, <b>arrayY</b>)<p></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Johan Karlsteen</dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Substitute.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Substitute.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Substitute.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Substitute.html Mon Jul 24 09:18:21 2017 @@ -104,7 +104,7 @@ <br> <pre>public final class <span class="strong">Substitute</span> extends java.lang.Object</pre> -<div class="block">An implementation of the SUBSTITUTE function:<P/> +<div class="block">An implementation of the SUBSTITUTE function:<p> Substitutes text in a text string with new text, some number of times.</div> <dl><dt><span class="strong">Author:</span></dt> <dd>Manda Wilson < wilson at c bio dot msk cc dot org ></dd></dl> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Subtotal.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Subtotal.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Subtotal.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Subtotal.html Mon Jul 24 09:18:21 2017 @@ -107,12 +107,12 @@ extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></pre> <div class="block">Implementation for the Excel function SUBTOTAL<p> - <b>Syntax :</b> <br/> - SUBTOTAL ( <b>functionCode</b>, <b>ref1</b>, ref2 ... ) <br/> + <b>Syntax :</b> <br> + SUBTOTAL ( <b>functionCode</b>, <b>ref1</b>, ref2 ... ) <br> <table border="1" cellpadding="1" cellspacing="0" summary="Parameter descriptions"> <tr><td><b>functionCode</b></td><td>(1-11) Selects the underlying aggregate function to be used (see table below)</td></tr> <tr><td><b>ref1</b>, ref2 ...</td><td>Arguments to be passed to the underlying aggregate function</td></tr> - </table><br/> + </table><br> </p> <table border="1" cellpadding="1" cellspacing="0" summary="Parameter descriptions"> @@ -129,10 +129,10 @@ implements <a href="../../../../../../or <tr align='center'><td>10</td><td>VAR *</td></tr> <tr align='center'><td>11</td><td>VARP *</td></tr> <tr align='center'><td>101-111</td><td>*</td></tr> - </table><br/> + </table><br> * Not implemented in POI yet. Functions 101-111 are the same as functions 1-11 but with the option 'ignore hidden values'. - <p/></div> + <p></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Paul Tomlin < pault at bulk sms dot com ></dd></dl> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumif.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumif.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumif.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumif.html Mon Jul 24 09:18:21 2017 @@ -106,13 +106,13 @@ extends java.lang.Object</pre> <div class="block">Implementation for the Excel function SUMIF<p> - Syntax : <br/> - SUMIF ( <b>range</b>, <b>criteria</b>, sum_range ) <br/> + Syntax : <br> + SUMIF ( <b>range</b>, <b>criteria</b>, sum_range ) <br> <table border="0" cellpadding="1" cellspacing="0" summary="Parameter descriptions"> <tr><th>range</th><td>The range over which criteria is applied. Also used for addend values when the third parameter is not present</td></tr> <tr><th>criteria</th><td>The value or expression used to filter rows from <b>range</b></td></tr> <tr><th>sum_range</th><td>Locates the top-left corner of the corresponding range of addends - values to be added (after being selected by the criteria)</td></tr> - </table><br/> + </table><br> </p></div> <dl><dt><span class="strong">Author:</span></dt> <dd>Josh Micich</dd></dl> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumifs.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumifs.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumifs.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumifs.html Mon Jul 24 09:18:21 2017 @@ -106,9 +106,9 @@ extends java.lang.Object</pre> <div class="block">Implementation for the Excel function SUMIFS<p> - Syntax : <br/> + Syntax : <br> SUMIFS ( <b>sum_range</b>, <b>criteria_range1</b>, <b>criteria1</>, - [<b>criteria_range2</b>, <b>criteria2</b>], ...) <br/> + [<b>criteria_range2</b>, <b>criteria2</b>], ...) <br> <ul> <li><b>sum_range</b> Required. One or more cells to sum, including numbers or names, ranges, or cell references that contain numbers. Blank and text values are ignored.</li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumproduct.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumproduct.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumproduct.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumproduct.html Mon Jul 24 09:18:21 2017 @@ -107,16 +107,16 @@ extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></pre> <div class="block">Implementation for the Excel function SUMPRODUCT<p> - Syntax : <br/> + Syntax : <br> SUMPRODUCT ( array1[, array2[, array3[, ...]]]) <table border="0" cellpadding="1" cellspacing="0" summary="Parameter descriptions"> <tr><th>array1, ... arrayN </th><td>typically area references, possibly cell references or scalar values</td></tr> - </table><br/> + </table><br> Let A<b>n</b><sub>(<b>i</b>,<b>j</b>)</sub> represent the element in the <b>i</b>th row <b>j</b>th column - of the <b>n</b>th array<br/> - Assuming each array has the same dimensions (W, H), the result is defined as:<br/> + of the <b>n</b>th array<br> + Assuming each array has the same dimensions (W, H), the result is defined as:<br> SUMPRODUCT = Σ<sub><b>i</b>: 1..H</sub> ( Σ<sub><b>j</b>: 1..W</sub> ( Π<sub><b>n</b>: 1..N</sub> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumx2my2.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumx2my2.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumx2my2.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumx2my2.html Mon Jul 24 09:18:21 2017 @@ -114,11 +114,11 @@ <br> <pre>public final class <span class="strong">Sumx2my2</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/XYNumericFunction.html" title="class in org.apache.poi.ss.formula.functions">XYNumericFunction</a></pre> -<div class="block">Implementation of Excel function SUMX2MY2()<p/> +<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/> + 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> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumx2py2.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumx2py2.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumx2py2.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumx2py2.html Mon Jul 24 09:18:21 2017 @@ -114,11 +114,11 @@ <br> <pre>public final class <span class="strong">Sumx2py2</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/XYNumericFunction.html" title="class in org.apache.poi.ss.formula.functions">XYNumericFunction</a></pre> -<div class="block">Implementation of Excel function SUMX2PY2()<p/> +<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/> + 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> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumxmy2.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumxmy2.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumxmy2.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Sumxmy2.html Mon Jul 24 09:18:21 2017 @@ -114,11 +114,11 @@ <br> <pre>public final class <span class="strong">Sumxmy2</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/XYNumericFunction.html" title="class in org.apache.poi.ss.formula.functions">XYNumericFunction</a></pre> -<div class="block">Implementation of Excel function SUMXMY2()<p/> +<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/> + 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> <dl><dt><span class="strong">Author:</span></dt> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/T.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/T.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/T.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/T.html Mon Jul 24 09:18:21 2017 @@ -110,7 +110,7 @@ <pre>public final class <span class="strong">T</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a></pre> <div class="block">Implementation of Excel T() function - <p/> + <p> If the argument is a text or error value it is returned unmodified. All other argument types cause an empty string result. If the argument is an area, the first (top-left) cell is used (regardless of the coordinates of the evaluating formula cell).</div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/TextFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/TextFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/TextFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/TextFunction.html Mon Jul 24 09:18:21 2017 @@ -149,13 +149,7 @@ implements <a href="../../../../../../or <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#FIND">FIND</a></strong></code> -<div class="block">Implementation of the FIND() function.<p/> - - <b>Syntax</b>:<br/> - <b>FIND</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p/> - - FIND returns the character position of the first (case sensitive) occurrence of - <tt>find_text</tt> inside <tt>within_text</tt>.</div> +<div class="block">Implementation of the FIND() function.</div> </td> </tr> <tr class="rowColor"> @@ -177,14 +171,9 @@ implements <a href="../../../../../../or <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#MID">MID</a></strong></code> -<div class="block">An implementation of the MID function<br/> +<div class="block">An implementation of the MID function<br> MID returns a specific number of - characters from a text string, starting at the specified position.<p/> - - <b>Syntax<b>:<br/> <b>MID</b>(<b>text</b>, <b>start_num</b>, - <b>num_chars</b>)<br/> - - Author: Manda Wilson < wilson at c bio dot msk cc dot org ></div> + characters from a text string, starting at the specified position.</div> </td> </tr> <tr class="altColor"> @@ -202,18 +191,13 @@ implements <a href="../../../../../../or <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#SEARCH">SEARCH</a></strong></code> -<div class="block">Implementation of the FIND() function.<p/> - - <b>Syntax</b>:<br/> - <b>SEARCH</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p/> - - SEARCH is a case-insensitive version of FIND()</div> +<div class="block">Implementation of the FIND() function.</div> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#TEXT">TEXT</a></strong></code> -<div class="block">An implementation of the TEXT function<br/> +<div class="block">An implementation of the TEXT function<br> TEXT returns a number value formatted with the given number formatting string.</div> </td> </tr> @@ -406,12 +390,12 @@ implements <a href="../../../../../../or <li class="blockList"> <h4>MID</h4> <pre>public static final <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> MID</pre> -<div class="block">An implementation of the MID function<br/> +<div class="block">An implementation of the MID function<br> MID returns a specific number of - characters from a text string, starting at the specified position.<p/> + characters from a text string, starting at the specified position.<p> - <b>Syntax<b>:<br/> <b>MID</b>(<b>text</b>, <b>start_num</b>, - <b>num_chars</b>)<br/> + <b>Syntax<b>:<br> <b>MID</b>(<b>text</b>, <b>start_num</b>, + <b>num_chars</b>)<br> Author: Manda Wilson < wilson at c bio dot msk cc dot org ></div> </li> @@ -459,14 +443,14 @@ implements <a href="../../../../../../or <li class="blockList"> <h4>TEXT</h4> <pre>public static final <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> TEXT</pre> -<div class="block">An implementation of the TEXT function<br/> +<div class="block">An implementation of the TEXT function<br> TEXT returns a number value formatted with the given number formatting string. This function is not a complete implementation of the Excel function, but handles most of the common cases. All work is passed down to <a href="../../../../../../org/apache/poi/ss/usermodel/DataFormatter.html" title="class in org.apache.poi.ss.usermodel"><code>DataFormatter</code></a> to be done, as this works much the same as the display focused work that that does. - <b>Syntax<b>:<br/> <b>TEXT</b>(<b>value</b>, <b>format_text</b>)<br/></div> + <b>Syntax<b>:<br> <b>TEXT</b>(<b>value</b>, <b>format_text</b>)<br></div> </li> </ul> <a name="FIND"> @@ -476,15 +460,15 @@ implements <a href="../../../../../../or <li class="blockList"> <h4>FIND</h4> <pre>public static final <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> FIND</pre> -<div class="block">Implementation of the FIND() function.<p/> +<div class="block">Implementation of the FIND() function.<p> - <b>Syntax</b>:<br/> - <b>FIND</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p/> + <b>Syntax</b>:<br> + <b>FIND</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p> FIND returns the character position of the first (case sensitive) occurrence of <tt>find_text</tt> inside <tt>within_text</tt>. The third parameter, <tt>start_num</tt>, is optional (default=1) and specifies where to start searching - from. Character positions are 1-based.<p/> + from. Character positions are 1-based.<p> Author: Torstein Tauno Svendsen ([email protected])</div> </li> @@ -496,10 +480,10 @@ implements <a href="../../../../../../or <li class="blockList"> <h4>SEARCH</h4> <pre>public static final <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> SEARCH</pre> -<div class="block">Implementation of the FIND() function.<p/> +<div class="block">Implementation of the FIND() function.<p> - <b>Syntax</b>:<br/> - <b>SEARCH</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p/> + <b>Syntax</b>:<br> + <b>SEARCH</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p> SEARCH is a case-insensitive version of FIND()</div> </li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Today.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Today.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Today.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Today.html Mon Jul 24 09:18:21 2017 @@ -109,7 +109,7 @@ <br> <pre>public final class <span class="strong">Today</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed0ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed0ArgFunction</a></pre> -<div class="block">Implementation of Excel TODAY() Function<br/></div> +<div class="block">Implementation of Excel TODAY() Function<br></div> </li> </ul> </div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Value.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Value.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Value.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Value.html Mon Jul 24 09:18:21 2017 @@ -109,9 +109,9 @@ <br> <pre>public final class <span class="strong">Value</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a></pre> -<div class="block">Implementation for Excel VALUE() function.<p/> +<div class="block">Implementation for Excel VALUE() function.<p> - <b>Syntax</b>:<br/> <b>VALUE</b>(<b>text</b>)<br/> + <b>Syntax</b>:<br> <b>VALUE</b>(<b>text</b>)<br> Converts the text argument to a number. Leading and/or trailing whitespace is ignored. Currency symbols and thousands separators are stripped out. Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Vlookup.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Vlookup.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Vlookup.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Vlookup.html Mon Jul 24 09:18:21 2017 @@ -104,18 +104,18 @@ <br> <pre>public final class <span class="strong">Vlookup</span> extends java.lang.Object</pre> -<div class="block">Implementation of the VLOOKUP() function.<p/> +<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/> + 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>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. <br/> - <b>col_index_num</b> a 1 based index specifying which column value of the lookup data will be returned.<br/> + <b>lookup_value</b> The value to be found in the first column of the table array.<br> + <b>table_array</b> An area reference for the lookup data. <br> + <b>col_index_num</b> a 1 based index specifying which column value of the lookup data will be returned.<br> <b>range_lookup</b> If TRUE (default), VLOOKUP finds the largest value less than or equal to - the lookup_value. If FALSE, only exact matches will be considered<br/></div> + the lookup_value. If FALSE, only exact matches will be considered<br></div> </li> </ul> </div> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/WeekNum.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/WeekNum.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/WeekNum.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/WeekNum.html Mon Jul 24 09:18:21 2017 @@ -110,13 +110,13 @@ <pre>public class <span class="strong">WeekNum</span> extends <a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a> implements <a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></pre> -<div class="block">Implementation for Excel WeekNum() function.<p/> - <p/> - <b>Syntax</b>:<br/> <b>WeekNum </b>(<b>Serial_num</b>,<b>Return_type</b>)<br/> - <p/> +<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. - <p/> - <p/> + <p> + <p> Serial_num is a date within the week. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed0ArgFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed0ArgFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed0ArgFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed0ArgFunction.html Mon Jul 24 09:18:21 2017 @@ -112,7 +112,7 @@ <tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Today.html" title="class in org.apache.poi.ss.formula.functions">Today</a></strong></code> -<div class="block">Implementation of Excel TODAY() Function<br/></div> +<div class="block">Implementation of Excel TODAY() Function<br></div> </td> </tr> </tbody> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed1ArgFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed1ArgFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed1ArgFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed1ArgFunction.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"> @@ -182,41 +174,25 @@ <tr class="rowColor"> <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="altColor"> <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="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"> @@ -233,7 +209,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"> @@ -249,19 +225,13 @@ <tr class="altColor"> <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="rowColor"> <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/Fixed2ArgFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed2ArgFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed2ArgFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed2ArgFunction.html Mon Jul 24 09:18:21 2017 @@ -146,22 +146,13 @@ <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"> <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="rowColor"> @@ -177,84 +168,49 @@ <tr class="rowColor"> <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="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"> <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="altColor"> <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="rowColor"> <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="altColor"> <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="rowColor"> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed4ArgFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed4ArgFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed4ArgFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Fixed4ArgFunction.html Mon Jul 24 09:18:21 2017 @@ -100,17 +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/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> </tbody> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/FreeRefFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/FreeRefFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/FreeRefFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/FreeRefFunction.html Mon Jul 24 09:18:21 2017 @@ -199,21 +199,13 @@ <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"> <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="altColor"> @@ -225,31 +217,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"> @@ -261,84 +241,49 @@ <tr class="rowColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/EOMonth.html" title="class in org.apache.poi.ss.formula.functions">EOMonth</a></strong></code> -<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"> <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"> <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/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="rowColor"> <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="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Indirect.html" title="class in org.apache.poi.ss.formula.functions">Indirect</a></strong></code> -<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="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"> <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"> @@ -350,11 +295,7 @@ <tr class="altColor"> <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> </tbody> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function.html Mon Jul 24 09:18:21 2017 @@ -342,11 +342,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"> @@ -374,11 +370,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"> @@ -394,11 +386,7 @@ <tr class="rowColor"> <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="altColor"> @@ -442,31 +430,19 @@ <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"> <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="rowColor"> @@ -488,11 +464,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"> @@ -536,34 +508,19 @@ <tr class="altColor"> <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="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"> <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"> @@ -575,21 +532,13 @@ <tr class="altColor"> <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="rowColor"> <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="altColor"> @@ -601,12 +550,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"> @@ -635,23 +579,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"> @@ -717,7 +651,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"> @@ -727,18 +661,7 @@ <tr class="rowColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Offset.html" title="class in org.apache.poi.ss.formula.functions">Offset</a></strong></code> -<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="altColor"> @@ -750,7 +673,7 @@ <tr class="rowColor"> <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="altColor"> @@ -768,37 +691,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/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="altColor"> <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="rowColor"> @@ -816,19 +721,13 @@ <tr class="rowColor"> <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="altColor"> <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="rowColor"> @@ -852,45 +751,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/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"> @@ -906,31 +785,19 @@ <tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Today.html" title="class in org.apache.poi.ss.formula.functions">Today</a></strong></code> -<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"><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> <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> <tr class="rowColor"> @@ -942,11 +809,7 @@ <tr class="altColor"> <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="rowColor"> @@ -1074,13 +937,7 @@ <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#FIND">FIND</a></strong></code> -<div class="block">Implementation of the FIND() function.<p/> - - <b>Syntax</b>:<br/> - <b>FIND</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p/> - - FIND returns the character position of the first (case sensitive) occurrence of - <tt>find_text</tt> inside <tt>within_text</tt>.</div> +<div class="block">Implementation of the FIND() function.</div> </td> </tr> <tr class="rowColor"> @@ -1114,15 +971,7 @@ <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISERR">ISERR</a></strong></code> -<div class="block">Implementation of Excel <tt>ISERR()</tt> function.<p/> - - <b>Syntax</b>:<br/> - <b>ISERR</b>(<b>value</b>)<p/> - - <b>value</b> The value to be tested<p/> - - Returns the logical value <tt>TRUE</tt> if value refers to any error value except - <tt>'#N/A'</tt>; otherwise, it returns <tt>FALSE</tt>.</div> +<div class="block">Implementation of Excel <tt>ISERR()</tt> function.</div> </td> </tr> <tr class="rowColor"> @@ -1136,14 +985,7 @@ <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISNA">ISNA</a></strong></code> -<div class="block">Implementation for Excel ISNA() function.<p/> - - <b>Syntax</b>:<br/> - <b>ISNA</b>(<b>value</b>)<p/> - - <b>value</b> The value to be tested<br/> - <br/> - Returns <tt>TRUE</tt> if the specified value is '#N/A', <tt>FALSE</tt> otherwise.</div> +<div class="block">Implementation for Excel ISNA() function.</div> </td> </tr> <tr class="altColor"> @@ -1205,14 +1047,9 @@ <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#MID">MID</a></strong></code> -<div class="block">An implementation of the MID function<br/> +<div class="block">An implementation of the MID function<br> MID returns a specific number of - characters from a text string, starting at the specified position.<p/> - - <b>Syntax<b>:<br/> <b>MID</b>(<b>text</b>, <b>start_num</b>, - <b>num_chars</b>)<br/> - - Author: Manda Wilson < wilson at c bio dot msk cc dot org ></div> + characters from a text string, starting at the specified position.</div> </td> </tr> <tr class="rowColor"> @@ -1310,12 +1147,7 @@ <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#SEARCH">SEARCH</a></strong></code> -<div class="block">Implementation of the FIND() function.<p/> - - <b>Syntax</b>:<br/> - <b>SEARCH</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p/> - - SEARCH is a case-insensitive version of FIND()</div> +<div class="block">Implementation of the FIND() function.</div> </td> </tr> <tr class="altColor"> @@ -1365,7 +1197,7 @@ <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#TEXT">TEXT</a></strong></code> -<div class="block">An implementation of the TEXT function<br/> +<div class="block">An implementation of the TEXT function<br> TEXT returns a number value formatted with the given number formatting string.</div> </td> </tr> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function0Arg.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function0Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function0Arg.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function0Arg.html Mon Jul 24 09:18:21 2017 @@ -128,7 +128,7 @@ <tr class="rowColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Today.html" title="class in org.apache.poi.ss.formula.functions">Today</a></strong></code> -<div class="block">Implementation of Excel TODAY() Function<br/></div> +<div class="block">Implementation of Excel TODAY() Function<br></div> </td> </tr> </tbody> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
