You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2016/06/20 09:13:48 UTC

svn commit: r1749281 [3/6] - in /poi/site/publish: ./ apidocs/ apidocs/org/apache/poi/hssf/record/cf/ apidocs/org/apache/poi/hssf/usermodel/ apidocs/org/apache/poi/hssf/usermodel/class-use/ apidocs/org/apache/poi/hssf/util/ apidocs/org/apache/poi/ss/fo...

Modified: poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress8Bit.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress8Bit.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress8Bit.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress8Bit.html Mon Jun 20 09:13:46 2016
@@ -182,7 +182,7 @@ extends <a href="../../../../../org/apac
 <!--   -->
 </a>
 <h3>Methods inherited from class&nbsp;org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></h3>
-<code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstColumn()">getFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstRow()">getFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastColumn()">getLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastRow()">getLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxColumn()">getMaxColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxRow()">getMaxRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinColumn()">getMinColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinRow()">getMinRow</a>, <a href="../../../../../org/apache/p
 oi/ss/util/CellRangeAddressBase.html#getNumberOfCells()">getNumberOfCells</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#intersects(org.apache.poi.ss.util.CellRangeAddressBase)">intersects</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullColumnRange()">isFullColumnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullRowRange()">isFullRowRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)">isInRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstColumn(int)">setFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstRow(int)">setFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastColumn(int)">setLastColumn</a>, 
 <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastRow(int)">setLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#toString()">toString</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#validate(org.apache.poi.ss.SpreadsheetVersion)">validate</a></code></li>
+<code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#containsColumn(int)">containsColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#containsRow(int)">containsRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstColumn()">getFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstRow()">getFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastColumn()">getLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastRow()">getLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxColumn()">getMaxColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxRow()">getMaxRow</a>, <a href="../../../../.
 ./org/apache/poi/ss/util/CellRangeAddressBase.html#getMinColumn()">getMinColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinRow()">getMinRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getNumberOfCells()">getNumberOfCells</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#intersects(org.apache.poi.ss.util.CellRangeAddressBase)">intersects</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullColumnRange()">isFullColumnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullRowRange()">isFullRowRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)">isInRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstColumn(int)">setFirstColumn</a>
 , <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstRow(int)">setFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastColumn(int)">setLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastRow(int)">setLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#toString()">toString</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#validate(org.apache.poi.ss.SpreadsheetVersion)">validate</a></code></li>
 </ul>
 <ul class="blockList">
 <li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">

Modified: poi/site/publish/apidocs/org/apache/poi/hssf/util/package-summary.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/util/package-summary.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/util/package-summary.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/util/package-summary.html Mon Jun 20 09:13:46 2016
@@ -34,7 +34,7 @@
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/hssf/usermodel/package-summary.html">Prev Package</a></li>
+<li><a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">Prev Package</a></li>
 <li><a href="../../../../../org/apache/poi/hwmf/draw/package-summary.html">Next Package</a></li>
 </ul>
 <ul class="navList">
@@ -460,7 +460,7 @@ For overviews, tutorials, examples, guid
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/hssf/usermodel/package-summary.html">Prev Package</a></li>
+<li><a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">Prev Package</a></li>
 <li><a href="../../../../../org/apache/poi/hwmf/draw/package-summary.html">Next Package</a></li>
 </ul>
 <ul class="navList">

Modified: poi/site/publish/apidocs/org/apache/poi/hssf/util/package-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/util/package-tree.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/util/package-tree.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/util/package-tree.html Mon Jun 20 09:13:46 2016
@@ -34,7 +34,7 @@
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/hssf/usermodel/package-tree.html">Prev</a></li>
+<li><a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-tree.html">Prev</a></li>
 <li><a href="../../../../../org/apache/poi/hwmf/draw/package-tree.html">Next</a></li>
 </ul>
 <ul class="navList">
@@ -167,7 +167,7 @@
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/hssf/usermodel/package-tree.html">Prev</a></li>
+<li><a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-tree.html">Prev</a></li>
 <li><a href="../../../../../org/apache/poi/hwmf/draw/package-tree.html">Next</a></li>
 </ul>
 <ul class="navList">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/FormulaShifter.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/FormulaShifter.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/FormulaShifter.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/class-use/FormulaShifter.html Mon Jun 20 09:13:46 2016
@@ -86,11 +86,19 @@
 </td>
 </tr>
 <tr class="altColor">
+<td class="colFirst"><a href="#org.apache.poi.hssf.usermodel.helpers">org.apache.poi.hssf.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
+<tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula">org.apache.poi.ss.formula</a></td>
 <td class="colLast">
 <div class="block">This package contains common internal POI code for manipulating formulas.</div>
 </td>
 </tr>
+<tr class="altColor">
+<td class="colFirst"><a href="#org.apache.poi.ss.usermodel.helpers">org.apache.poi.ss.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.xssf.usermodel.helpers">org.apache.poi.xssf.usermodel.helpers</a></td>
 <td class="colLast">&nbsp;</td>
@@ -161,6 +169,41 @@
 </tbody>
 </table>
 </li>
+<li class="blockList"><a name="org.apache.poi.hssf.usermodel.helpers">
+<!--   -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a> in <a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">HSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateConditionalFormatting(org.apache.poi.ss.formula.FormulaShifter)">updateConditionalFormatting</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>&nbsp;</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">HSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateFormulas(org.apache.poi.ss.formula.FormulaShifter)">updateFormulas</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>&nbsp;</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">HSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateHyperlinks(org.apache.poi.ss.formula.FormulaShifter)">updateHyperlinks</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>&nbsp;</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">HSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateNamedRanges(org.apache.poi.ss.formula.FormulaShifter)">updateNamedRanges</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>&nbsp;</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">HSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row,
+                 <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>&nbsp;</td>
+</tr>
+</tbody>
+</table>
+</li>
 <li class="blockList"><a name="org.apache.poi.ss.formula">
 <!--   -->
 </a>
@@ -210,6 +253,50 @@
 </tbody>
 </table>
 </li>
+<li class="blockList"><a name="org.apache.poi.ss.usermodel.helpers">
+<!--   -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a> in <a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>abstract void</code></td>
+<td class="colLast"><span class="strong">RowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateConditionalFormatting(org.apache.poi.ss.formula.FormulaShifter)">updateConditionalFormatting</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>&nbsp;</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>abstract void</code></td>
+<td class="colLast"><span class="strong">RowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateFormulas(org.apache.poi.ss.formula.FormulaShifter)">updateFormulas</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>
+<div class="block">Update formulas.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>abstract void</code></td>
+<td class="colLast"><span class="strong">RowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateHyperlinks(org.apache.poi.ss.formula.FormulaShifter)">updateHyperlinks</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>
+<div class="block">Shift the Hyperlink anchors (not the hyperlink text, even if the hyperlink
+ is of type LINK_DOCUMENT and refers to a cell that was shifted).</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>abstract void</code></td>
+<td class="colLast"><span class="strong">RowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateNamedRanges(org.apache.poi.ss.formula.FormulaShifter)">updateNamedRanges</a></strong>(<a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>
+<div class="block">Updated named ranges</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>abstract void</code></td>
+<td class="colLast"><span class="strong">RowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row,
+                 <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>
+<div class="block">Update the formulas in specified row using the formula shifting policy specified by shifter</div>
+</td>
+</tr>
+</tbody>
+</table>
+</li>
 <li class="blockList"><a name="org.apache.poi.xssf.usermodel.helpers">
 <!--   -->
 </a>
@@ -246,7 +333,7 @@
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>void</code></td>
-<td class="colLast"><span class="strong">XSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateRowFormulas(org.apache.poi.xssf.usermodel.XSSFRow,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas</a></strong>(<a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html" title="class in org.apache.poi.xssf.usermodel">XSSFRow</a>&nbsp;row,
+<td class="colLast"><span class="strong">XSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row,
                  <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>
 <div class="block">Update the formulas in specified row using the formula shifting policy specified by shifter</div>
 </td>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html Mon Jun 20 09:13:46 2016
@@ -102,33 +102,41 @@
 </td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><a href="#org.apache.poi.hssf.usermodel.helpers">org.apache.poi.hssf.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula">org.apache.poi.ss.formula</a></td>
 <td class="colLast">
 <div class="block">This package contains common internal POI code for manipulating formulas.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula.eval">org.apache.poi.ss.formula.eval</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula.eval.forked">org.apache.poi.ss.formula.eval.forked</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula.functions">org.apache.poi.ss.formula.functions</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula.ptg">org.apache.poi.ss.formula.ptg</a></td>
 <td class="colLast">
 <div class="block">formula package contains binary PTG structures used in Formulas</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.usermodel">org.apache.poi.ss.usermodel</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
+<tr class="altColor">
+<td class="colFirst"><a href="#org.apache.poi.ss.usermodel.helpers">org.apache.poi.ss.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
 <tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.xssf.streaming">org.apache.poi.xssf.streaming</a></td>
 <td class="colLast">&nbsp;</td>
@@ -306,6 +314,23 @@
 </tbody>
 </table>
 </li>
+<li class="blockList"><a name="org.apache.poi.hssf.usermodel.helpers">
+<!--   -->
+</a>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing classes, and an explanation">
+<caption><span>Classes in <a href="../../../../../org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a> used by <a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Class and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaShifter.html#org.apache.poi.hssf.usermodel.helpers">FormulaShifter</a>
+<div class="block">Updates Formulas as rows or sheets are shifted</div>
+</td>
+</tr>
+</tbody>
+</table>
+</li>
 <li class="blockList"><a name="org.apache.poi.ss.formula">
 <!--   -->
 </a>
@@ -537,6 +562,23 @@
 </td>
 </tr>
 </tbody>
+</table>
+</li>
+<li class="blockList"><a name="org.apache.poi.ss.usermodel.helpers">
+<!--   -->
+</a>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing classes, and an explanation">
+<caption><span>Classes in <a href="../../../../../org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a> used by <a href="../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Class and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/ss/formula/class-use/FormulaShifter.html#org.apache.poi.ss.usermodel.helpers">FormulaShifter</a>
+<div class="block">Updates Formulas as rows or sheets are shifted</div>
+</td>
+</tr>
+</tbody>
 </table>
 </li>
 <li class="blockList"><a name="org.apache.poi.xssf.streaming">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/IconMultiStateFormatting.IconSet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/IconMultiStateFormatting.IconSet.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/IconMultiStateFormatting.IconSet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/IconMultiStateFormatting.IconSet.html Mon Jun 20 09:13:46 2016
@@ -497,7 +497,7 @@ the order they are declared.</div>
 <ul class="blockList">
 <li class="blockList">
 <h4>id</h4>
-<pre>public&nbsp;int id</pre>
+<pre>public final&nbsp;int id</pre>
 <div class="block">Numeric ID of the icon set</div>
 </li>
 </ul>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html Mon Jun 20 09:13:46 2016
@@ -648,237 +648,243 @@ extends java.lang.Iterable&lt;<a href=".
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions</a></strong>(java.util.Collection&lt;java.lang.Integer&gt;&nbsp;indices)</code>
+<div class="block">Removes a number of merged regions of cells (hence letting them free)</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/Sheet.html#removeRow(org.apache.poi.ss.usermodel.Row)">removeRow</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row)</code>
 <div class="block">Remove a row from this sheet.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeRowBreak(int)">removeRowBreak</a></strong>(int&nbsp;row)</code>
 <div class="block">Removes the page break at the indicated row</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.util.Iterator&lt;<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#rowIterator()">rowIterator</a></strong>()</code>
 <div class="block">Returns an iterator of the physical rows</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setActiveCell(org.apache.poi.ss.util.CellAddress)">setActiveCell</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;address)</code>
 <div class="block">Sets location of the active cell</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a>&lt;? extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setArrayFormula(java.lang.String,%20org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a></strong>(java.lang.String&nbsp;formula,
                <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range)</code>
 <div class="block">Sets array formula to specified region for result.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutobreaks(boolean)">setAutobreaks</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Flag indicating whether the sheet displays Automatic Page Breaks.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/AutoFilter.html" title="interface in org.apache.poi.ss.usermodel">AutoFilter</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range)</code>
 <div class="block">Enable filtering for a range of cells</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnBreak(int)">setColumnBreak</a></strong>(int&nbsp;column)</code>
 <div class="block">Sets a page break at the indicated column.</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/ss/usermodel/Sheet.html#setColumnGroupCollapsed(int,%20boolean)">setColumnGroupCollapsed</a></strong>(int&nbsp;columnNumber,
                        boolean&nbsp;collapsed)</code>
 <div class="block">Expands or collapses a column group.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnHidden(int,%20boolean)">setColumnHidden</a></strong>(int&nbsp;columnIndex,
                boolean&nbsp;hidden)</code>
 <div class="block">Get the visibility state for a given column</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/ss/usermodel/Sheet.html#setColumnWidth(int,%20int)">setColumnWidth</a></strong>(int&nbsp;columnIndex,
               int&nbsp;width)</code>
 <div class="block">Set the width (in units of 1/256th of a character width)</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnStyle(int,%20org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a></strong>(int&nbsp;column,
                      <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;style)</code>
 <div class="block">Sets the default column style for a given column.</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/ss/usermodel/Sheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a></strong>(int&nbsp;width)</code>
 <div class="block">Set the default column width for the sheet (if the columns do not define their own width)
  in characters</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultRowHeight(short)">setDefaultRowHeight</a></strong>(short&nbsp;height)</code>
 <div class="block">Set the default row height for the sheet (if the rows do not define their own height) in
  twips (1/20 of  a point)</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/ss/usermodel/Sheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a></strong>(float&nbsp;height)</code>
 <div class="block">Set the default row height for the sheet (if the rows do not define their own height) in
  points</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets whether the formulas are shown in a viewer</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/ss/usermodel/Sheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets whether the gridlines are shown in a viewer</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGuts(boolean)">setDisplayGuts</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Set whether to display the guts or not</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/ss/usermodel/Sheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets whether the RowColHeadings are shown in a viewer</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayZeros(boolean)">setDisplayZeros</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Set whether the window should show 0 (zero) in cells containing zero value.</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/ss/usermodel/Sheet.html#setFitToPage(boolean)">setFitToPage</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Flag indicating whether the Fit to Page print option is enabled.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Control if Excel should be asked to recalculate all formulas on this sheet
  when the workbook is opened.</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/ss/usermodel/Sheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Determines whether the output is horizontally centered on the page.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setMargin(short,%20double)">setMargin</a></strong>(short&nbsp;margin,
          double&nbsp;size)</code>
 <div class="block">Sets the size of the margin in inches.</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/ss/usermodel/Sheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets the flag indicating whether this sheet should print the lines
  between rows and columns to make editing and reading easier.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setPrintRowAndColumnHeadings(boolean)">setPrintRowAndColumnHeadings</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets the flag indicating whether this sheet should print
  row and columns headings when printing.</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/ss/usermodel/Sheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;columnRangeRef)</code>
 <div class="block">Sets the repeating columns used when printing the sheet, as found in 
  File->PageSetup->Sheet.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;rowRangeRef)</code>
 <div class="block">Sets the repeating rows used when printing the sheet, as found in 
  File->PageSetup->Sheet.</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/ss/usermodel/Sheet.html#setRightToLeft(boolean)">setRightToLeft</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Sets whether the worksheet is displayed from right to left instead of from left to right.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowBreak(int)">setRowBreak</a></strong>(int&nbsp;row)</code>
 <div class="block">Sets a page break at the indicated row
  Breaks occur above the specified row and left of the specified column inclusive.</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/ss/usermodel/Sheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int&nbsp;row,
                     boolean&nbsp;collapse)</code>
 <div class="block">Set view state of a grouped range of rows</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.</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/ss/usermodel/Sheet.html#setRowSumsRight(boolean)">setRowSumsRight</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setSelected(boolean)">setSelected</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Sets a flag indicating whether this sheet is selected.</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/ss/usermodel/Sheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Determines whether the output is vertically centered on the page.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int)">setZoom</a></strong>(int&nbsp;scale)</code>
 <div class="block">Window zoom magnification for current view representing percent values.</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/ss/usermodel/Sheet.html#setZoom(int,%20int)">setZoom</a></strong>(int&nbsp;numerator,
        int&nbsp;denominator)</code>
@@ -887,7 +893,7 @@ extends java.lang.Iterable&lt;<a href=".
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int)">shiftRows</a></strong>(int&nbsp;startRow,
          int&nbsp;endRow,
@@ -895,7 +901,7 @@ extends java.lang.Iterable&lt;<a href=".
 <div class="block">Shifts rows between startRow and endRow n number of rows.</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/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a></strong>(int&nbsp;startRow,
          int&nbsp;endRow,
@@ -905,7 +911,7 @@ extends java.lang.Iterable&lt;<a href=".
 <div class="block">Shifts rows between startRow and endRow n number of rows.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#showInPane(int,%20int)">showInPane</a></strong>(int&nbsp;toprow,
           int&nbsp;leftcol)</code>
@@ -913,21 +919,21 @@ extends java.lang.Iterable&lt;<a href=".
  file is first opened in a viewer.</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/ss/usermodel/Sheet.html#ungroupColumn(int,%20int)">ungroupColumn</a></strong>(int&nbsp;fromColumn,
              int&nbsp;toColumn)</code>
 <div class="block">Ungroup a range of columns that were previously grouped</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ungroupRow(int,%20int)">ungroupRow</a></strong>(int&nbsp;fromRow,
           int&nbsp;toRow)</code>
 <div class="block">Ungroup a range of rows that were previously grouped</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/ss/usermodel/Sheet.html#validateMergedRegions()">validateMergedRegions</a></strong>()</code>
 <div class="block">Verify that merged regions do not intersect multi-cell array formulas and
@@ -1449,6 +1455,17 @@ extends java.lang.Iterable&lt;<a href=".
 <dl><dt><span class="strong">Parameters:</span></dt><dd><code>index</code> - of the region to unmerge</dd></dl>
 </li>
 </ul>
+<a name="removeMergedRegions(java.util.Collection)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>removeMergedRegions</h4>
+<pre>void&nbsp;removeMergedRegions(java.util.Collection&lt;java.lang.Integer&gt;&nbsp;indices)</pre>
+<div class="block">Removes a number of merged regions of cells (hence letting them free)</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>indices</code> - A set of the regions to unmerge</dd></dl>
+</li>
+</ul>
 <a name="getNumMergedRegions()">
 <!--   -->
 </a>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/package-summary.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/package-summary.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/package-summary.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/package-summary.html Mon Jun 20 09:13:46 2016
@@ -35,7 +35,7 @@
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">Prev Package</a></li>
-<li><a href="../../../../../../org/apache/poi/ss/util/package-summary.html">Next Package</a></li>
+<li><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">Next Package</a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../../index.html?org/apache/poi/ss/usermodel/charts/package-summary.html" target="_top">Frames</a></li>
@@ -264,7 +264,7 @@
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">Prev Package</a></li>
-<li><a href="../../../../../../org/apache/poi/ss/util/package-summary.html">Next Package</a></li>
+<li><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">Next Package</a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../../index.html?org/apache/poi/ss/usermodel/charts/package-summary.html" target="_top">Frames</a></li>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/package-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/package-tree.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/package-tree.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/charts/package-tree.html Mon Jun 20 09:13:46 2016
@@ -35,7 +35,7 @@
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../../org/apache/poi/ss/usermodel/package-tree.html">Prev</a></li>
-<li><a href="../../../../../../org/apache/poi/ss/util/package-tree.html">Next</a></li>
+<li><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-tree.html">Next</a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../../index.html?org/apache/poi/ss/usermodel/charts/package-tree.html" target="_top">Frames</a></li>
@@ -146,7 +146,7 @@
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../../org/apache/poi/ss/usermodel/package-tree.html">Prev</a></li>
-<li><a href="../../../../../../org/apache/poi/ss/util/package-tree.html">Next</a></li>
+<li><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-tree.html">Next</a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../../index.html?org/apache/poi/ss/usermodel/charts/package-tree.html" target="_top">Frames</a></li>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Row.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Row.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Row.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Row.html Mon Jun 20 09:13:46 2016
@@ -80,9 +80,17 @@
 </td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><a href="#org.apache.poi.hssf.usermodel.helpers">org.apache.poi.hssf.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.usermodel">org.apache.poi.ss.usermodel</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
+<tr class="rowColor">
+<td class="colFirst"><a href="#org.apache.poi.ss.usermodel.helpers">org.apache.poi.ss.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
 <tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.util">org.apache.poi.ss.util</a></td>
 <td class="colLast">&nbsp;</td>
@@ -95,6 +103,10 @@
 <td class="colFirst"><a href="#org.apache.poi.xssf.usermodel">org.apache.poi.xssf.usermodel</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
+<tr class="rowColor">
+<td class="colFirst"><a href="#org.apache.poi.xssf.usermodel.helpers">org.apache.poi.xssf.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
 </tbody>
 </table>
 </li>
@@ -155,6 +167,25 @@
 </tbody>
 </table>
 </li>
+<li class="blockList"><a name="org.apache.poi.hssf.usermodel.helpers">
+<!--   -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a> in <a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">HSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row,
+                 <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>&nbsp;</td>
+</tr>
+</tbody>
+</table>
+</li>
 <li class="blockList"><a name="org.apache.poi.ss.usermodel">
 <!--   -->
 </a>
@@ -217,6 +248,27 @@
 </tbody>
 </table>
 </li>
+<li class="blockList"><a name="org.apache.poi.ss.usermodel.helpers">
+<!--   -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a> in <a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>abstract void</code></td>
+<td class="colLast"><span class="strong">RowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row,
+                 <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>
+<div class="block">Update the formulas in specified row using the formula shifting policy specified by shifter</div>
+</td>
+</tr>
+</tbody>
+</table>
+</li>
 <li class="blockList"><a name="org.apache.poi.ss.util">
 <!--   -->
 </a>
@@ -424,6 +476,27 @@
 </td>
 </tr>
 </tbody>
+</table>
+</li>
+<li class="blockList"><a name="org.apache.poi.xssf.usermodel.helpers">
+<!--   -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a> in <a href="../../../../../../org/apache/poi/xssf/usermodel/helpers/package-summary.html">org.apache.poi.xssf.usermodel.helpers</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/xssf/usermodel/helpers/package-summary.html">org.apache.poi.xssf.usermodel.helpers</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">XSSFRowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row,
+                 <a href="../../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</a>&nbsp;shifter)</code>
+<div class="block">Update the formulas in specified row using the formula shifting policy specified by shifter</div>
+</td>
+</tr>
+</tbody>
 </table>
 </li>
 </ul>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html Mon Jun 20 09:13:46 2016
@@ -88,18 +88,22 @@
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
-<td class="colFirst"><a href="#org.apache.poi.ss.util">org.apache.poi.ss.util</a></td>
+<td class="colFirst"><a href="#org.apache.poi.ss.usermodel.helpers">org.apache.poi.ss.usermodel.helpers</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
-<td class="colFirst"><a href="#org.apache.poi.ss.util.cellwalk">org.apache.poi.ss.util.cellwalk</a></td>
+<td class="colFirst"><a href="#org.apache.poi.ss.util">org.apache.poi.ss.util</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
-<td class="colFirst"><a href="#org.apache.poi.xssf.streaming">org.apache.poi.xssf.streaming</a></td>
+<td class="colFirst"><a href="#org.apache.poi.ss.util.cellwalk">org.apache.poi.ss.util.cellwalk</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
+<td class="colFirst"><a href="#org.apache.poi.xssf.streaming">org.apache.poi.xssf.streaming</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
+<tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.xssf.usermodel">org.apache.poi.xssf.usermodel</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
@@ -281,6 +285,35 @@
 </tr>
 </tbody>
 </table>
+</li>
+<li class="blockList"><a name="org.apache.poi.ss.usermodel.helpers">
+<!--   -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a> in <a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing fields, and an explanation">
+<caption><span>Fields in <a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a> declared as <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Field and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>protected <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></td>
+<td class="colLast"><span class="strong">RowShifter.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#sheet">sheet</a></strong></code>&nbsp;</td>
+</tr>
+</tbody>
+</table>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing constructors, and an explanation">
+<caption><span>Constructors in <a href="../../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Constructor and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#RowShifter(org.apache.poi.ss.usermodel.Sheet)">RowShifter</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sh)</code>&nbsp;</td>
+</tr>
+</tbody>
+</table>
 </li>
 <li class="blockList"><a name="org.apache.poi.ss.util">
 <!--   -->

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-use.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-use.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-use.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-use.html Mon Jun 20 09:13:46 2016
@@ -110,40 +110,48 @@
 </td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><a href="#org.apache.poi.hssf.usermodel.helpers">org.apache.poi.hssf.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.hssf.util">org.apache.poi.hssf.util</a></td>
 <td class="colLast">
 <div class="block">util package contains tools needed for writing HSSF files that are not necesarily "real" 
 HSSF concepts.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.format">org.apache.poi.ss.format</a></td>
 <td class="colLast">
 <div class="block">This package contains classes that implement cell formatting</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula">org.apache.poi.ss.formula</a></td>
 <td class="colLast">
 <div class="block">This package contains common internal POI code for manipulating formulas.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula.eval.forked">org.apache.poi.ss.formula.eval.forked</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.formula.functions">org.apache.poi.ss.formula.functions</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.usermodel">org.apache.poi.ss.usermodel</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.usermodel.charts">org.apache.poi.ss.usermodel.charts</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
+<tr class="rowColor">
+<td class="colFirst"><a href="#org.apache.poi.ss.usermodel.helpers">org.apache.poi.ss.usermodel.helpers</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
 <tr class="altColor">
 <td class="colFirst"><a href="#org.apache.poi.ss.util">org.apache.poi.ss.util</a></td>
 <td class="colLast">&nbsp;</td>
@@ -544,6 +552,23 @@ HSSF concepts.</div>
 </tbody>
 </table>
 </li>
+<li class="blockList"><a name="org.apache.poi.hssf.usermodel.helpers">
+<!--   -->
+</a>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing classes, and an explanation">
+<caption><span>Classes in <a href="../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> used by <a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Class and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/ss/usermodel/class-use/Row.html#org.apache.poi.hssf.usermodel.helpers">Row</a>
+<div class="block">High level representation of a row of a spreadsheet.</div>
+</td>
+</tr>
+</tbody>
+</table>
+</li>
 <li class="blockList"><a name="org.apache.poi.hssf.util">
 <!--   -->
 </a>
@@ -980,6 +1005,28 @@ HSSF concepts.</div>
 </tbody>
 </table>
 </li>
+<li class="blockList"><a name="org.apache.poi.ss.usermodel.helpers">
+<!--   -->
+</a>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing classes, and an explanation">
+<caption><span>Classes in <a href="../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> used by <a href="../../../../../org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Class and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/ss/usermodel/class-use/Row.html#org.apache.poi.ss.usermodel.helpers">Row</a>
+<div class="block">High level representation of a row of a spreadsheet.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/ss/usermodel/class-use/Sheet.html#org.apache.poi.ss.usermodel.helpers">Sheet</a>
+<div class="block">High level representation of a Excel worksheet.</div>
+</td>
+</tr>
+</tbody>
+</table>
+</li>
 <li class="blockList"><a name="org.apache.poi.ss.util">
 <!--   -->
 </a>
@@ -1616,6 +1663,11 @@ HSSF concepts.</div>
 <div class="block">Types of ignored workbook and worksheet error.</div>
 </td>
 </tr>
+<tr class="altColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/ss/usermodel/class-use/Row.html#org.apache.poi.xssf.usermodel.helpers">Row</a>
+<div class="block">High level representation of a row of a spreadsheet.</div>
+</td>
+</tr>
 </tbody>
 </table>
 </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=1749281&r1=1749280&r2=1749281&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 Mon Jun 20 09:13:46 2016
@@ -204,7 +204,7 @@ extends <a href="../../../../../org/apac
 <!--   -->
 </a>
 <h3>Methods inherited from class&nbsp;org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></h3>
-<code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstColumn()">getFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstRow()">getFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastColumn()">getLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastRow()">getLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxColumn()">getMaxColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxRow()">getMaxRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinColumn()">getMinColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinRow()">getMinRow</a>, <a href="../../../../../org/apache/p
 oi/ss/util/CellRangeAddressBase.html#getNumberOfCells()">getNumberOfCells</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#intersects(org.apache.poi.ss.util.CellRangeAddressBase)">intersects</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullColumnRange()">isFullColumnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullRowRange()">isFullRowRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)">isInRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstColumn(int)">setFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstRow(int)">setFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastColumn(int)">setLastColumn</a>, 
 <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastRow(int)">setLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#toString()">toString</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#validate(org.apache.poi.ss.SpreadsheetVersion)">validate</a></code></li>
+<code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#containsColumn(int)">containsColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#containsRow(int)">containsRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstColumn()">getFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstRow()">getFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastColumn()">getLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastRow()">getLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxColumn()">getMaxColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxRow()">getMaxRow</a>, <a href="../../../../.
 ./org/apache/poi/ss/util/CellRangeAddressBase.html#getMinColumn()">getMinColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinRow()">getMinRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getNumberOfCells()">getNumberOfCells</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#intersects(org.apache.poi.ss.util.CellRangeAddressBase)">intersects</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullColumnRange()">isFullColumnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullRowRange()">isFullRowRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)">isInRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstColumn(int)">setFirstColumn</a>
 , <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstRow(int)">setFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastColumn(int)">setLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastRow(int)">setLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#toString()">toString</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#validate(org.apache.poi.ss.SpreadsheetVersion)">validate</a></code></li>
 </ul>
 <ul class="blockList">
 <li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddressBase.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddressBase.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddressBase.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddressBase.html Mon Jun 20 09:13:46 2016
@@ -102,7 +102,7 @@
 extends java.lang.Object</pre>
 <div class="block">See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'<p/>
 
- Common subclass of 8-bit and 16-bit versions</div>
+ Common superclass of 8-bit and 16-bit versions</div>
 </li>
 </ul>
 </div>
@@ -145,6 +145,18 @@ extends java.lang.Object</pre>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>boolean</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#containsColumn(int)">containsColumn</a></strong>(int&nbsp;colInd)</code>
+<div class="block">Check if the column is in the specified cell range</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>boolean</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#containsRow(int)">containsRow</a></strong>(int&nbsp;rowInd)</code>
+<div class="block">Check if the row is in the specified cell range</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a></strong>(java.lang.Object&nbsp;other)</code>&nbsp;</td>
 </tr>
 <tr class="rowColor">
@@ -359,7 +371,31 @@ extends java.lang.Object</pre>
 <div class="block">Determines if the given coordinates lie within the bounds 
  of this range.</div>
 <dl><dt><span class="strong">Parameters:</span></dt><dd><code>rowInd</code> - The row, 0-based.</dd><dd><code>colInd</code> - The column, 0-based.</dd>
-<dt><span class="strong">Returns:</span></dt><dd>True if the coordinates lie within the bounds, false otherwise.</dd></dl>
+<dt><span class="strong">Returns:</span></dt><dd>True if the coordinates lie within the bounds, false otherwise.</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#intersects(org.apache.poi.ss.util.CellRangeAddressBase)"><code>for checking if two ranges overlap</code></a></dd></dl>
+</li>
+</ul>
+<a name="containsRow(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>containsRow</h4>
+<pre>public&nbsp;boolean&nbsp;containsRow(int&nbsp;rowInd)</pre>
+<div class="block">Check if the row is in the specified cell range</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>rowInd</code> - the row to check</dd>
+<dt><span class="strong">Returns:</span></dt><dd>true if the range contains the row [rowInd]</dd></dl>
+</li>
+</ul>
+<a name="containsColumn(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>containsColumn</h4>
+<pre>public&nbsp;boolean&nbsp;containsColumn(int&nbsp;colInd)</pre>
+<div class="block">Check if the column is in the specified cell range</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>colInd</code> - the column to check</dd>
+<dt><span class="strong">Returns:</span></dt><dd>true if the range contains the column [colInd]</dd></dl>
 </li>
 </ul>
 <a name="intersects(org.apache.poi.ss.util.CellRangeAddressBase)">
@@ -371,7 +407,7 @@ extends java.lang.Object</pre>
 <pre>public&nbsp;boolean&nbsp;intersects(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a>&nbsp;other)</pre>
 <div class="block">Determines whether or not this CellRangeAddress and the specified CellRangeAddress intersect.</div>
 <dl><dt><span class="strong">Parameters:</span></dt><dd><code>other</code> - a candidate cell range address to check for intersection with this range</dd>
-<dt><span class="strong">Returns:</span></dt><dd>returns true if this range and other range have at least 1 cell in common</dd></dl>
+<dt><span class="strong">Returns:</span></dt><dd>returns true if this range and other range have at least 1 cell in common</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)"><code>for checking if a single cell intersects</code></a></dd></dl>
 </li>
 </ul>
 <a name="setFirstColumn(int)">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddressList.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddressList.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddressList.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/CellRangeAddressList.html Mon Jun 20 09:13:46 2016
@@ -35,7 +35,7 @@
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
-<li><a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../index.html?org/apache/poi/ss/util/CellRangeAddressList.html" target="_top">Frames</a></li>
@@ -448,7 +448,7 @@ extends java.lang.Object</pre>
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
-<li><a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../index.html?org/apache/poi/ss/util/CellRangeAddressList.html" target="_top">Frames</a></li>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/CellReference.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/CellReference.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/CellReference.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/CellReference.html Mon Jun 20 09:13:46 2016
@@ -34,7 +34,7 @@
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressList.html" title="class in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
 <li><a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
@@ -684,7 +684,7 @@ extends java.lang.Object</pre>
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressList.html" title="class in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
 <li><a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/SheetUtil.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/SheetUtil.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/SheetUtil.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/SheetUtil.html Mon Jun 20 09:13:46 2016
@@ -146,7 +146,9 @@ extends java.lang.Object</pre>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/SheetUtil.html#containsCell(org.apache.poi.ss.util.CellRangeAddress,%20int,%20int)">containsCell</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;cr,
             int&nbsp;rowIx,
             int&nbsp;colIx)</code>
-<div class="block">Check if the cell is in the specified cell range</div>
+<div class="block"><strong>Deprecated.</strong>&nbsp;
+<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)"><code>CellRangeAddressBase.isInRange(int, int)</code></a>.</i></div>
+</div>
 </td>
 </tr>
 <tr class="altColor">
@@ -314,6 +316,7 @@ public static&nbsp;int&nbsp;getDefaultCh
 <pre>public static&nbsp;boolean&nbsp;containsCell(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;cr,
                    int&nbsp;rowIx,
                    int&nbsp;colIx)</pre>
+<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)"><code>CellRangeAddressBase.isInRange(int, int)</code></a>.</i></div>
 <div class="block">Check if the cell is in the specified cell range</div>
 <dl><dt><span class="strong">Parameters:</span></dt><dd><code>cr</code> - the cell range to check in</dd><dd><code>rowIx</code> - the row to check</dd><dd><code>colIx</code> - the column to check</dd>
 <dt><span class="strong">Returns:</span></dt><dd>true if the range contains the cell [rowIx, colIx]</dd></dl>



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org