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=1560976&r1=1560975&r2=1560976&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 Fri Jan 24 12:42:41 2014 @@ -214,6 +214,12 @@ </tr> <tr class="altColor"> <td class="colFirst"><code>class </code></td> +<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Countifs.html" title="class in org.apache.poi.ss.formula.functions">Countifs</a></strong></code> +<div class="block">Implementation for the function COUNTIFS</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/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/> @@ -222,7 +228,7 @@ Converts a decimal number to binary.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -232,7 +238,7 @@ Converts a decimal number to hexadecimal.</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -242,13 +248,13 @@ Tests whether two values are equal.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/EDate.html" title="class in org.apache.poi.ss.formula.functions">EDate</a></strong></code> <div class="block">Implementation for Excel EDATE () function.</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -258,7 +264,7 @@ Returns the double factorial of a number.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -268,7 +274,7 @@ Converts a hexadecimal number to decimal.</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -278,7 +284,7 @@ Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -288,7 +294,7 @@ Returns the real coefficient of a complex number in x + yi or x + yj text format.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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/> @@ -304,25 +310,25 @@ interpreted as A1-style or R1C1-style.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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> </td> </tr> -<tr class="altColor"> +<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> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumifs.html" title="class in org.apache.poi.ss.formula.functions">Sumifs</a></strong></code> <div class="block">Implementation for the Excel function SUMIFS</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -359,46 +365,50 @@ </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">Quotient.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Quotient.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Countifs.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Countifs.html#instance">instance</a></strong></code> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">Indirect.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Indirect.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Quotient.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Quotient.html#instance">instance</a></strong></code> </td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">ImReal.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/ImReal.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Indirect.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Indirect.html#instance">instance</a></strong></code> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">Dec2Hex.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Hex.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">ImReal.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/ImReal.html#instance">instance</a></strong></code> </td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">Complex.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Complex.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Dec2Hex.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Hex.html#instance">instance</a></strong></code> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">Oct2Dec.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Oct2Dec.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Complex.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Complex.html#instance">instance</a></strong></code> </td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">FactDouble.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Oct2Dec.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Oct2Dec.html#instance">instance</a></strong></code> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">Hex2Dec.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hex2Dec.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">FactDouble.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html#instance">instance</a></strong></code> </td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">Dec2Bin.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Bin.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Hex2Dec.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hex2Dec.html#instance">instance</a></strong></code> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> -<td class="colLast"><span class="strong">EDate.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/EDate.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Dec2Bin.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Bin.html#instance">instance</a></strong></code> </td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> +<td class="colLast"><span class="strong">EDate.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/EDate.html#instance">instance</a></strong></code> </td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a></code></td> <td class="colLast"><span class="strong">WeekNum.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/WeekNum.html#instance">instance</a></strong></code> </td> </tr> </tbody>
Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-frame.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-frame.html?rev=1560976&r1=1560975&r2=1560976&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-frame.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-frame.html Fri Jan 24 12:42:41 2014 @@ -37,6 +37,7 @@ <li><a href="Countblank.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Countblank</a></li> <li><a href="Countif.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Countif</a></li> <li><a href="Countif.StringMatcher.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Countif.StringMatcher</a></li> +<li><a href="Countifs.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Countifs</a></li> <li><a href="DateFunc.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">DateFunc</a></li> <li><a href="Days360.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Days360</a></li> <li><a href="Dec2Bin.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Dec2Bin</a></li> 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=1560976&r1=1560975&r2=1560976&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 Fri Jan 24 12:42:41 2014 @@ -239,19 +239,25 @@ <td class="colLast"> </td> </tr> <tr class="altColor"> +<td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Countifs.html" title="class in org.apache.poi.ss.formula.functions">Countifs</a></td> +<td class="colLast"> +<div class="block">Implementation for the function COUNTIFS</div> +</td> +</tr> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/DateFunc.html" title="class in org.apache.poi.ss.formula.functions">DateFunc</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function DATE</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Days360.html" title="class in org.apache.poi.ss.formula.functions">Days360</a></td> <td class="colLast"> <div class="block">Calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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/> @@ -261,7 +267,7 @@ Converts a decimal number to binary.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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/> @@ -271,7 +277,7 @@ Converts a decimal number to hexadecimal.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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/> @@ -281,23 +287,23 @@ Tests whether two values are equal.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/EDate.html" title="class in org.apache.poi.ss.formula.functions">EDate</a></td> <td class="colLast"> <div class="block">Implementation for Excel EDATE () function.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Errortype.html" title="class in org.apache.poi.ss.formula.functions">Errortype</a></td> <td class="colLast"> <div class="block">Implementation for the ERROR.TYPE() Excel function.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Even.html" title="class in org.apache.poi.ss.formula.functions">Even</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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/> @@ -307,51 +313,51 @@ Returns the double factorial of a number.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Finance.html" title="class in org.apache.poi.ss.formula.functions">Finance</a></td> <td class="colLast"> <div class="block">Implementation of the financial functions pmt, fv, ppmt, ipmt.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html" title="class in org.apache.poi.ss.formula.functions">FinanceFunction</a></td> <td class="colLast"> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/FinanceLib.html" title="class in org.apache.poi.ss.formula.functions">FinanceLib</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed0ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed0ArgFunction</a></td> <td class="colLast"> <div class="block">Convenience base class for functions that only take zero arguments.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a></td> <td class="colLast"> <div class="block">Convenience base class for functions that must take exactly one argument.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a></td> <td class="colLast"> <div class="block">Convenience base class for functions that must take exactly two arguments.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed3ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed3ArgFunction</a></td> <td class="colLast"> <div class="block">Convenience base class for functions that must take exactly three arguments.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Fixed4ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed4ArgFunction</a></td> <td class="colLast"> <div class="block">Convenience base class for functions that must take exactly four arguments.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -361,7 +367,7 @@ Converts a hexadecimal number to decimal.</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -375,7 +381,7 @@ <b>table_array</b> An area reference for the lookup data.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -384,13 +390,13 @@ a hyperlink in the GUI.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/IfFunc.html" title="class in org.apache.poi.ss.formula.functions">IfFunc</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function IF</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -400,7 +406,7 @@ Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -410,13 +416,13 @@ Returns the real coefficient of a complex number in x + yi or x + yj text format.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Index.html" title="class in org.apache.poi.ss.formula.functions">Index</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function INDEX</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -432,7 +438,7 @@ interpreted as A1-style or R1C1-style.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -443,27 +449,27 @@ <b>INTERCEPT</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/IPMT.html" title="class in org.apache.poi.ss.formula.functions">IPMT</a></td> <td class="colLast"> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Irr.html" title="class in org.apache.poi.ss.formula.functions">Irr</a></td> <td class="colLast"> <div class="block">Calculates the internal rate of return.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/LinearRegressionFunction.html" title="class in org.apache.poi.ss.formula.functions">LinearRegressionFunction</a></td> <td class="colLast"> <div class="block">Base class for linear regression functions.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html" title="class in org.apache.poi.ss.formula.functions">LogicalFunction</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<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/> @@ -471,7 +477,7 @@ LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -485,41 +491,41 @@ Specific matching behaviour can be modified with the optional <b>match_type</b> parameter.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/MinaMaxa.html" title="class in org.apache.poi.ss.formula.functions">MinaMaxa</a></td> <td class="colLast"> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Mirr.html" title="class in org.apache.poi.ss.formula.functions">Mirr</a></td> <td class="colLast"> <div class="block">Calculates Modified internal rate of return.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Mode.html" title="class in org.apache.poi.ss.formula.functions">Mode</a></td> <td class="colLast"> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/MultiOperandNumericFunction.html" title="class in org.apache.poi.ss.formula.functions">MultiOperandNumericFunction</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Na.html" title="class in org.apache.poi.ss.formula.functions">Na</a></td> <td class="colLast"> <div class="block">Implementation of Excel function NA()</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/NotImplementedFunction.html" title="class in org.apache.poi.ss.formula.functions">NotImplementedFunction</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Now.html" title="class in org.apache.poi.ss.formula.functions">Now</a></td> <td class="colLast"> <div class="block">Implementation of Excel NOW() Function</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Npv.html" title="class in org.apache.poi.ss.formula.functions">Npv</a></td> <td class="colLast"> <div class="block">Calculates the net present value of an investment by using a discount rate @@ -527,29 +533,29 @@ values).</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html" title="class in org.apache.poi.ss.formula.functions">NumericFunction</a></td> <td class="colLast"> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.OneArg.html" title="class in org.apache.poi.ss.formula.functions">NumericFunction.OneArg</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.TwoArg.html" title="class in org.apache.poi.ss.formula.functions">NumericFunction.TwoArg</a></td> <td class="colLast"> </td> </tr> -<tr class="rowColor"> +<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> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Odd.html" title="class in org.apache.poi.ss.formula.functions">Odd</a></td> <td class="colLast"> </td> </tr> -<tr class="rowColor"> +<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/> @@ -566,31 +572,31 @@ <b>width</b> (default same width as base reference) is the column count for the returned area reference.<br/></div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/PPMT.html" title="class in org.apache.poi.ss.formula.functions">PPMT</a></td> <td class="colLast"> <div class="block">Compute the interest portion of a payment.</div> </td> </tr> -<tr class="rowColor"> +<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> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Rank.html" title="class in org.apache.poi.ss.formula.functions">Rank</a></td> <td class="colLast"> <div class="block">Returns the rank of a number in a list of numbers.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Rate.html" title="class in org.apache.poi.ss.formula.functions">Rate</a></td> <td class="colLast"> <div class="block">Implements the Excel Rate function</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -606,7 +612,7 @@ <b>newText</b> The new text value to replace the removed section<br/></div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -616,7 +622,7 @@ Repeats text a given number of times.</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -626,19 +632,19 @@ Returns a number that indicates where the week falls numerically within a year.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/RowFunc.html" title="class in org.apache.poi.ss.formula.functions">RowFunc</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function ROW</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Rows.html" title="class in org.apache.poi.ss.formula.functions">Rows</a></td> <td class="colLast"> <div class="block">Implementation for Excel ROWS function.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -649,38 +655,38 @@ <b>SLOPE</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div> </td> </tr> -<tr class="altColor"> +<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> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Subtotal.html" title="class in org.apache.poi.ss.formula.functions">Subtotal</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function SUBTOTAL</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Sumif.html" title="class in org.apache.poi.ss.formula.functions">Sumif</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function SUMIF</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Sumifs.html" title="class in org.apache.poi.ss.formula.functions">Sumifs</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function SUMIFS</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Sumproduct.html" title="class in org.apache.poi.ss.formula.functions">Sumproduct</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function SUMPRODUCT</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -692,7 +698,7 @@ result = Σ<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>-y<sub>i</sub><sup>2</sup>)</div> </td> </tr> -<tr class="altColor"> +<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/> @@ -704,7 +710,7 @@ result = Σ<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>+y<sub>i</sub><sup>2</sup>)</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -716,7 +722,7 @@ result = Σ<sub>i: 0..n</sub>(x<sub>i</sub>-y<sub>i</sub>)<sup>2</sup></div> </td> </tr> -<tr class="altColor"> +<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 @@ -724,23 +730,23 @@ If the argument is a text or error value it is returned unmodified.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html" title="class in org.apache.poi.ss.formula.functions">TextFunction</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/TimeFunc.html" title="class in org.apache.poi.ss.formula.functions">TimeFunc</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function TIME</div> </td> </tr> -<tr class="rowColor"> +<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> </td> </tr> -<tr class="altColor"> +<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/> @@ -750,7 +756,7 @@ Converts the text argument to a number.</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -764,13 +770,13 @@ <b>table_array</b> An area reference for the lookup data.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/WeekdayFunc.html" title="class in org.apache.poi.ss.formula.functions">WeekdayFunc</a></td> <td class="colLast"> <div class="block">Implementation for the Excel function WEEKDAY</div> </td> </tr> -<tr class="rowColor"> +<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/> @@ -780,7 +786,7 @@ Returns a number that indicates where the week falls numerically within a year.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/XYNumericFunction.html" title="class in org.apache.poi.ss.formula.functions">XYNumericFunction</a></td> <td class="colLast"> </td> </tr> Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-tree.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-tree.html?rev=1560976&r1=1560975&r2=1560976&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-tree.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-tree.html Fri Jan 24 12:42:41 2014 @@ -81,6 +81,7 @@ <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Count.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Count</span></a> (implements org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a>)</li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Counta.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Counta</span></a> (implements org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a>)</li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Countif.StringMatcher.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Countif.StringMatcher</span></a></li> +<li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Countifs.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Countifs</span></a> (implements org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a>)</li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Days360.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Days360</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Dec2Bin.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Dec2Bin</span></a> (implements org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a>)</li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Dec2Hex.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Dec2Hex</span></a> (implements org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a>)</li> Modified: poi/site/publish/apidocs/overview-tree.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/overview-tree.html?rev=1560976&r1=1560975&r2=1560976&view=diff ============================================================================== --- poi/site/publish/apidocs/overview-tree.html (original) +++ poi/site/publish/apidocs/overview-tree.html Fri Jan 24 12:42:41 2014 @@ -438,6 +438,7 @@ <li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Count.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Count</span></a> (implements org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a>)</li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Counta.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Counta</span></a> (implements org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a>)</li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Countif.StringMatcher.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Countif.StringMatcher</span></a></li> +<li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Countifs.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Countifs</span></a> (implements org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/FreeRefFunction.html" title="interface in org.apache.poi.ss.formula.functions">FreeRefFunction</a>)</li> <li type="circle">org.apache.poi.poifs.crypt.<a href="org/apache/poi/poifs/crypt/CryptoFunctions.html" title="class in org.apache.poi.poifs.crypt"><span class="strong">CryptoFunctions</span></a></li> <li type="circle">org.apache.poi.xssf.util.<a href="org/apache/poi/xssf/util/CTColComparator.html" title="class in org.apache.poi.xssf.util"><span class="strong">CTColComparator</span></a> (implements java.util.Comparator<T>)</li> <li type="circle">org.apache.poi.hslf.record.<a href="org/apache/poi/hslf/record/CurrentUserAtom.html" title="class in org.apache.poi.hslf.record"><span class="strong">CurrentUserAtom</span></a></li> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
