Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/TextFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/TextFunction.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/TextFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/TextFunction.html Thu Oct 30 16:22:08 2014 @@ -189,10 +189,18 @@ implements <a href="../../../../../../or </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> -<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#RIGHT">RIGHT</a></strong></code> </td> +<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#PROPER">PROPER</a></strong></code> +<div class="block">Implementation of the PROPER function: + Normalizes all words (separated by non-word characters) by + making the first letter upper and the rest lower case.</div> +</td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#RIGHT">RIGHT</a></strong></code> </td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#SEARCH">SEARCH</a></strong></code> <div class="block">Implementation of the FIND() function.<p/> @@ -202,14 +210,14 @@ implements <a href="../../../../../../or SEARCH is a case-insensitive version of FIND()</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#TEXT">TEXT</a></strong></code> <div class="block">An implementation of the TEXT function<br/> TEXT returns a number value formatted with the given number formatting string.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#TRIM">TRIM</a></strong></code> <div class="block">An implementation of the TRIM function: @@ -217,7 +225,7 @@ implements <a href="../../../../../../or value is string.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#UPPER">UPPER</a></strong></code> </td> </tr> @@ -361,6 +369,18 @@ implements <a href="../../../../../../or <pre>public static final <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> UPPER</pre> </li> </ul> +<a name="PROPER"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>PROPER</h4> +<pre>public static final <a href="../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> PROPER</pre> +<div class="block">Implementation of the PROPER function: + Normalizes all words (separated by non-word characters) by + making the first letter upper and the rest lower case.</div> +</li> +</ul> <a name="TRIM"> <!-- --> </a>
Added: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/EOMonth.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/EOMonth.html?rev=1635535&view=auto ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/EOMonth.html (added) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/EOMonth.html Thu Oct 30 16:22:08 2014 @@ -0,0 +1,117 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> +<!-- NewPage --> +<html lang="en"> +<head> +<title>Uses of Class org.apache.poi.ss.formula.functions.EOMonth (POI API Documentation)</title> +<link rel="stylesheet" type="text/css" href="../../../../../../../stylesheet.css" title="Style"> +</head> +<body> +<script type="text/javascript"><!-- + if (location.href.indexOf('is-external=true') == -1) { + parent.document.title="Uses of Class org.apache.poi.ss.formula.functions.EOMonth (POI API Documentation)"; + } +//--> +</script> +<noscript> +<div>JavaScript is disabled on your browser.</div> +</noscript> +<!-- ========= START OF TOP NAVBAR ======= --> +<div class="topNav"><a name="navbar_top"> +<!-- --> +</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow"> +<!-- --> +</a> +<ul class="navList" title="Navigation"> +<li><a href="../../../../../../../overview-summary.html">Overview</a></li> +<li><a href="../package-summary.html">Package</a></li> +<li><a href="../../../../../../../org/apache/poi/ss/formula/functions/EOMonth.html" title="class in org.apache.poi.ss.formula.functions">Class</a></li> +<li class="navBarCell1Rev">Use</li> +<li><a href="../package-tree.html">Tree</a></li> +<li><a href="../../../../../../../deprecated-list.html">Deprecated</a></li> +<li><a href="../../../../../../../index-all.html">Index</a></li> +<li><a href="../../../../../../../help-doc.html">Help</a></li> +</ul> +</div> +<div class="subNav"> +<ul class="navList"> +<li>Prev</li> +<li>Next</li> +</ul> +<ul class="navList"> +<li><a href="../../../../../../../index.html?org/apache/poi/ss/formula/functions/class-use/EOMonth.html" target="_top">Frames</a></li> +<li><a href="EOMonth.html" target="_top">No Frames</a></li> +</ul> +<ul class="navList" id="allclasses_navbar_top"> +<li><a href="../../../../../../../allclasses-noframe.html">All Classes</a></li> +</ul> +<div> +<script type="text/javascript"><!-- + allClassesLink = document.getElementById("allclasses_navbar_top"); + if(window==top) { + allClassesLink.style.display = "block"; + } + else { + allClassesLink.style.display = "none"; + } + //--> +</script> +</div> +<a name="skip-navbar_top"> +<!-- --> +</a></div> +<!-- ========= END OF TOP NAVBAR ========= --> +<div class="header"> +<h2 title="Uses of Class org.apache.poi.ss.formula.functions.EOMonth" class="title">Uses of Class<br>org.apache.poi.ss.formula.functions.EOMonth</h2> +</div> +<div class="classUseContainer">No usage of org.apache.poi.ss.formula.functions.EOMonth</div> +<!-- ======= START OF BOTTOM NAVBAR ====== --> +<div class="bottomNav"><a name="navbar_bottom"> +<!-- --> +</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow"> +<!-- --> +</a> +<ul class="navList" title="Navigation"> +<li><a href="../../../../../../../overview-summary.html">Overview</a></li> +<li><a href="../package-summary.html">Package</a></li> +<li><a href="../../../../../../../org/apache/poi/ss/formula/functions/EOMonth.html" title="class in org.apache.poi.ss.formula.functions">Class</a></li> +<li class="navBarCell1Rev">Use</li> +<li><a href="../package-tree.html">Tree</a></li> +<li><a href="../../../../../../../deprecated-list.html">Deprecated</a></li> +<li><a href="../../../../../../../index-all.html">Index</a></li> +<li><a href="../../../../../../../help-doc.html">Help</a></li> +</ul> +</div> +<div class="subNav"> +<ul class="navList"> +<li>Prev</li> +<li>Next</li> +</ul> +<ul class="navList"> +<li><a href="../../../../../../../index.html?org/apache/poi/ss/formula/functions/class-use/EOMonth.html" target="_top">Frames</a></li> +<li><a href="EOMonth.html" target="_top">No Frames</a></li> +</ul> +<ul class="navList" id="allclasses_navbar_bottom"> +<li><a href="../../../../../../../allclasses-noframe.html">All Classes</a></li> +</ul> +<div> +<script type="text/javascript"><!-- + allClassesLink = document.getElementById("allclasses_navbar_bottom"); + if(window==top) { + allClassesLink.style.display = "block"; + } + else { + allClassesLink.style.display = "none"; + } + //--> +</script> +</div> +<a name="skip-navbar_bottom"> +<!-- --> +</a></div> +<!-- ======== END OF BOTTOM NAVBAR ======= --> +<p class="legalCopy"><small> + <i>Copyright 2014 The Apache Software Foundation or + its licensors, as applicable.</i> + </small></p> +</body> +</html> 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=1635535&r1=1635534&r2=1635535&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 Thu Oct 30 16:22:08 2014 @@ -256,6 +256,21 @@ </tr> <tr class="rowColor"> <td class="colFirst"><code>class </code></td> +<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/EOMonth.html" title="class in org.apache.poi.ss.formula.functions">EOMonth</a></strong></code> +<div class="block">Implementation for the Excel EOMONTH() function.<p/> + <p/> + EOMONTH() returns the date of the last day of a month..<p/> + <p/> + <b>Syntax</b>:<br/> + <b>EOMONTH</b>(<b>start_date</b>,<b>months</b>)<p/> + <p/> + <b>start_date</b> is the starting date of the calculation + <b>months</b> is the number of months to be added to <b>start_date</b>, + to give a new date.</div> +</td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html" title="class in org.apache.poi.ss.formula.functions">FactDouble</a></strong></code> <div class="block">Implementation for Excel FACTDOUBLE() function.<p/> <p/> @@ -264,7 +279,7 @@ Returns the double factorial of a number.</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/Hex2Dec.html" title="class in org.apache.poi.ss.formula.functions">Hex2Dec</a></strong></code> <div class="block">Implementation for Excel HEX2DEC() function.<p/> @@ -274,7 +289,7 @@ Converts a hexadecimal number to decimal.</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/Imaginary.html" title="class in org.apache.poi.ss.formula.functions">Imaginary</a></strong></code> <div class="block">Implementation for Excel IMAGINARY() function.<p/> @@ -284,7 +299,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"><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/> @@ -294,7 +309,7 @@ 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"><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/> @@ -310,25 +325,25 @@ interpreted as A1-style or R1C1-style.</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/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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Quotient.html" title="class in org.apache.poi.ss.formula.functions">Quotient</a></strong></code> <div class="block">Implementation for Excel QUOTIENT () function.<p/></div> </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/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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>class </code></td> <td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/WeekNum.html" title="class in org.apache.poi.ss.formula.functions">WeekNum</a></strong></code> <div class="block">Implementation for Excel WeekNum() function.<p/> @@ -361,54 +376,58 @@ </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">Imaginary.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Imaginary.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">EOMonth.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/EOMonth.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">Countifs.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Countifs.html#instance">instance</a></strong></code> </td> +<td class="colLast"><span class="strong">Imaginary.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Imaginary.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">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="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">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="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">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="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">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="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">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="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">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="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">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="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">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="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">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="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> +<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="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> +</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">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/class-use/Function.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function.html Thu Oct 30 16:22:08 2014 @@ -1242,34 +1242,42 @@ </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> -<td class="colLast"><span class="strong">FinanceFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html#PV">PV</a></strong></code> </td> +<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#PROPER">PROPER</a></strong></code> +<div class="block">Implementation of the PROPER function: + Normalizes all words (separated by non-word characters) by + making the first letter upper and the rest lower case.</div> +</td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> -<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#RADIANS">RADIANS</a></strong></code> </td> +<td class="colLast"><span class="strong">FinanceFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html#PV">PV</a></strong></code> </td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> -<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#RAND">RAND</a></strong></code> </td> +<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#RADIANS">RADIANS</a></strong></code> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> -<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#RIGHT">RIGHT</a></strong></code> </td> +<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#RAND">RAND</a></strong></code> </td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> -<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUND">ROUND</a></strong></code> </td> +<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#RIGHT">RIGHT</a></strong></code> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> -<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUNDDOWN">ROUNDDOWN</a></strong></code> </td> +<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUND">ROUND</a></strong></code> </td> </tr> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> -<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUNDUP">ROUNDUP</a></strong></code> </td> +<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUNDDOWN">ROUNDDOWN</a></strong></code> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> +<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUNDUP">ROUNDUP</a></strong></code> </td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#SEARCH">SEARCH</a></strong></code> <div class="block">Implementation of the FIND() function.<p/> @@ -1279,58 +1287,58 @@ SEARCH is a case-insensitive version of FIND()</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">CalendarFieldFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html#SECOND">SECOND</a></strong></code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#SIGN">SIGN</a></strong></code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#SIN">SIN</a></strong></code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#SINH">SINH</a></strong></code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#SMALL">SMALL</a></strong></code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#SQRT">SQRT</a></strong></code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#STDEV">STDEV</a></strong></code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#SUM">SUM</a></strong></code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#SUMSQ">SUMSQ</a></strong></code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#TAN">TAN</a></strong></code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#TANH">TANH</a></strong></code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#TEXT">TEXT</a></strong></code> <div class="block">An implementation of the TEXT function<br/> TEXT returns a number value formatted with the given number formatting string.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#TRIM">TRIM</a></strong></code> <div class="block">An implementation of the TRIM function: @@ -1338,27 +1346,27 @@ value is string.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">BooleanFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html#TRUE">TRUE</a></strong></code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#TRUNC">TRUNC</a></strong></code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#UPPER">UPPER</a></strong></code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#VAR">VAR</a></strong></code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#VARP">VARP</a></strong></code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td> <td class="colLast"><span class="strong">CalendarFieldFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html#YEAR">YEAR</a></strong></code> </td> </tr> 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=1635535&r1=1635534&r2=1635535&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 Thu Oct 30 16:22:08 2014 @@ -44,6 +44,7 @@ <li><a href="Dec2Hex.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Dec2Hex</a></li> <li><a href="Delta.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Delta</a></li> <li><a href="EDate.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">EDate</a></li> +<li><a href="EOMonth.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">EOMonth</a></li> <li><a href="Errortype.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Errortype</a></li> <li><a href="Even.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">Even</a></li> <li><a href="FactDouble.html" title="class in org.apache.poi.ss.formula.functions" target="classFrame">FactDouble</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=1635535&r1=1635534&r2=1635535&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 Oct 30 16:22:08 2014 @@ -294,16 +294,31 @@ </td> </tr> <tr class="rowColor"> +<td class="colFirst"><a href="../../../../../../org/apache/poi/ss/formula/functions/EOMonth.html" title="class in org.apache.poi.ss.formula.functions">EOMonth</a></td> +<td class="colLast"> +<div class="block">Implementation for the Excel EOMONTH() function.<p/> + <p/> + EOMONTH() returns the date of the last day of a month..<p/> + <p/> + <b>Syntax</b>:<br/> + <b>EOMONTH</b>(<b>start_date</b>,<b>months</b>)<p/> + <p/> + <b>start_date</b> is the starting date of the calculation + <b>months</b> is the number of months to be added to <b>start_date</b>, + to give a new date.</div> +</td> +</tr> +<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/> @@ -313,51 +328,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/> @@ -367,7 +382,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/> @@ -381,7 +396,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/> @@ -390,13 +405,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/> @@ -406,7 +421,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/> @@ -416,13 +431,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/> @@ -438,7 +453,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/> @@ -449,27 +464,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/> @@ -477,7 +492,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/> @@ -491,21 +506,21 @@ 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="altColor"> +<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="rowColor"> +<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> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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"> <div class="block">This is the super class for all excel function evaluator @@ -513,25 +528,25 @@ where the order of operands does not matter</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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"> <div class="block">This is the default implementation of a Function class.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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 @@ -539,29 +554,29 @@ values).</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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="altColor"> +<tr class="rowColor"> <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="rowColor"> +<tr class="altColor"> <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="altColor"> +<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="rowColor"> +<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/> @@ -578,31 +593,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/> @@ -618,7 +633,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/> @@ -628,7 +643,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/> @@ -638,19 +653,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/> @@ -661,38 +676,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/> @@ -704,7 +719,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/> @@ -716,7 +731,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/> @@ -728,7 +743,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 @@ -736,23 +751,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/> @@ -762,7 +777,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/> @@ -776,13 +791,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/> @@ -792,7 +807,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=1635535&r1=1635534&r2=1635535&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 Oct 30 16:22:08 2014 @@ -86,6 +86,7 @@ <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> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/EDate.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">EDate</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/EOMonth.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">EOMonth</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/Finance.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">Finance</span></a></li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">FinanceFunction</span></a> (implements org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Function3Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function3Arg</a>, org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/Function4Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function4Arg</a>)</li> <li type="circle">org.apache.poi.ss.formula.functions.<a href="../../../../../../org/apache/poi/ss/formula/functions/FinanceLib.html" title="class in org.apache.poi.ss.formula.functions"><span class="strong">FinanceLib</span></a></li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddress.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddress.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddress.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddress.html Thu Oct 30 16:22:08 2014 @@ -153,7 +153,9 @@ extends <a href="../../../../../org/apac <td class="colOne"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html#CellRangeAddress(int,%20int,%20int,%20int)">CellRangeAddress</a></strong>(int firstRow, int lastRow, int firstCol, - int lastCol)</code> </td> + int lastCol)</code> +<div class="block">Creates new cell range.</div> +</td> </tr> <tr class="rowColor"> <td class="colOne"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html#CellRangeAddress(org.apache.poi.hssf.record.RecordInputStream)">CellRangeAddress</a></strong>(<a href="../../../../../org/apache/poi/hssf/record/RecordInputStream.html" title="class in org.apache.poi.hssf.record">RecordInputStream</a> in)</code> </td> @@ -266,6 +268,8 @@ extends <a href="../../../../../org/apac int lastRow, int firstCol, int lastCol)</pre> +<div class="block">Creates new cell range. Indexes are zero-based.</div> +<dl><dt><span class="strong">Parameters:</span></dt><dd><code>firstRow</code> - Index of first row</dd><dd><code>lastRow</code> - Index of last row (inclusive), must be equal to or larger than <code>firstRow</code></dd><dd><code>firstCol</code> - Index of first column</dd><dd><code>lastCol</code> - Index of last column (inclusive), must be equal to or larger than <code>firstCol</code></dd></dl> </li> </ul> <a name="CellRangeAddress(org.apache.poi.hssf.record.RecordInputStream)"> @@ -291,8 +295,9 @@ extends <a href="../../../../../org/apac <ul class="blockList"> <li class="blockList"> <h4>serialize</h4> -<pre>public int serialize(int offset, - byte[] data)</pre> +<pre>@Deprecated +public int serialize(int offset, + byte[] data)</pre> <div class="block"><span class="strong">Deprecated.</span> <i>use <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html#serialize(org.apache.poi.util.LittleEndianOutput)"><code>serialize(LittleEndianOutput)</code></a></i></div> </li> </ul> Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/WorkbookUtil.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/WorkbookUtil.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/util/WorkbookUtil.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/util/WorkbookUtil.html Thu Oct 30 16:22:08 2014 @@ -153,7 +153,9 @@ extends java.lang.Object</pre> </tr> <tr class="rowColor"> <td class="colFirst"><code>static void</code></td> -<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/WorkbookUtil.html#validateSheetState(int)">validateSheetState</a></strong>(int state)</code> </td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/WorkbookUtil.html#validateSheetState(int)">validateSheetState</a></strong>(int state)</code> +<div class="block">Validates sheet state</div> +</td> </tr> </table> <ul class="blockList"> @@ -269,7 +271,9 @@ extends java.lang.Object</pre> </ul> The string MUST NOT begin or end with the single quote (') character. </p></div> -<dl><dt><span class="strong">Parameters:</span></dt><dd><code>sheetName</code> - the name to validate</dd></dl> +<dl><dt><span class="strong">Parameters:</span></dt><dd><code>sheetName</code> - the name to validate</dd> +<dt><span class="strong">Throws:</span></dt> +<dd><code>java.lang.IllegalArgumentException</code> - if validation fails</dd></dl> </li> </ul> <a name="validateSheetState(int)"> @@ -279,6 +283,13 @@ extends java.lang.Object</pre> <li class="blockList"> <h4>validateSheetState</h4> <pre>public static void validateSheetState(int state)</pre> +<div class="block">Validates sheet state</div> +<dl><dt><span class="strong">Parameters:</span></dt><dd><code>state</code> - the state to validate</dd> +<dt><span class="strong">Throws:</span></dt> +<dd><code>java.lang.IllegalArgumentException</code> - if state is not one of + <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#SHEET_STATE_VISIBLE"><code>Workbook.SHEET_STATE_VISIBLE</code></a>, + <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#SHEET_STATE_HIDDEN"><code>Workbook.SHEET_STATE_HIDDEN</code></a> or + <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#SHEET_STATE_VERY_HIDDEN"><code>Workbook.SHEET_STATE_VERY_HIDDEN</code></a></dd></dl> </li> </ul> </li> Modified: poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XMLSlideShow.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XMLSlideShow.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XMLSlideShow.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XMLSlideShow.html Thu Oct 30 16:22:08 2014 @@ -194,45 +194,57 @@ extends <a href="../../../../../org/apac </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>void</code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#createNotesMaster()">createNotesMaster</a></strong>()</code> +<div class="block">Create a notes master.</div> +</td> +</tr> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFSlide.html" title="class in org.apache.poi.xslf.usermodel">XSLFSlide</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#createSlide()">createSlide</a></strong>()</code> <div class="block">Create a blank slide.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFSlide.html" title="class in org.apache.poi.xslf.usermodel">XSLFSlide</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#createSlide(org.apache.poi.xslf.usermodel.XSLFSlideLayout)">createSlide</a></strong>(<a href="../../../../../org/apache/poi/xslf/usermodel/XSLFSlideLayout.html" title="class in org.apache.poi.xslf.usermodel">XSLFSlideLayout</a> layout)</code> <div class="block">Create a slide and initialize it from the specified layout.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/openxml4j/opc/PackagePart.html" title="class in org.apache.poi.openxml4j.opc">PackagePart</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#getAllEmbedds()">getAllEmbedds</a></strong>()</code> <div class="block">Get the document's embedded files.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureData.html" title="class in org.apache.poi.xslf.usermodel">XSLFPictureData</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#getAllPictures()">getAllPictures</a></strong>()</code> <div class="block">Returns all Pictures, which are referenced from the document itself.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFCommentAuthors.html" title="class in org.apache.poi.xslf.usermodel">XSLFCommentAuthors</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#getCommentAuthors()">getCommentAuthors</a></strong>()</code> <div class="block">Returns the list of comment authors, if there is one.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>org.openxmlformats.schemas.presentationml.x2006.main.CTPresentation</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#getCTPresentation()">getCTPresentation</a></strong>()</code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotesMaster.html" title="class in org.apache.poi.xslf.usermodel">XSLFNotesMaster</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#getNotesMaster()">getNotesMaster</a></strong>()</code> <div class="block">Return the Notes Master, if there is one.</div> </td> </tr> +<tr class="rowColor"> +<td class="colFirst"><code><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotes.html" title="class in org.apache.poi.xslf.usermodel">XSLFNotes</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#getNotesSlide(org.apache.poi.xslf.usermodel.XSLFSlide)">getNotesSlide</a></strong>(<a href="../../../../../org/apache/poi/xslf/usermodel/XSLFSlide.html" title="class in org.apache.poi.xslf.usermodel">XSLFSlide</a> slide)</code> +<div class="block">Return notes slide for the specified slide or create new if it does not exist yet.</div> +</td> +</tr> <tr class="altColor"> <td class="colFirst"><code>java.awt.Dimension</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XMLSlideShow.html#getPageSize()">getPageSize</a></strong>()</code> @@ -464,6 +476,26 @@ public <a href="../../../../../org/ <div class="block">Create a blank slide.</div> </li> </ul> +<a name="getNotesSlide(org.apache.poi.xslf.usermodel.XSLFSlide)"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>getNotesSlide</h4> +<pre>public <a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotes.html" title="class in org.apache.poi.xslf.usermodel">XSLFNotes</a> getNotesSlide(<a href="../../../../../org/apache/poi/xslf/usermodel/XSLFSlide.html" title="class in org.apache.poi.xslf.usermodel">XSLFSlide</a> slide)</pre> +<div class="block">Return notes slide for the specified slide or create new if it does not exist yet.</div> +</li> +</ul> +<a name="createNotesMaster()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>createNotesMaster</h4> +<pre>public void createNotesMaster()</pre> +<div class="block">Create a notes master.</div> +</li> +</ul> <a name="getNotesMaster()"> <!-- --> </a> Modified: poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFImageRenderer.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFImageRenderer.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFImageRenderer.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFImageRenderer.html Thu Oct 30 16:22:08 2014 @@ -174,6 +174,15 @@ extends java.lang.Object</pre> </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>boolean</code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFImageRenderer.html#drawImage(java.awt.Graphics2D,%20org.apache.poi.xslf.usermodel.XSLFPictureData,%20java.awt.geom.Rectangle2D,%20java.awt.Insets)">drawImage</a></strong>(java.awt.Graphics2D graphics, + <a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureData.html" title="class in org.apache.poi.xslf.usermodel">XSLFPictureData</a> data, + java.awt.geom.Rectangle2D anchor, + java.awt.Insets clip)</code> +<div class="block">Render picture data into the supplied graphics</div> +</td> +</tr> +<tr class="altColor"> <td class="colFirst"><code>java.awt.image.BufferedImage</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFImageRenderer.html#readImage(org.apache.poi.openxml4j.opc.PackagePart)">readImage</a></strong>(<a href="../../../../../org/apache/poi/openxml4j/opc/PackagePart.html" title="class in org.apache.poi.openxml4j.opc">PackagePart</a> packagePart)</code> <div class="block">Create a buffered image from the supplied package part.</div> @@ -231,6 +240,20 @@ extends java.lang.Object</pre> <dl><dt><span class="strong">Returns:</span></dt><dd>true if the picture data was successfully rendered</dd></dl> </li> </ul> +<a name="drawImage(java.awt.Graphics2D, org.apache.poi.xslf.usermodel.XSLFPictureData, java.awt.geom.Rectangle2D, java.awt.Insets)"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>drawImage</h4> +<pre>public boolean drawImage(java.awt.Graphics2D graphics, + <a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureData.html" title="class in org.apache.poi.xslf.usermodel">XSLFPictureData</a> data, + java.awt.geom.Rectangle2D anchor, + java.awt.Insets clip)</pre> +<div class="block">Render picture data into the supplied graphics</div> +<dl><dt><span class="strong">Returns:</span></dt><dd>true if the picture data was successfully rendered</dd></dl> +</li> +</ul> <a name="readImage(org.apache.poi.openxml4j.opc.PackagePart)"> <!-- --> </a> Modified: poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFNotes.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFNotes.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFNotes.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFNotes.html Thu Oct 30 16:22:08 2014 @@ -153,6 +153,10 @@ extends <a href="../../../../../org/apac <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotes.html#getRootElementName()">getRootElementName</a></strong>()</code> </td> </tr> <tr class="altColor"> +<td class="colFirst"><code><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFTheme.html" title="class in org.apache.poi.xslf.usermodel">XSLFTheme</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotes.html#getTheme()">getTheme</a></strong>()</code> </td> +</tr> +<tr class="rowColor"> <td class="colFirst"><code>org.openxmlformats.schemas.presentationml.x2006.main.CTNotesSlide</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotes.html#getXmlObject()">getXmlObject</a></strong>()</code> </td> </tr> @@ -218,6 +222,19 @@ extends <a href="../../../../../org/apac </dl> </li> </ul> +<a name="getTheme()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>getTheme</h4> +<pre>public <a href="../../../../../org/apache/poi/xslf/usermodel/XSLFTheme.html" title="class in org.apache.poi.xslf.usermodel">XSLFTheme</a> getTheme()</pre> +<dl><dt><span class="strong">Returns:</span></dt><dd>theme (shared styles) associated with this theme. + By default returns <code>null</code> which means that this sheet is theme-less. + Sheets that support the notion of themes (slides, masters, layouts, etc.) should override this + method and return the corresponding package part.</dd></dl> +</li> +</ul> <a name="getMasterSheet()"> <!-- --> </a> Modified: poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFNotesMaster.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFNotesMaster.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFNotesMaster.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFNotesMaster.html Thu Oct 30 16:22:08 2014 @@ -187,6 +187,10 @@ extends <a href="../../../../../org/apac <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotesMaster.html#getRootElementName()">getRootElementName</a></strong>()</code> </td> </tr> <tr class="altColor"> +<td class="colFirst"><code><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFTheme.html" title="class in org.apache.poi.xslf.usermodel">XSLFTheme</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotesMaster.html#getTheme()">getTheme</a></strong>()</code> </td> +</tr> +<tr class="rowColor"> <td class="colFirst"><code>org.openxmlformats.schemas.presentationml.x2006.main.CTNotesMaster</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFNotesMaster.html#getXmlObject()">getXmlObject</a></strong>()</code> </td> </tr> @@ -278,7 +282,7 @@ extends <a href="../../../../../org/apac <a name="getMasterSheet()"> <!-- --> </a> -<ul class="blockListLast"> +<ul class="blockList"> <li class="blockList"> <h4>getMasterSheet</h4> <pre>public <a href="../../../../../org/apache/poi/xslf/usermodel/XSLFSheet.html" title="class in org.apache.poi.xslf.usermodel">XSLFSheet</a> getMasterSheet()</pre> @@ -288,6 +292,19 @@ extends <a href="../../../../../org/apac <dt><span class="strong">Returns:</span></dt><dd>master of this sheet.</dd></dl> </li> </ul> +<a name="getTheme()"> +<!-- --> +</a> +<ul class="blockListLast"> +<li class="blockList"> +<h4>getTheme</h4> +<pre>public <a href="../../../../../org/apache/poi/xslf/usermodel/XSLFTheme.html" title="class in org.apache.poi.xslf.usermodel">XSLFTheme</a> getTheme()</pre> +<dl><dt><span class="strong">Returns:</span></dt><dd>theme (shared styles) associated with this theme. + By default returns <code>null</code> which means that this sheet is theme-less. + Sheets that support the notion of themes (slides, masters, layouts, etc.) should override this + method and return the corresponding package part.</dd></dl> +</li> +</ul> </li> </ul> </li> Modified: poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFPictureShape.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFPictureShape.html?rev=1635535&r1=1635534&r2=1635535&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFPictureShape.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xslf/usermodel/XSLFPictureShape.html Thu Oct 30 16:22:08 2014 @@ -133,19 +133,23 @@ extends <a href="../../../../../org/apac </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>java.awt.Insets</code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureShape.html#getBlipClip()">getBlipClip</a></strong>()</code> </td> +</tr> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureData.html" title="class in org.apache.poi.xslf.usermodel">XSLFPictureData</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureShape.html#getPictureData()">getPictureData</a></strong>()</code> <div class="block">Return the data on the (internal) picture.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>java.net.URI</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureShape.html#getPictureLink()">getPictureLink</a></strong>()</code> <div class="block">For an external linked picture, return the last-seen path to the picture.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureShape.html#isExternalLinkedPicture()">isExternalLinkedPicture</a></strong>()</code> <div class="block">Is this an internal picture (image data included within @@ -153,7 +157,7 @@ extends <a href="../../../../../org/apac (image lives outside)?</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xslf/usermodel/XSLFPictureShape.html#resize()">resize</a></strong>()</code> <div class="block">Resize this picture to the default size.</div> @@ -242,6 +246,15 @@ extends <a href="../../../../../org/apac For an internal picture, returns null.</div> </li> </ul> +<a name="getBlipClip()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>getBlipClip</h4> +<pre>public java.awt.Insets getBlipClip()</pre> +</li> +</ul> <a name="drawContent(java.awt.Graphics2D)"> <!-- --> </a> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
