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=1539831&r1=1539830&r2=1539831&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 Thu Nov 7 21:31:17 2013 @@ -142,6 +142,12 @@ <td class="colLast"> </td> </tr> <tr class="altColor"> +<td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/BaseNumberUtils.html" title="class in org.apache.poi.ss.formula.functions">BaseNumberUtils</a></td> +<td class="colLast"> +<div class="block">Some utils for converting from and to any base<p/></div> +</td> +</tr> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Bin2Dec.html" title="class in org.apache.poi.ss.formula.functions">Bin2Dec</a></td> <td class="colLast"> <div class="block">Implementation for Excel Bin2Dec() function.<p/> @@ -151,7 +157,7 @@ Converts a binary number to decimal.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html" title="class in org.apache.poi.ss.formula.functions">BooleanFunction</a></td> <td class="colLast"> <div class="block">Here are the general rules concerning Boolean functions: @@ -161,7 +167,7 @@ Numbers: 0 is false.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html" title="class in org.apache.poi.ss.formula.functions">CalendarFieldFunction</a></td> <td class="colLast"> <div class="block">Implementation of Excel functions Date parsing functions: @@ -169,11 +175,11 @@ Time - HOUR, MINUTE and SECOND</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Choose.html" title="class in org.apache.poi.ss.formula.functions">Choose</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Code.html" title="class in org.apache.poi.ss.formula.functions">Code</a></td> <td class="colLast"> <div class="block">Implementation for Excel CODE () function.<p/> @@ -183,17 +189,17 @@ Returns a numeric code for the first character in a text string.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Column.html" title="class in org.apache.poi.ss.formula.functions">Column</a></td> <td class="colLast"> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Columns.html" title="class in org.apache.poi.ss.formula.functions">Columns</a></td> <td class="colLast"> <div class="block">Implementation for Excel COLUMNS function.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Complex.html" title="class in org.apache.poi.ss.formula.functions">Complex</a></td> <td class="colLast"> <div class="block">Implementation for Excel COMPLEX () function.<p/> @@ -203,49 +209,49 @@ Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Count.html" title="class in org.apache.poi.ss.formula.functions">Count</a></td> <td class="colLast"> <div class="block">Counts the number of cells that contain numeric data within the list of arguments.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Counta.html" title="class in org.apache.poi.ss.formula.functions">Counta</a></td> <td class="colLast"> <div class="block">Counts the number of cells that contain data within the list of arguments.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Countblank.html" title="class in org.apache.poi.ss.formula.functions">Countblank</a></td> <td class="colLast"> <div class="block">Implementation for the function COUNTBLANK</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Countif.html" title="class in org.apache.poi.ss.formula.functions">Countif</a></td> <td class="colLast"> <div class="block">Implementation for the function COUNTIF</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Countif.StringMatcher.html" title="class in org.apache.poi.ss.formula.functions">Countif.StringMatcher</a></td> <td class="colLast"> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Dec2Bin.html" title="class in org.apache.poi.ss.formula.functions">Dec2Bin</a></td> <td class="colLast"> <div class="block">Implementation for Excel Bin2Dec() function.<p/> @@ -255,7 +261,7 @@ Converts a decimal number to binary.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Dec2Hex.html" title="class in org.apache.poi.ss.formula.functions">Dec2Hex</a></td> <td class="colLast"> <div class="block">Implementation for Excel DELTA() function.<p/> @@ -265,7 +271,7 @@ Converts a decimal number to hexadecimal.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/Delta.html" title="class in org.apache.poi.ss.formula.functions">Delta</a></td> <td class="colLast"> <div class="block">Implementation for Excel DELTA() function.<p/> @@ -275,23 +281,23 @@ Tests whether two values are equal.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html" title="class in org.apache.poi.ss.formula.functions">FactDouble</a></td> <td class="colLast"> <div class="block">Implementation for Excel FACTDOUBLE() function.<p/> @@ -301,51 +307,51 @@ Returns the double factorial of a number.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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/> @@ -355,7 +361,7 @@ Converts a hexadecimal number to decimal.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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/> @@ -369,7 +375,7 @@ <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/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/> @@ -378,13 +384,13 @@ a hyperlink in the GUI.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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/> @@ -394,7 +400,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"><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/> @@ -404,13 +410,13 @@ 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"><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="rowColor"> +<tr class="altColor"> <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/> @@ -426,7 +432,7 @@ interpreted as A1-style or R1C1-style.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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/> @@ -437,27 +443,27 @@ <b>INTERCEPT</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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/> @@ -465,7 +471,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="altColor"> +<tr class="rowColor"> <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/> @@ -479,10 +485,16 @@ Specific matching behaviour can be modified with the optional <b>match_type</b> parameter.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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"> +<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"> <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> @@ -528,10 +540,16 @@ <td class="colLast"> </td> </tr> <tr class="rowColor"> +<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"> <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="altColor"> +<tr class="rowColor"> <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/> @@ -548,31 +566,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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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/> @@ -588,7 +606,7 @@ <b>newText</b> The new text value to replace the removed section<br/></div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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/> @@ -598,7 +616,7 @@ Repeats text a given number of times.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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/> @@ -608,19 +626,19 @@ 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/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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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/> @@ -631,38 +649,38 @@ <b>SLOPE</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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/> @@ -674,7 +692,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/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/> @@ -686,7 +704,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/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/> @@ -698,7 +716,7 @@ result = Σ<sub>i: 0..n</sub>(x<sub>i</sub>-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/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 @@ -706,23 +724,23 @@ If the argument is a text or error value it is returned unmodified.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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/> @@ -732,7 +750,7 @@ Converts the text argument to a number.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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/> @@ -746,13 +764,13 @@ <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/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="altColor"> +<tr class="rowColor"> <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/> @@ -762,7 +780,7 @@ 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/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=1539831&r1=1539830&r2=1539831&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 Thu Nov 7 21:31:17 2013 @@ -73,6 +73,7 @@ <li type="circle">java.lang.Object <ul> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Address.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Address</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/BaseNumberUtils.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">BaseNumberUtils</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">BooleanFunction</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/Choose.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Choose</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/Column.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Column</span></a> (implements org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Function0Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function0Arg</a>, org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Function1Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function1Arg</a>)</li> @@ -113,6 +114,7 @@ <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Odd.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Odd</span></a></li> </ul> </li> +<li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Oct2Dec.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Oct2Dec</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/Rows.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Rows</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/T.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">T</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Value.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Value</span></a></li> @@ -163,6 +165,7 @@ <ul> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">AggregateFunction</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/MinaMaxa.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">MinaMaxa</span></a></li> +<li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Mirr.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Mirr</span></a></li> </ul> </li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/NotImplementedFunction.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">NotImplementedFunction</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> Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/ChartLegend.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/ChartLegend.html?rev=1539831&r1=1539830&r2=1539831&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/ChartLegend.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/ChartLegend.html Thu Nov 7 21:31:17 2013 @@ -99,7 +99,7 @@ public interface <span class="strong">Ch extends <a href="../../../../../../org/apache/poi/ss/usermodel/charts/ManuallyPositionable.html" title="interface in org.apache.poi.ss.usermodel.charts">ManuallyPositionable</a></pre> <div class="block">High level representation of chart legend.</div> <dl><dt><span class="strong">Author:</span></dt> - <dd>Roman Kashitsyn</dd></dl> + <dd>Roman Kashitsyn, Martin Andersson</dd></dl> </li> </ul> </div> @@ -123,6 +123,17 @@ extends <a href="../../../../../../org/a <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html#getPosition()">getPosition</a></strong>()</code> </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>boolean</code></td> +<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html#isOverlay()">isOverlay</a></strong>()</code> </td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>void</code></td> +<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html#setOverlay(boolean)">setOverlay</a></strong>(boolean value)</code> +<div class="block">If true the legend is positioned over the chart area otherwise + the legend is displayed next to it.</div> +</td> +</tr> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html#setPosition(org.apache.poi.ss.usermodel.charts.LegendPosition)">setPosition</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/charts/LegendPosition.html" title="enum in org.apache.poi.ss.usermodel.charts">LegendPosition</a> position)</code> </td> </tr> @@ -161,13 +172,37 @@ extends <a href="../../../../../../org/a <a name="setPosition(org.apache.poi.ss.usermodel.charts.LegendPosition)"> <!-- --> </a> -<ul class="blockListLast"> +<ul class="blockList"> <li class="blockList"> <h4>setPosition</h4> <pre>void setPosition(<a href="../../../../../../org/apache/poi/ss/usermodel/charts/LegendPosition.html" title="enum in org.apache.poi.ss.usermodel.charts">LegendPosition</a> position)</pre> <dl><dt><span class="strong">Parameters:</span></dt><dd><code>position</code> - new legend position</dd></dl> </li> </ul> +<a name="isOverlay()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>isOverlay</h4> +<pre>boolean isOverlay()</pre> +<dl><dt><span class="strong">Returns:</span></dt><dd>overlay value.</dd></dl> +</li> +</ul> +<a name="setOverlay(boolean)"> +<!-- --> +</a> +<ul class="blockListLast"> +<li class="blockList"> +<h4>setOverlay</h4> +<pre>void setOverlay(boolean value)</pre> +<div class="block">If true the legend is positioned over the chart area otherwise + the legend is displayed next to it. + + Default is no overlay.</div> +<dl><dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - </dd></dl> +</li> +</ul> </li> </ul> </li> Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/charts/XSSFChartLegend.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/charts/XSSFChartLegend.html?rev=1539831&r1=1539830&r2=1539831&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/charts/XSSFChartLegend.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/charts/XSSFChartLegend.html Thu Nov 7 21:31:17 2013 @@ -104,7 +104,7 @@ extends java.lang.Object implements <a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html" title="interface in org.apache.poi.ss.usermodel.charts">ChartLegend</a></pre> <div class="block">Represents a SpreadsheetML chart legend</div> <dl><dt><span class="strong">Author:</span></dt> - <dd>Roman Kashitsyn</dd></dl> + <dd>Roman Kashitsyn, Martin Andersson</dd></dl> </li> </ul> </div> @@ -159,6 +159,17 @@ implements <a href="../../../../../../or <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/charts/XSSFChartLegend.html#getPosition()">getPosition</a></strong>()</code> </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>boolean</code></td> +<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/charts/XSSFChartLegend.html#isOverlay()">isOverlay</a></strong>()</code> </td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>void</code></td> +<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/charts/XSSFChartLegend.html#setOverlay(boolean)">setOverlay</a></strong>(boolean value)</code> +<div class="block">If true the legend is positioned over the chart area otherwise + the legend is displayed next to it.</div> +</td> +</tr> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/charts/XSSFChartLegend.html#setPosition(org.apache.poi.ss.usermodel.charts.LegendPosition)">setPosition</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/charts/LegendPosition.html" title="enum in org.apache.poi.ss.usermodel.charts">LegendPosition</a> position)</code> </td> </tr> @@ -243,7 +254,7 @@ public org.openxmlformats.schemas.d <a name="getManualLayout()"> <!-- --> </a> -<ul class="blockListLast"> +<ul class="blockList"> <li class="blockList"> <h4>getManualLayout</h4> <pre>public <a href="../../../../../../org/apache/poi/xssf/usermodel/charts/XSSFManualLayout.html" title="class in org.apache.poi.xssf.usermodel.charts">XSSFManualLayout</a> getManualLayout()</pre> @@ -255,6 +266,37 @@ public org.openxmlformats.schemas.d <dt><span class="strong">Returns:</span></dt><dd>manual layout for the chart element.</dd></dl> </li> </ul> +<a name="isOverlay()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>isOverlay</h4> +<pre>public boolean isOverlay()</pre> +<dl> +<dt><strong>Specified by:</strong></dt> +<dd><code><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html#isOverlay()">isOverlay</a></code> in interface <code><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html" title="interface in org.apache.poi.ss.usermodel.charts">ChartLegend</a></code></dd> +<dt><span class="strong">Returns:</span></dt><dd>overlay value.</dd></dl> +</li> +</ul> +<a name="setOverlay(boolean)"> +<!-- --> +</a> +<ul class="blockListLast"> +<li class="blockList"> +<h4>setOverlay</h4> +<pre>public void setOverlay(boolean value)</pre> +<div class="block"><strong>Description copied from interface: <code><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html#setOverlay(boolean)">ChartLegend</a></code></strong></div> +<div class="block">If true the legend is positioned over the chart area otherwise + the legend is displayed next to it. + + Default is no overlay.</div> +<dl> +<dt><strong>Specified by:</strong></dt> +<dd><code><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html#setOverlay(boolean)">setOverlay</a></code> in interface <code><a href="../../../../../../org/apache/poi/ss/usermodel/charts/ChartLegend.html" title="interface in org.apache.poi.ss.usermodel.charts">ChartLegend</a></code></dd> +</dl> +</li> +</ul> </li> </ul> </li> Modified: poi/site/publish/apidocs/overview-tree.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/overview-tree.html?rev=1539831&r1=1539830&r2=1539831&view=diff ============================================================================== --- poi/site/publish/apidocs/overview-tree.html (original) +++ poi/site/publish/apidocs/overview-tree.html Thu Nov 7 21:31:17 2013 @@ -283,6 +283,7 @@ <li type="circle">org.apache.poi.hsmf.datatypes.<a href="org/apache/poi/hsmf/datatypes/AttachmentChunks.AttachmentChunksSorter.html" title="class in org.apache.poi.hsmf.datatypes"><span class="strong">AttachmentChunks.AttachmentChunksSorter</span></a> (implements java.util.Comparator<T>)</li> <li type="circle">org.apache.poi.ss.formula.ptg.<a href="org/apache/poi/ss/formula/ptg/AttrPtg.SpaceType.html" title="class in org.apache.poi.ss.formula.ptg"><span class="strong">AttrPtg.SpaceType</span></a></li> <li type="circle">org.apache.poi.hslf.model.<a href="org/apache/poi/hslf/model/AutoShapes.html" title="class in org.apache.poi.hslf.model"><span class="strong">AutoShapes</span></a></li> +<li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/BaseNumberUtils.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">BaseNumberUtils</span></a></li> <li type="circle">org.apache.poi.poifs.storage.<a href="org/apache/poi/poifs/storage/BATBlock.html" title="class in org.apache.poi.poifs.storage"><span class="strong">BATBlock</span></a></li> <li type="circle">org.apache.poi.poifs.storage.<a href="org/apache/poi/poifs/storage/BATBlock.BATBlockAndIndex.html" title="class in org.apache.poi.poifs.storage"><span class="strong">BATBlock.BATBlockAndIndex</span></a></li> <li type="circle">org.apache.poi.hssf.record.crypto.<a href="org/apache/poi/hssf/record/crypto/Biff8DecryptingStream.html" title="class in org.apache.poi.hssf.record.crypto"><span class="strong">Biff8DecryptingStream</span></a> (implements org.apache.poi.hssf.record.<a href="org/apache/poi/hssf/record/BiffHeaderInput.html" title="interface in org.apache.poi.hssf.record">BiffHeaderInput</a>, org.apache.poi.util.<a href="org/apache/poi/util/LittleEndianInput.html" title="interface in org.apache.poi.util">LittleEndianInput</a>)</li> @@ -641,6 +642,7 @@ <li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Odd.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Odd</span></a></li> </ul> </li> +<li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Oct2Dec.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Oct2Dec</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.eval.<a href="org/apache/poi/ss/formula/eval/PercentEval.html" title="class in org.apache.poi.ss.formula.eval"><span class="strong">PercentEval</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Rows.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Rows</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/T.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">T</span></a></li> @@ -1004,6 +1006,7 @@ <ul> <li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/AggregateFunction.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">AggregateFunction</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/MinaMaxa.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">MinaMaxa</span></a></li> +<li type="circle">org.apache.poi.ss.formula.functions.<a href="org/apache/poi/ss/formula/functions/Mirr.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Mirr</span></a></li> </ul> </li> <li type="circle">org.apache.poi.xslf.model.geom.<a href="org/apache/poi/xslf/model/geom/MultiplyDivideExpression.html" title="class in org.apache.poi.xslf.model.geom"><span class="strong">MultiplyDivideExpression</span></a> (implements org.apache.poi.xslf.model.geom.<a href="org/apache/poi/xslf/model/geom/Expression.html" title="interface in org.apache.poi.xslf.model.geom">Expression</a>)</li> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
