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 2017/06/28 23:22:39 UTC

svn commit: r1800210 [6/14] - in /poi/site/publish: ./ apidocs/ apidocs/org/apache/poi/hssf/usermodel/ apidocs/org/apache/poi/hssf/usermodel/class-use/ apidocs/org/apache/poi/hssf/util/ apidocs/org/apache/poi/poifs/crypt/dsig/facets/ apidocs/org/apache...

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ClientAnchor.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ClientAnchor.html?rev=1800210&r1=1800209&r2=1800210&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ClientAnchor.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ClientAnchor.html Wed Jun 28 23:22:37 2017
@@ -64,13 +64,13 @@
 <ul class="subNavList">
 <li>Summary:&nbsp;</li>
 <li><a href="#nested_class_summary">Nested</a>&nbsp;|&nbsp;</li>
-<li><a href="#field_summary">Field</a>&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
 <li>Constr&nbsp;|&nbsp;</li>
 <li><a href="#method_summary">Method</a></li>
 </ul>
 <ul class="subNavList">
 <li>Detail:&nbsp;</li>
-<li><a href="#field_detail">Field</a>&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
 <li>Constr&nbsp;|&nbsp;</li>
 <li><a href="#method_detail">Method</a></li>
 </ul>
@@ -130,45 +130,6 @@
 </table>
 </li>
 </ul>
-<!-- =========== FIELD SUMMARY =========== -->
-<ul class="blockList">
-<li class="blockList"><a name="field_summary">
-<!--   -->
-</a>
-<h3>Field Summary</h3>
-<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation">
-<caption><span>Fields</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>
-<tr class="altColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html" title="enum in org.apache.poi.ss.usermodel">ClientAnchor.AnchorType</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html#DONT_MOVE_AND_RESIZE">DONT_MOVE_AND_RESIZE</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>since POI 3.14beta1 (circa 2015-11-24). Use <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html#DONT_MOVE_AND_RESIZE"><code>ClientAnchor.AnchorType.DONT_MOVE_AND_RESIZE</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html" title="enum in org.apache.poi.ss.usermodel">ClientAnchor.AnchorType</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html#MOVE_AND_RESIZE">MOVE_AND_RESIZE</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>since POI 3.14beta1 (circa 2015-11-24). Use <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html#MOVE_AND_RESIZE"><code>ClientAnchor.AnchorType.MOVE_AND_RESIZE</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html" title="enum in org.apache.poi.ss.usermodel">ClientAnchor.AnchorType</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html#MOVE_DONT_RESIZE">MOVE_DONT_RESIZE</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>since POI 3.14beta1 (circa 2015-11-24). Use <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html#MOVE_DONT_RESIZE"><code>ClientAnchor.AnchorType.MOVE_DONT_RESIZE</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-</table>
-</li>
-</ul>
 <!-- ========== METHOD SUMMARY =========== -->
 <ul class="blockList">
 <li class="blockList"><a name="method_summary">
@@ -256,25 +217,17 @@
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html#setAnchorType(int)">setAnchorType</a></strong>(int&nbsp;anchorType)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15. Use <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html#setAnchorType(org.apache.poi.ss.usermodel.ClientAnchor.AnchorType)"><code>setAnchorType(AnchorType)</code></a> instead.</i></div>
-</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/ClientAnchor.html#setCol1(int)">setCol1</a></strong>(int&nbsp;col1)</code>
 <div class="block">Sets the column (0 based) of the first cell.</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/ClientAnchor.html#setCol2(int)">setCol2</a></strong>(int&nbsp;col2)</code>
 <div class="block">Returns the column (0 based) of the second cell.</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/ClientAnchor.html#setDx1(int)">setDx1</a></strong>(int&nbsp;dx1)</code>
 <div class="block">Sets the x coordinate within the first cell
@@ -284,7 +237,7 @@
   <a href="../../../../../org/apache/poi/util/Units.html#EMU_PER_PIXEL"><code>Units.EMU_PER_PIXEL</code></a></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/ClientAnchor.html#setDx2(int)">setDx2</a></strong>(int&nbsp;dx2)</code>
 <div class="block">Sets the x coordinate within the second cell
@@ -294,7 +247,7 @@
   <a href="../../../../../org/apache/poi/util/Units.html#EMU_PER_PIXEL"><code>Units.EMU_PER_PIXEL</code></a></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/ClientAnchor.html#setDy1(int)">setDy1</a></strong>(int&nbsp;dy1)</code>
 <div class="block">Sets the y coordinate within the first cell
@@ -304,7 +257,7 @@
   <a href="../../../../../org/apache/poi/util/Units.html#EMU_PER_PIXEL"><code>Units.EMU_PER_PIXEL</code></a></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/ClientAnchor.html#setDy2(int)">setDy2</a></strong>(int&nbsp;dy2)</code>
 <div class="block">Sets the y coordinate within the second cell
@@ -314,13 +267,13 @@
   <a href="../../../../../org/apache/poi/util/Units.html#EMU_PER_PIXEL"><code>Units.EMU_PER_PIXEL</code></a></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/ClientAnchor.html#setRow1(int)">setRow1</a></strong>(int&nbsp;row1)</code>
 <div class="block">Returns the row (0 based) of the first cell.</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/ClientAnchor.html#setRow2(int)">setRow2</a></strong>(int&nbsp;row2)</code>
 <div class="block">Returns the row (0 based) of the first cell.</div>
@@ -335,74 +288,6 @@
 <div class="details">
 <ul class="blockList">
 <li class="blockList">
-<!-- ============ FIELD DETAIL =========== -->
-<ul class="blockList">
-<li class="blockList"><a name="field_detail">
-<!--   -->
-</a>
-<h3>Field Detail</h3>
-<a name="MOVE_AND_RESIZE">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>MOVE_AND_RESIZE</h4>
-<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="3.17")
-static final&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html" title="enum in org.apache.poi.ss.usermodel">ClientAnchor.AnchorType</a> MOVE_AND_RESIZE</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>since POI 3.14beta1 (circa 2015-11-24). Use <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html#MOVE_AND_RESIZE"><code>ClientAnchor.AnchorType.MOVE_AND_RESIZE</code></a> instead.</i></div>
-<div class="block">Move and Resize With Anchor Cells
- <p>
- Specifies that the current drawing shall move and
- resize to maintain its row and column anchors (i.e. the
- object is anchored to the actual from and to row and column)
- </p></div>
-</li>
-</ul>
-<a name="MOVE_DONT_RESIZE">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>MOVE_DONT_RESIZE</h4>
-<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="3.17")
-static final&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html" title="enum in org.apache.poi.ss.usermodel">ClientAnchor.AnchorType</a> MOVE_DONT_RESIZE</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>since POI 3.14beta1 (circa 2015-11-24). Use <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html#MOVE_DONT_RESIZE"><code>ClientAnchor.AnchorType.MOVE_DONT_RESIZE</code></a> instead.</i></div>
-<div class="block">Move With Cells but Do Not Resize
- <p>
- Specifies that the current drawing shall move with its
- row and column (i.e. the object is anchored to the
- actual from row and column), but that the size shall remain absolute.
- </p>
- <p>
- If additional rows/columns are added between the from and to locations of the drawing,
- the drawing shall move its to anchors as needed to maintain this same absolute size.
- </p></div>
-</li>
-</ul>
-<a name="DONT_MOVE_AND_RESIZE">
-<!--   -->
-</a>
-<ul class="blockListLast">
-<li class="blockList">
-<h4>DONT_MOVE_AND_RESIZE</h4>
-<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="3.17")
-static final&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html" title="enum in org.apache.poi.ss.usermodel">ClientAnchor.AnchorType</a> DONT_MOVE_AND_RESIZE</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>since POI 3.14beta1 (circa 2015-11-24). Use <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.AnchorType.html#DONT_MOVE_AND_RESIZE"><code>ClientAnchor.AnchorType.DONT_MOVE_AND_RESIZE</code></a> instead.</i></div>
-<div class="block">Do Not Move or Resize With Underlying Rows/Columns
- <p>
- Specifies that the current start and end positions shall
- be maintained with respect to the distances from the
- absolute start point of the worksheet.
- </p>
- <p>
- If additional rows/columns are added before the
- drawing, the drawing shall move its anchors as needed
- to maintain this same absolute position.
- </p></div>
-</li>
-</ul>
-</li>
-</ul>
 <!-- ============ METHOD DETAIL ========== -->
 <ul class="blockList">
 <li class="blockList"><a name="method_detail">
@@ -417,7 +302,7 @@ static final&nbsp;<a href="../../../../.
 <h4>getCol1</h4>
 <pre>short&nbsp;getCol1()</pre>
 <div class="block">Returns the column (0 based) of the first cell, or -1 if there is no top-left anchor cell.
- This is the case for absolute positioning (AnchorType<a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html#DONT_MOVE_AND_RESIZE"><code>DONT_MOVE_AND_RESIZE</code></a>).</div>
+ This is the case for absolute positioning (AnchorType<code>#DONT_MOVE_AND_RESIZE</code>).</div>
 <dl><dt><span class="strong">Returns:</span></dt><dd>0-based column of the first cell or -1 if none.</dd></dl>
 </li>
 </ul>
@@ -635,19 +520,6 @@ static final&nbsp;<a href="../../../../.
   <dd>POI 3.14</dd></dl>
 </li>
 </ul>
-<a name="setAnchorType(int)">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>setAnchorType</h4>
-<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="3.17")
-void&nbsp;setAnchorType(int&nbsp;anchorType)</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15. Use <a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html#setAnchorType(org.apache.poi.ss.usermodel.ClientAnchor.AnchorType)"><code>setAnchorType(AnchorType)</code></a> instead.</i></div>
-<div class="block">Sets the anchor type</div>
-<dl><dt><span class="strong">Parameters:</span></dt><dd><code>anchorType</code> - the anchor type to set</dd></dl>
-</li>
-</ul>
 <a name="getAnchorType()">
 <!--   -->
 </a>
@@ -712,13 +584,13 @@ void&nbsp;setAnchorType(int&nbsp;anchorT
 <ul class="subNavList">
 <li>Summary:&nbsp;</li>
 <li><a href="#nested_class_summary">Nested</a>&nbsp;|&nbsp;</li>
-<li><a href="#field_summary">Field</a>&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
 <li>Constr&nbsp;|&nbsp;</li>
 <li><a href="#method_summary">Method</a></li>
 </ul>
 <ul class="subNavList">
 <li>Detail:&nbsp;</li>
-<li><a href="#field_detail">Field</a>&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
 <li>Constr&nbsp;|&nbsp;</li>
 <li><a href="#method_detail">Method</a></li>
 </ul>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CreationHelper.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CreationHelper.html?rev=1800210&r1=1800209&r2=1800210&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CreationHelper.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CreationHelper.html Wed Jun 28 23:22:37 2017
@@ -123,6 +123,19 @@
 <th class="colLast" scope="col">Method and Description</th>
 </tr>
 <tr class="altColor">
+<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html#createAreaReference(org.apache.poi.ss.util.CellReference,%20org.apache.poi.ss.util.CellReference)">createAreaReference</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a>&nbsp;topLeft,
+                   <a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a>&nbsp;bottomRight)</code>
+<div class="block">Creates an area ref from a pair of Cell References..</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html#createAreaReference(java.lang.String)">createAreaReference</a></strong>(java.lang.String&nbsp;reference)</code>
+<div class="block">Creates an AreaReference.</div>
+</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html" title="interface in org.apache.poi.ss.usermodel">ClientAnchor</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html#createClientAnchor()">createClientAnchor</a></strong>()</code>
 <div class="block">Creates a ClientAnchor.</div>
@@ -154,14 +167,6 @@
 </td>
 </tr>
 <tr class="rowColor">
-<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html#createHyperlink(int)">createHyperlink</a></strong>(int&nbsp;type)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html#createHyperlink(org.apache.poi.common.usermodel.HyperlinkType)"><code>createHyperlink(HyperlinkType)</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/RichTextString.html" title="interface in org.apache.poi.ss.usermodel">RichTextString</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html#createRichTextString(java.lang.String)">createRichTextString</a></strong>(java.lang.String&nbsp;text)</code>
 <div class="block">Creates a new RichTextString instance</div>
@@ -203,19 +208,6 @@
 <div class="block">Creates a new DataFormat instance</div>
 </li>
 </ul>
-<a name="createHyperlink(int)">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>createHyperlink</h4>
-<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="3.17")
-@Deprecated
-<a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a>&nbsp;createHyperlink(int&nbsp;type)</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html#createHyperlink(org.apache.poi.common.usermodel.HyperlinkType)"><code>createHyperlink(HyperlinkType)</code></a> instead.</i></div>
-<div class="block">Creates a new Hyperlink, of the given type</div>
-</li>
-</ul>
 <a name="createHyperlink(org.apache.poi.common.usermodel.HyperlinkType)">
 <!--   -->
 </a>
@@ -251,7 +243,7 @@
 <a name="createClientAnchor()">
 <!--   -->
 </a>
-<ul class="blockListLast">
+<ul class="blockList">
 <li class="blockList">
 <h4>createClientAnchor</h4>
 <pre><a href="../../../../../org/apache/poi/ss/usermodel/ClientAnchor.html" title="interface in org.apache.poi.ss.usermodel">ClientAnchor</a>&nbsp;createClientAnchor()</pre>
@@ -259,6 +251,31 @@
 <dl><dt><span class="strong">Returns:</span></dt><dd>a ClientAnchor instance</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Drawing.html" title="interface in org.apache.poi.ss.usermodel"><code>Drawing</code></a></dd></dl>
 </li>
 </ul>
+<a name="createAreaReference(java.lang.String)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>createAreaReference</h4>
+<pre><a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a>&nbsp;createAreaReference(java.lang.String&nbsp;reference)</pre>
+<div class="block">Creates an AreaReference.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>reference</code> - cell reference</dd>
+<dt><span class="strong">Returns:</span></dt><dd>an AreaReference instance</dd></dl>
+</li>
+</ul>
+<a name="createAreaReference(org.apache.poi.ss.util.CellReference, org.apache.poi.ss.util.CellReference)">
+<!--   -->
+</a>
+<ul class="blockListLast">
+<li class="blockList">
+<h4>createAreaReference</h4>
+<pre><a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a>&nbsp;createAreaReference(<a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a>&nbsp;topLeft,
+                                <a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a>&nbsp;bottomRight)</pre>
+<div class="block">Creates an area ref from a pair of Cell References..</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>topLeft</code> - cell reference</dd><dd><code>bottomRight</code> - cell reference</dd>
+<dt><span class="strong">Returns:</span></dt><dd>an AreaReference instance</dd></dl>
+</li>
+</ul>
 </li>
 </ul>
 </li>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Font.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Font.html?rev=1800210&r1=1800209&r2=1800210&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Font.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Font.html Wed Jun 28 23:22:37 2017
@@ -121,24 +121,6 @@
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#BOLDWEIGHT_BOLD">BOLDWEIGHT_BOLD</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Scheduled for removal in 3.17.
- Boldweight constants no longer needed due to <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getBold()"><code>getBold()</code></a> and <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBold(boolean)"><code>setBold(boolean)</code></a></i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#BOLDWEIGHT_NORMAL">BOLDWEIGHT_NORMAL</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Scheduled for removal in 3.17.
- Boldweight constants no longer needed due to <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getBold()"><code>getBold()</code></a> and <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBold(boolean)"><code>setBold(boolean)</code></a></i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#COLOR_NORMAL">COLOR_NORMAL</a></strong></code>
 <div class="block">normal type of black color.</div>
 </td>
@@ -229,84 +211,68 @@
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getBold()">getBold</a></strong>()</code>&nbsp;</td>
 </tr>
 <tr class="rowColor">
-<td class="colFirst"><code>short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getBoldweight()">getBoldweight</a></strong>()</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Scheduled for removal in 3.17. Use <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getBold()"><code>getBold()</code></a>.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getCharSet()">getCharSet</a></strong>()</code>
 <div class="block">get character-set to use.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getColor()">getColor</a></strong>()</code>
 <div class="block">get the color for the font</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getFontHeight()">getFontHeight</a></strong>()</code>
 <div class="block">Get the font height in unit's of 1/20th of a point.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getFontHeightInPoints()">getFontHeightInPoints</a></strong>()</code>
 <div class="block">Get the font height in points.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getFontName()">getFontName</a></strong>()</code>
 <div class="block">get the name for the font (i.e.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getIndex()">getIndex</a></strong>()</code>
 <div class="block">get the index within the XSSFWorkbook (sequence within the collection of Font objects)</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getItalic()">getItalic</a></strong>()</code>
 <div class="block">get whether to use italics or not</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/ss/usermodel/Font.html#getStrikeout()">getStrikeout</a></strong>()</code>
 <div class="block">get whether to use a strikeout horizontal line through the text or not</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getTypeOffset()">getTypeOffset</a></strong>()</code>
 <div class="block">get normal,super or subscript.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>byte</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getUnderline()">getUnderline</a></strong>()</code>
 <div class="block">get type of text underlining to use</div>
 </td>
 </tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBold(boolean)">setBold</a></strong>(boolean&nbsp;bold)</code>&nbsp;</td>
-</tr>
 <tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBoldweight(short)">setBoldweight</a></strong>(short&nbsp;boldweight)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Scheduled for removal in 3.17. Use <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBold(boolean)"><code>setBold(boolean)</code></a>.</i></div>
-</div>
-</td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBold(boolean)">setBold</a></strong>(boolean&nbsp;bold)</code>&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>void</code></td>
@@ -383,32 +349,6 @@
 <!--   -->
 </a>
 <h3>Field Detail</h3>
-<a name="BOLDWEIGHT_NORMAL">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BOLDWEIGHT_NORMAL</h4>
-<pre>static final&nbsp;short BOLDWEIGHT_NORMAL</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Scheduled for removal in 3.17.
- Boldweight constants no longer needed due to <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getBold()"><code>getBold()</code></a> and <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBold(boolean)"><code>setBold(boolean)</code></a></i></div>
-<div class="block">Normal boldness (not bold)</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.Font.BOLDWEIGHT_NORMAL">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BOLDWEIGHT_BOLD">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BOLDWEIGHT_BOLD</h4>
-<pre>static final&nbsp;short BOLDWEIGHT_BOLD</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Scheduled for removal in 3.17.
- Boldweight constants no longer needed due to <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getBold()"><code>getBold()</code></a> and <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBold(boolean)"><code>setBold(boolean)</code></a></i></div>
-<div class="block">Bold boldness (bold)</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.Font.BOLDWEIGHT_BOLD">Constant Field Values</a></dd></dl>
-</li>
-</ul>
 <a name="COLOR_NORMAL">
 <!--   -->
 </a>
@@ -810,16 +750,6 @@
   unless you're comparing which one is which)</dd></dl>
 </li>
 </ul>
-<a name="setBoldweight(short)">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>setBoldweight</h4>
-<pre>void&nbsp;setBoldweight(short&nbsp;boldweight)</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Scheduled for removal in 3.17. Use <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#setBold(boolean)"><code>setBold(boolean)</code></a>.</i></div>
-</li>
-</ul>
 <a name="setBold(boolean)">
 <!--   -->
 </a>
@@ -829,16 +759,6 @@
 <pre>void&nbsp;setBold(boolean&nbsp;bold)</pre>
 </li>
 </ul>
-<a name="getBoldweight()">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>getBoldweight</h4>
-<pre>short&nbsp;getBoldweight()</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Scheduled for removal in 3.17. Use <a href="../../../../../org/apache/poi/ss/usermodel/Font.html#getBold()"><code>getBold()</code></a>.</i></div>
-</li>
-</ul>
 <a name="getBold()">
 <!--   -->
 </a>

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=1800210&r1=1800209&r2=1800210&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 Wed Jun 28 23:22:37 2017
@@ -268,33 +268,24 @@ extends java.lang.Iterable&lt;<a href=".
 </td>
 </tr>
 <tr class="rowColor">
-<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Comment.html" title="interface in org.apache.poi.ss.usermodel">Comment</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(int,%20int)">getCellComment</a></strong>(int&nbsp;row,
-              int&nbsp;column)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>as of 2015-11-23 (circa POI 3.14beta1). Use <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(org.apache.poi.ss.util.CellAddress)"><code>getCellComment(CellAddress)</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
 <td class="colFirst"><code>java.util.Map&lt;<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>,? extends <a href="../../../../../org/apache/poi/ss/usermodel/Comment.html" title="interface in org.apache.poi.ss.usermodel">Comment</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComments()">getCellComments</a></strong>()</code>
 <div class="block">Returns all cell comments on this sheet.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int[]</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnBreaks()">getColumnBreaks</a></strong>()</code>
 <div class="block">Retrieves all the vertical page breaks</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnOutlineLevel(int)">getColumnOutlineLevel</a></strong>(int&nbsp;columnIndex)</code>
 <div class="block">Returns the column outline level.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnStyle(int)">getColumnStyle</a></strong>(int&nbsp;column)</code>
 <div class="block">Returns the CellStyle that applies to the given
@@ -302,607 +293,598 @@ extends java.lang.Iterable&lt;<a href=".
   set for that column</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidth(int)">getColumnWidth</a></strong>(int&nbsp;columnIndex)</code>
 <div class="block">get the width (in units of 1/256th of a character width )</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>float</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a></strong>(int&nbsp;columnIndex)</code>
 <div class="block">get the width in pixel</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationHelper.html" title="interface in org.apache.poi.ss.usermodel">DataValidationHelper</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidationHelper()">getDataValidationHelper</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>java.util.List&lt;? extends <a href="../../../../../org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel">DataValidation</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidations()">getDataValidations</a></strong>()</code>
 <div class="block">Returns the list of DataValidation in the sheet.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultColumnWidth()">getDefaultColumnWidth</a></strong>()</code>
 <div class="block">Get 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>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeight()">getDefaultRowHeight</a></strong>()</code>
 <div class="block">Get 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>float</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeightInPoints()">getDefaultRowHeightInPoints</a></strong>()</code>
 <div class="block">Get 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>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDisplayGuts()">getDisplayGuts</a></strong>()</code>
 <div class="block">Get whether to display the guts or not,
  default value is true</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Drawing.html" title="interface in org.apache.poi.ss.usermodel">Drawing</a>&lt;?&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDrawingPatriarch()">getDrawingPatriarch</a></strong>()</code>
 <div class="block">Return the sheet's existing drawing, or null if there isn't yet one.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFirstRowNum()">getFirstRowNum</a></strong>()</code>
 <div class="block">Gets the first row on the sheet</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFitToPage()">getFitToPage</a></strong>()</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><a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFooter()">getFooter</a></strong>()</code>
 <div class="block">Gets the user model for the default document footer.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></strong>()</code>
 <div class="block">Whether Excel will be asked to recalculate all formulas in this sheet when the
   workbook is opened.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHeader()">getHeader</a></strong>()</code>
 <div class="block">Gets the user model for the default document header.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHorizontallyCenter()">getHorizontallyCenter</a></strong>()</code>
 <div class="block">Determine whether printed output for this sheet will be horizontally centered.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlink(org.apache.poi.ss.util.CellAddress)">getHyperlink</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;addr)</code>
 <div class="block">Get a Hyperlink in this sheet located in a cell specified by {code addr}</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlink(int,%20int)">getHyperlink</a></strong>(int&nbsp;row,
             int&nbsp;column)</code>
 <div class="block">Get a Hyperlink in this sheet anchored at row, column</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>java.util.List&lt;? extends <a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlinkList()">getHyperlinkList</a></strong>()</code>
 <div class="block">Get a list of Hyperlinks in this sheet</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLastRowNum()">getLastRowNum</a></strong>()</code>
 <div class="block">Gets the last row on the sheet</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLeftCol()">getLeftCol</a></strong>()</code>
 <div class="block">The left col in the visible view when the sheet is
  first viewed after opening it in a viewer</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>double</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMargin(short)">getMargin</a></strong>(short&nbsp;margin)</code>
 <div class="block">Gets the size of the margin in inches.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegion(int)">getMergedRegion</a></strong>(int&nbsp;index)</code>
 <div class="block">Returns the merged region at the specified index</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.util.List&lt;<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegions()">getMergedRegions</a></strong>()</code>
 <div class="block">Returns the list of merged regions.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getNumMergedRegions()">getNumMergedRegions</a></strong>()</code>
 <div class="block">Returns the number of merged regions</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/PaneInformation.html" title="class in org.apache.poi.ss.util">PaneInformation</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPaneInformation()">getPaneInformation</a></strong>()</code>
 <div class="block">Returns the information regarding the currently configured pane (split or freeze)</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPhysicalNumberOfRows()">getPhysicalNumberOfRows</a></strong>()</code>
 <div class="block">Returns the number of physically defined rows (NOT the number of rows in the sheet)</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/PrintSetup.html" title="interface in org.apache.poi.ss.usermodel">PrintSetup</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPrintSetup()">getPrintSetup</a></strong>()</code>
 <div class="block">Gets the print setup object.</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/ss/usermodel/Sheet.html#getProtect()">getProtect</a></strong>()</code>
 <div class="block">Answer whether protection is enabled or disabled</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingColumns()">getRepeatingColumns</a></strong>()</code>
 <div class="block">Gets the repeating columns used when printing the sheet, as found in 
  File-&gt;PageSetup-&gt;Sheet.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingRows()">getRepeatingRows</a></strong>()</code>
 <div class="block">Gets the repeating rows used when printing the sheet, as found in 
  File-&gt;PageSetup-&gt;Sheet.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRow(int)">getRow</a></strong>(int&nbsp;rownum)</code>
 <div class="block">Returns the logical row (not physical) 0-based.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int[]</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowBreaks()">getRowBreaks</a></strong>()</code>
 <div class="block">Retrieves all the horizontal page breaks</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsBelow()">getRowSumsBelow</a></strong>()</code>
 <div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.</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/ss/usermodel/Sheet.html#getRowSumsRight()">getRowSumsRight</a></strong>()</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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getScenarioProtect()">getScenarioProtect</a></strong>()</code>
 <div class="block">Answer whether scenario protection is enabled or disabled</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/SheetConditionalFormatting.html" title="interface in org.apache.poi.ss.usermodel">SheetConditionalFormatting</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetConditionalFormatting()">getSheetConditionalFormatting</a></strong>()</code>
 <div class="block">The 'Conditional Formatting' facet for this <tt>Sheet</tt></div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetName()">getSheetName</a></strong>()</code>
 <div class="block">Returns the name of this sheet</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getTopRow()">getTopRow</a></strong>()</code>
 <div class="block">The top row in the visible view when the sheet is
  first viewed after opening it in a viewer</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getVerticallyCenter()">getVerticallyCenter</a></strong>()</code>
 <div class="block">Determine whether printed output for this sheet will be vertically centered.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getWorkbook()">getWorkbook</a></strong>()</code>
 <div class="block">Return the parent workbook</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#groupColumn(int,%20int)">groupColumn</a></strong>(int&nbsp;fromColumn,
            int&nbsp;toColumn)</code>
 <div class="block">Create an outline for the provided column range.</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#groupRow(int,%20int)">groupRow</a></strong>(int&nbsp;fromRow,
         int&nbsp;toRow)</code>
 <div class="block">Tie a range of rows together so that they can be collapsed or expanded</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnBroken(int)">isColumnBroken</a></strong>(int&nbsp;column)</code>
 <div class="block">Determines if there is a page break at the indicated column</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/ss/usermodel/Sheet.html#isColumnHidden(int)">isColumnHidden</a></strong>(int&nbsp;columnIndex)</code>
 <div class="block">Get the hidden state for a given column</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayFormulas()">isDisplayFormulas</a></strong>()</code>
 <div class="block">Returns if formulas are displayed</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/ss/usermodel/Sheet.html#isDisplayGridlines()">isDisplayGridlines</a></strong>()</code>
 <div class="block">Returns if gridlines are displayed</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a></strong>()</code>
 <div class="block">Returns if RowColHeadings are displayed.</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/ss/usermodel/Sheet.html#isDisplayZeros()">isDisplayZeros</a></strong>()</code>
 <div class="block">Gets the flag indicating 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>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isPrintGridlines()">isPrintGridlines</a></strong>()</code>
 <div class="block">Gets the flag indicating whether this sheet displays 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>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isPrintRowAndColumnHeadings()">isPrintRowAndColumnHeadings</a></strong>()</code>
 <div class="block">Gets the flag indicating whether this sheet prints the
  row and column headings when printing.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRightToLeft()">isRightToLeft</a></strong>()</code>
 <div class="block">Whether the text is displayed in right-to-left mode in the window</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/ss/usermodel/Sheet.html#isRowBroken(int)">isRowBroken</a></strong>(int&nbsp;row)</code>
 <div class="block">Determines if there is a page break at the indicated row</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isSelected()">isSelected</a></strong>()</code>
 <div class="block">Note - this is not the same as whether the sheet is focused (isActive)</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#protectSheet(java.lang.String)">protectSheet</a></strong>(java.lang.String&nbsp;password)</code>
 <div class="block">Sets the protection enabled as well as the password</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#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">removeArrayFormula</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>&nbsp;cell)</code>
 <div class="block">Remove a Array Formula 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#removeColumnBreak(int)">removeColumnBreak</a></strong>(int&nbsp;column)</code>
 <div class="block">Removes 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#removeMergedRegion(int)">removeMergedRegion</a></strong>(int&nbsp;index)</code>
 <div class="block">Removes a merged region of cells (hence letting them free)</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#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="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#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-&gt;PageSetup-&gt;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-&gt;PageSetup-&gt;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">
-<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>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>2015-11-23 (circa POI 3.14beta1). Use <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int)"><code>setZoom(int)</code></a> instead.</i></div>
-</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#shiftRows(int,%20int,%20int)">shiftRows</a></strong>(int&nbsp;startRow,
@@ -1875,23 +1857,6 @@ extends java.lang.Iterable&lt;<a href=".
 <dl><dt><span class="strong">Returns:</span></dt><dd>true =&gt; protection enabled; false =&gt; protection disabled</dd></dl>
 </li>
 </ul>
-<a name="setZoom(int, int)">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>setZoom</h4>
-<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="3.16")
-@Deprecated
-void&nbsp;setZoom(int&nbsp;numerator,
-                                     int&nbsp;denominator)</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>2015-11-23 (circa POI 3.14beta1). Use <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int)"><code>setZoom(int)</code></a> instead.</i></div>
-<div class="block">Sets the zoom magnication for the sheet.  The zoom is expressed as a
- fraction.  For example to express a zoom of 75% use 3 for the numerator
- and 4 for the denominator.</div>
-<dl><dt><span class="strong">Parameters:</span></dt><dd><code>numerator</code> - The numerator for the zoom magnification.</dd><dd><code>denominator</code> - The denominator for the zoom magnification.</dd></dl>
-</li>
-</ul>
 <a name="setZoom(int)">
 <!--   -->
 </a>
@@ -2349,20 +2314,6 @@ void&nbsp;setZoom(int&nbsp;numerator,
 <dl><dt><span class="strong">Parameters:</span></dt><dd><code>column</code> - the column index</dd><dd><code>useMergedCells</code> - whether to use the contents of merged cells when calculating the width of the column</dd></dl>
 </li>
 </ul>
-<a name="getCellComment(int, int)">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>getCellComment</h4>
-<pre>@Deprecated
-<a href="../../../../../org/apache/poi/ss/usermodel/Comment.html" title="interface in org.apache.poi.ss.usermodel">Comment</a>&nbsp;getCellComment(int&nbsp;row,
-                                int&nbsp;column)</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>as of 2015-11-23 (circa POI 3.14beta1). Use <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(org.apache.poi.ss.util.CellAddress)"><code>getCellComment(CellAddress)</code></a> instead.</i></div>
-<div class="block">Returns cell comment for the specified row and column</div>
-<dl><dt><span class="strong">Returns:</span></dt><dd>cell comment or <code>null</code> if not found</dd></dl>
-</li>
-</ul>
 <a name="getCellComment(org.apache.poi.ss.util.CellAddress)">
 <!--   -->
 </a>



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