Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html
URL: 
http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html?rev=1761703&r1=1761702&r2=1761703&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html 
(original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html Wed 
Sep 21 09:27:40 2016
@@ -327,7 +327,7 @@ implements <a href="../../../../../org/a
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createPivotTable(org.apache.poi.ss.util.AreaReference,%20org.apache.poi.ss.util.CellReference)">createPivotTable</a></strong>(<a
 href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class 
in org.apache.poi.ss.util">AreaReference</a>&nbsp;source,
                 <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position)</code>
-<div class="block">Create a pivot table and set area of source and a position 
for pivot table</div>
+<div class="block">Create a pivot table using the AreaReference range, at the 
given position.</div>
 </td>
 </tr>
 <tr class="rowColor">
@@ -335,10 +335,32 @@ implements <a href="../../../../../org/a
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createPivotTable(org.apache.poi.ss.util.AreaReference,%20org.apache.poi.ss.util.CellReference,%20org.apache.poi.ss.usermodel.Sheet)">createPivotTable</a></strong>(<a
 href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class 
in org.apache.poi.ss.util">AreaReference</a>&nbsp;source,
                 <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position,
                 <a 
href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface 
in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sourceSheet)</code>
-<div class="block">Create a pivot table and set area of source, source sheet 
and a position for pivot table</div>
+<div class="block">Create a pivot table using the AreaReference range on 
sourceSheet, at the given position.</div>
 </td>
 </tr>
 <tr class="altColor">
+<td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a></code></td>
+<td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createPivotTable(org.apache.poi.ss.usermodel.Name,%20org.apache.poi.ss.util.CellReference)">createPivotTable</a></strong>(<a
 href="../../../../../org/apache/poi/ss/usermodel/Name.html" title="interface 
in org.apache.poi.ss.usermodel">Name</a>&nbsp;source,
+                <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position)</code>
+<div class="block">Create a pivot table using the Name range, at the given 
position.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a></code></td>
+<td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createPivotTable(org.apache.poi.ss.usermodel.Name,%20org.apache.poi.ss.util.CellReference,%20org.apache.poi.ss.usermodel.Sheet)">createPivotTable</a></strong>(<a
 href="../../../../../org/apache/poi/ss/usermodel/Name.html" title="interface 
in org.apache.poi.ss.usermodel">Name</a>&nbsp;source,
+                <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position,
+                <a 
href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface 
in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sourceSheet)</code>
+<div class="block">Create a pivot table using the Name range reference on 
sourceSheet, at the given position.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a></code></td>
+<td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createPivotTable(org.apache.poi.ss.usermodel.Table,%20org.apache.poi.ss.util.CellReference)">createPivotTable</a></strong>(<a
 href="../../../../../org/apache/poi/ss/usermodel/Table.html" title="interface 
in org.apache.poi.ss.usermodel">Table</a>&nbsp;source,
+                <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position)</code>
+<div class="block">Create a pivot table using the Table, at the given 
position.</div>
+</td>
+</tr>
+<tr class="rowColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html" title="class 
in org.apache.poi.xssf.usermodel">XSSFRow</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createRow(int)">createRow</a></strong>(int&nbsp;rownum)</code>
 <div class="block">Create a new row within the sheet and return the high level 
representation
@@ -347,7 +369,7 @@ implements <a href="../../../../../org/a
       any existing cell is removed!</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/xssf/usermodel/XSSFSheet.html#createSplitPane(int,%20int,%20int,%20int,%20int)">createSplitPane</a></strong>(int&nbsp;xSplitPos,
                int&nbsp;ySplitPos,
@@ -357,47 +379,47 @@ implements <a href="../../../../../org/a
 <div class="block">Creates a split pane.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFTable.html" title="class 
in org.apache.poi.xssf.usermodel">XSSFTable</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createTable()">createTable</a></strong>()</code>
 <div class="block">Creates a new Table, and associates it with 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/xssf/usermodel/XSSFSheet.html#disableLocking()">disableLocking</a></strong>()</code>
 <div class="block">Disable sheet protection</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/xssf/usermodel/XSSFSheet.html#enableLocking()">enableLocking</a></strong>()</code>
 <div class="block">Enable sheet protection</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/xssf/usermodel/XSSFSheet.html#findEndOfRowOutlineGroup(int)">findEndOfRowOutlineGroup</a></strong>(int&nbsp;row)</code>&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in 
org.apache.poi.ss.util">CellAddress</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getActiveCell()">getActiveCell</a></strong>()</code>
 <div class="block">Return location of the active cell, e.g.</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/xssf/usermodel/XSSFSheet.html#getAutobreaks()">getAutobreaks</a></strong>()</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/xssf/usermodel/XSSFComment.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFComment</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCellComment(org.apache.poi.ss.util.CellAddress)">getCellComment</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">Return cell comment at row, column, if one exists.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFComment</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCellComment(int,%20int)">getCellComment</a></strong>(int&nbsp;row,
               int&nbsp;column)</code>
@@ -406,30 +428,30 @@ implements <a href="../../../../../org/a
 </div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <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>,<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFComment</a>&gt;</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.html#getColumnBreaks()">getColumnBreaks</a></strong>()</code>
 <div class="block">Vertical page break information used for print layout view, 
page layout view, drawing print breaks
  in normal view, and for printing the worksheet.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/helpers/ColumnHelper.html" 
title="class in 
org.apache.poi.xssf.usermodel.helpers">ColumnHelper</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getColumnHelper()">getColumnHelper</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#getColumnOutlineLevel(int)">getColumnOutlineLevel</a></strong>(int&nbsp;columnIndex)</code>
 <div class="block">Returns the column outline level.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <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/xssf/usermodel/XSSFSheet.html#getColumnStyle(int)">getColumnStyle</a></strong>(int&nbsp;column)</code>
 <div class="block">Returns the CellStyle that applies to the given
@@ -437,655 +459,655 @@ implements <a href="../../../../../org/a
   set for that column</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/xssf/usermodel/XSSFSheet.html#getColumnWidth(int)">getColumnWidth</a></strong>(int&nbsp;columnIndex)</code>
 <div class="block">Get the actual column width (in units of 1/256th of a 
character width )</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/xssf/usermodel/XSSFSheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a></strong>(int&nbsp;columnIndex)</code>
 <div class="block">Get the actual column width in pixels</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>protected <a 
href="../../../../../org/apache/poi/xssf/model/CommentsTable.html" title="class 
in org.apache.poi.xssf.model">CommentsTable</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCommentsTable(boolean)">getCommentsTable</a></strong>(boolean&nbsp;create)</code>
 <div class="block">Returns the sheet's comments object if there is one,
   or null if not</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>protected 
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDrawing</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCTDrawing()">getCTDrawing</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>protected 
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTLegacyDrawing</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCTLegacyDrawing()">getCTLegacyDrawing</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td 
class="colFirst"><code>org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCTWorksheet()">getCTWorksheet</a></strong>()</code>
 <div class="block">Provide access to the CTWorksheet bean holding this sheet's 
data</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <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/xssf/usermodel/XSSFSheet.html#getDataValidationHelper()">getDataValidationHelper</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.util.List&lt;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidation.html" 
title="class in 
org.apache.poi.xssf.usermodel">XSSFDataValidation</a>&gt;</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDataValidations()">getDataValidations</a></strong>()</code>
 <div class="block">Returns the list of DataValidation in the 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/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>float</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDefaultRowHeightInPoints()">getDefaultRowHeightInPoints</a></strong>()</code>
 <div class="block">Get the default row height for the sheet measued in point 
size (if the rows do not define their own height).</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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFDrawing.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFDrawing</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <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/xssf/usermodel/XSSFSheet.html#getEvenFooter()">getEvenFooter</a></strong>()</code>
 <div class="block">Returns the even footer.</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/xssf/usermodel/XSSFSheet.html#getEvenHeader()">getEvenHeader</a></strong>()</code>
 <div class="block">Returns the even header.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <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/xssf/usermodel/XSSFSheet.html#getFirstFooter()">getFirstFooter</a></strong>()</code>
 <div class="block">Returns the first page footer.</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/xssf/usermodel/XSSFSheet.html#getFirstHeader()">getFirstHeader</a></strong>()</code>
 <div class="block">Returns the first page header.</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/xssf/usermodel/XSSFSheet.html#getFirstRowNum()">getFirstRowNum</a></strong>()</code>
 <div class="block">Gets the first row on the sheet</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/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <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/xssf/usermodel/XSSFSheet.html#getFooter()">getFooter</a></strong>()</code>
 <div class="block">Returns the default footer for the sheet,
   creating one as needed.</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/xssf/usermodel/XSSFSheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></strong>()</code>
 <div class="block">Whether Excel will be asked to recalculate all formulas 
when the
   workbook is opened.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <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/xssf/usermodel/XSSFSheet.html#getHeader()">getHeader</a></strong>()</code>
 <div class="block">Returns the default header for the sheet,
   creating one as needed.</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/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.util.List&lt;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a>&gt;</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getHyperlinkList()">getHyperlinkList</a></strong>()</code>
 <div class="block">Get a list of Hyperlinks in this sheet</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>java.util.Map&lt;<a 
href="../../../../../org/apache/poi/ss/usermodel/IgnoredErrorType.html" 
title="enum in 
org.apache.poi.ss.usermodel">IgnoredErrorType</a>,java.util.Set&lt;<a 
href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class 
in org.apache.poi.ss.util">CellRangeAddress</a>&gt;&gt;</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getIgnoredErrors()">getIgnoredErrors</a></strong>()</code>
 <div class="block">Returns the errors currently being ignored and the ranges
  where they are ignored.</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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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>protected int</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getNumberOfComments()">getNumberOfComments</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#getNumHyperlinks()">getNumHyperlinks</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#getNumMergedRegions()">getNumMergedRegions</a></strong>()</code>
 <div class="block">Returns the number of merged regions defined in this 
worksheet</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <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/xssf/usermodel/XSSFSheet.html#getOddFooter()">getOddFooter</a></strong>()</code>
 <div class="block">Returns the odd footer.</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/xssf/usermodel/XSSFSheet.html#getOddHeader()">getOddHeader</a></strong>()</code>
 <div class="block">Returns the odd header.</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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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>java.util.List&lt;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in 
org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&gt;</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getPivotTables()">getPivotTables</a></strong>()</code>
 <div class="block">Returns all the pivot tables for this Sheet</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPrintSetup.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFPrintSetup</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getPrintSetup()">getPrintSetup</a></strong>()</code>
 <div class="block">Gets the print setup object.</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/xssf/usermodel/XSSFSheet.html#getProtect()">getProtect</a></strong>()</code>
 <div class="block">Answer whether protection is enabled or disabled</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/xssf/usermodel/XSSFSheet.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="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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html" title="class 
in org.apache.poi.xssf.usermodel">XSSFRow</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getRow(int)">getRow</a></strong>(int&nbsp;rownum)</code>
 <div class="block">Returns the logical row ( 0-based).</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/xssf/usermodel/XSSFSheet.html#getRowBreaks()">getRowBreaks</a></strong>()</code>
 <div class="block">Horizontal page break information used for print layout 
view, page layout view, drawing print breaks in normal
   view, and for printing the worksheet.</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/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getScenarioProtect()">getScenarioProtect</a></strong>()</code>
 <div class="block">A flag indicating whether scenarios are locked when the 
sheet is protected.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td 
class="colFirst"><code>org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellFormula</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getSharedFormula(int)">getSharedFormula</a></strong>(int&nbsp;sid)</code>
 <div class="block">Return a master shared formula by index</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheetConditionalFormatting.html"
 title="class in 
org.apache.poi.xssf.usermodel">XSSFSheetConditionalFormatting</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class 
in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getTabColor()">getTabColor</a></strong>()</code>
 <div class="block">Get background color of the sheet tab.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.util.List&lt;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFTable.html" title="class 
in org.apache.poi.xssf.usermodel">XSSFTable</a>&gt;</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getTables()">getTables</a></strong>()</code>
 <div class="block">Returns any tables associated with 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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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>protected <a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFVMLDrawing.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFVMLDrawing</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getVMLDrawing(boolean)">getVMLDrawing</a></strong>(boolean&nbsp;autoCreate)</code>
 <div class="block">Get VML drawing for this sheet (aka 'legacy' drawig)</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getWorkbook()">getWorkbook</a></strong>()</code>
 <div class="block">Returns the parent XSSFWorkbook</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/xssf/usermodel/XSSFSheet.html#groupColumn(int,%20int)">groupColumn</a></strong>(int&nbsp;fromColumn,
            int&nbsp;toColumn)</code>
 <div class="block">Group between (0 based) columns</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/xssf/usermodel/XSSFSheet.html#groupRow(int,%20int)">groupRow</a></strong>(int&nbsp;fromRow,
         int&nbsp;toRow)</code>
 <div class="block">Tie a range of cell together so that they can be collapsed 
or expanded</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/xssf/usermodel/XSSFSheet.html#hasComments()">hasComments</a></strong>()</code>
 <div class="block">Does this sheet have any comments on it? We need to know,
   so we can decide about writing it to disk or not</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/xssf/usermodel/XSSFSheet.html#isAutoFilterLocked()">isAutoFilterLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isDeleteColumnsLocked()">isDeleteColumnsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isDeleteRowsLocked()">isDeleteRowsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isDisplayFormulas()">isDisplayFormulas</a></strong>()</code>
 <div class="block">Gets the flag indicating whether this sheet should display 
formulas.</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/xssf/usermodel/XSSFSheet.html#isDisplayGridlines()">isDisplayGridlines</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/xssf/usermodel/XSSFSheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a></strong>()</code>
 <div class="block">Gets the flag indicating whether this sheet should display 
row and column headings.</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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isFormatCellsLocked()">isFormatCellsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isFormatColumnsLocked()">isFormatColumnsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isFormatRowsLocked()">isFormatRowsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isInsertColumnsLocked()">isInsertColumnsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isInsertHyperlinksLocked()">isInsertHyperlinksLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isInsertRowsLocked()">isInsertRowsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isObjectsLocked()">isObjectsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isPivotTablesLocked()">isPivotTablesLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isPrintGridlines()">isPrintGridlines</a></strong>()</code>
 <div class="block">Returns whether gridlines are printed.</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/xssf/usermodel/XSSFSheet.html#isPrintRowAndColumnHeadings()">isPrintRowAndColumnHeadings</a></strong>()</code>
 <div class="block">Returns whether row and column headings are printed.</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/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isRowBroken(int)">isRowBroken</a></strong>(int&nbsp;row)</code>
 <div class="block">Tests if there is a page break at the indicated row</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/xssf/usermodel/XSSFSheet.html#isScenariosLocked()">isScenariosLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isSelected()">isSelected</a></strong>()</code>
 <div class="block">Returns a flag indicating whether this sheet is 
selected.</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/xssf/usermodel/XSSFSheet.html#isSelectLockedCellsLocked()">isSelectLockedCellsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isSelectUnlockedCellsLocked()">isSelectUnlockedCellsLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isSheetLocked()">isSheetLocked</a></strong>()</code>&nbsp;</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/xssf/usermodel/XSSFSheet.html#isSortLocked()">isSortLocked</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <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/xssf/usermodel/XSSFSheet.html#iterator()">iterator</a></strong>()</code>
 <div class="block">Alias for <a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#rowIterator()"><code>rowIterator()</code></a>
 to
   allow foreach loops</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/xssf/usermodel/XSSFSheet.html#lockAutoFilter(boolean)">lockAutoFilter</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Autofilters locking.</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/xssf/usermodel/XSSFSheet.html#lockDeleteColumns(boolean)">lockDeleteColumns</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Deleting columns locking.</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/xssf/usermodel/XSSFSheet.html#lockDeleteRows(boolean)">lockDeleteRows</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Deleting rows locking.</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/xssf/usermodel/XSSFSheet.html#lockFormatCells(boolean)">lockFormatCells</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Formatting cells locking.</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/xssf/usermodel/XSSFSheet.html#lockFormatColumns(boolean)">lockFormatColumns</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Formatting columns locking.</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/xssf/usermodel/XSSFSheet.html#lockFormatRows(boolean)">lockFormatRows</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Formatting rows locking.</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/xssf/usermodel/XSSFSheet.html#lockInsertColumns(boolean)">lockInsertColumns</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Inserting columns locking.</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/xssf/usermodel/XSSFSheet.html#lockInsertHyperlinks(boolean)">lockInsertHyperlinks</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Inserting hyperlinks locking.</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/xssf/usermodel/XSSFSheet.html#lockInsertRows(boolean)">lockInsertRows</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Inserting rows locking.</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/xssf/usermodel/XSSFSheet.html#lockObjects(boolean)">lockObjects</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Objects locking.</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/xssf/usermodel/XSSFSheet.html#lockPivotTables(boolean)">lockPivotTables</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Pivot Tables locking.</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/xssf/usermodel/XSSFSheet.html#lockScenarios(boolean)">lockScenarios</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Scenarios locking.</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/xssf/usermodel/XSSFSheet.html#lockSelectLockedCells(boolean)">lockSelectLockedCells</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Selection of locked cells locking.</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/xssf/usermodel/XSSFSheet.html#lockSelectUnlockedCells(boolean)">lockSelectUnlockedCells</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Selection of unlocked cells locking.</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/xssf/usermodel/XSSFSheet.html#lockSort(boolean)">lockSort</a></strong>(boolean&nbsp;enabled)</code>
 <div class="block">Enable or disable Sort locking.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>protected void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#onDocumentCreate()">onDocumentCreate</a></strong>()</code>
 <div class="block">Initialize worksheet data when creating a new sheet.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>protected void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#onDocumentRead()">onDocumentRead</a></strong>()</code>
 <div class="block">Initialize worksheet data when reading in an exisiting 
file.</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/xssf/usermodel/XSSFSheet.html#protectSheet(java.lang.String)">protectSheet</a></strong>(java.lang.String&nbsp;password)</code>
 <div class="block">Enables sheet protection and sets the password for the 
sheet.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>protected void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#read(java.io.InputStream)">read</a></strong>(java.io.InputStream&nbsp;is)</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" 
title="interface in org.apache.poi.ss.usermodel">CellRange</a>&lt;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class 
in org.apache.poi.xssf.usermodel">XSSFCell</a>&gt;</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeHyperlink(int,%20int)">removeHyperlink</a></strong>(int&nbsp;row,
                int&nbsp;column)</code>
 <div class="block">Removes a hyperlink in the collection of hyperlinks on this 
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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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)
@@ -1095,31 +1117,31 @@ implements <a href="../../../../../org/a
  merged region.</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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setActiveCell(java.lang.String)">setActiveCell</a></strong>(java.lang.String&nbsp;cellRef)</code>
 <div class="block"><strong>Deprecated.</strong>&nbsp;
@@ -1127,175 +1149,175 @@ implements <a href="../../../../../org/a
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" 
title="interface in org.apache.poi.ss.usermodel">CellRange</a>&lt;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class 
in org.apache.poi.xssf.usermodel">XSSFCell</a>&gt;</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFAutoFilter.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFAutoFilter</a></code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a></strong>(int&nbsp;width)</code>
 <div class="block">Specifies the number of characters of the maximum digit 
width of the normal style's font.</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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a></strong>(float&nbsp;height)</code>
 <div class="block">Sets default row height measured in point size.</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/xssf/usermodel/XSSFSheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets the flag indicating whether this sheet should display 
formulas.</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/xssf/usermodel/XSSFSheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets the flag indicating whether this sheet should display 
the lines
  between rows and columns to make editing and reading easier.</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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets the flag indicating whether this sheet should display 
row and column headings.</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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setFitToPage(boolean)">setFitToPage</a></strong>(boolean&nbsp;b)</code>
 <div class="block">Flag indicating whether the Fit to Page print option is 
enabled.</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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Center on page horizontally 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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Turns on or off the printing of gridlines.</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/xssf/usermodel/XSSFSheet.html#setPrintRowAndColumnHeadings(boolean)">setPrintRowAndColumnHeadings</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Turns on or off the printing of row and column 
headings.</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/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int&nbsp;rowIndex,
                     boolean&nbsp;collapse)</code>
@@ -1303,32 +1325,32 @@ implements <a href="../../../../../org/a
  the rows in question hidden.</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/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setSheetPassword(java.lang.String,%20org.apache.poi.poifs.crypt.HashAlgorithm)">setSheetPassword</a></strong>(java.lang.String&nbsp;password,
                 <a 
href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum 
in org.apache.poi.poifs.crypt">HashAlgorithm</a>&nbsp;hashAlgo)</code>
 <div class="block">Sets the sheet password.</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/xssf/usermodel/XSSFSheet.html#setTabColor(int)">setTabColor</a></strong>(int&nbsp;colorIndex)</code>
 <div class="block"><strong>Deprecated.</strong>&nbsp;
@@ -1336,25 +1358,25 @@ implements <a href="../../../../../org/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/xssf/usermodel/XSSFSheet.html#setTabColor(org.apache.poi.xssf.usermodel.XSSFColor)">setTabColor</a></strong>(<a
 href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" 
title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
 <div class="block">Set background color of the sheet tab</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/xssf/usermodel/XSSFSheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a></strong>(boolean&nbsp;value)</code>
 <div class="block">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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.html#setZoom(int,%20int)">setZoom</a></strong>(int&nbsp;numerator,
        int&nbsp;denominator)</code>
@@ -1363,7 +1385,7 @@ implements <a href="../../../../../org/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/xssf/usermodel/XSSFSheet.html#shiftRows(int,%20int,%20int)">shiftRows</a></strong>(int&nbsp;startRow,
          int&nbsp;endRow,
@@ -1371,7 +1393,7 @@ implements <a href="../../../../../org/a
 <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/xssf/usermodel/XSSFSheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a></strong>(int&nbsp;startRow,
          int&nbsp;endRow,
@@ -1381,7 +1403,7 @@ implements <a href="../../../../../org/a
 <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/xssf/usermodel/XSSFSheet.html#showInPane(int,%20int)">showInPane</a></strong>(int&nbsp;toprow,
           int&nbsp;leftcol)</code>
@@ -1389,35 +1411,35 @@ implements <a href="../../../../../org/a
  pane (when in Left-to-Right mode).</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/xssf/usermodel/XSSFSheet.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/xssf/usermodel/XSSFSheet.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 groupped</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/xssf/usermodel/XSSFSheet.html#validateMergedRegions()">validateMergedRegions</a></strong>()</code>
 <div class="block">Verify that merged regions do not intersect multi-cell 
array formulas and
  no merged regions intersect another merged region in this sheet.</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/xssf/usermodel/XSSFSheet.html#validateSheetPassword(java.lang.String)">validateSheetPassword</a></strong>(java.lang.String&nbsp;password)</code>
 <div class="block">Validate the password against the stored hash, the hashing 
method will be determined
   by the existing password attributes</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>protected void</code></td>
 <td class="colLast"><code><strong><a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#write(java.io.OutputStream)">write</a></strong>(java.io.OutputStream&nbsp;out)</code>&nbsp;</td>
 </tr>
@@ -4383,9 +4405,12 @@ public&nbsp;org.openxmlformats.schemas.s
 public&nbsp;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in 
org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&nbsp;createPivotTable(<a 
href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in 
org.apache.poi.ss.util">AreaReference</a>&nbsp;source,
                                    <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position,
                                    <a 
href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface 
in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sourceSheet)</pre>
-<div class="block">Create a pivot table and set area of source, source sheet 
and a position for pivot table</div>
-<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - 
Area from where data will be collected</dd><dd><code>position</code> - A 
reference to the cell where the table will 
start</dd><dd><code>sourceSheet</code> - The sheet where source will be 
collected from</dd>
-<dt><span class="strong">Returns:</span></dt><dd>The pivot table</dd></dl>
+<div class="block">Create a pivot table using the AreaReference range on 
sourceSheet, at the given position.
+ If the source reference contains a sheet name, it must match the 
sourceSheet</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - 
location of pivot data</dd><dd><code>position</code> - A reference to the top 
left cell where the pivot table will start</dd><dd><code>sourceSheet</code> - 
The sheet containing the source data, if the source reference doesn't contain a 
sheet name</dd>
+<dt><span class="strong">Returns:</span></dt><dd>The pivot table</dd>
+<dt><span class="strong">Throws:</span></dt>
+<dd><code>java.lang.IllegalArgumentException</code> - if source references a 
sheet different than sourceSheet</dd></dl>
 </li>
 </ul>
 <a name="createPivotTable(org.apache.poi.ss.util.AreaReference, 
org.apache.poi.ss.util.CellReference)">
@@ -4397,8 +4422,57 @@ public&nbsp;<a href="../../../../../org/
 <pre><a href="../../../../../org/apache/poi/util/Beta.html" title="annotation 
in org.apache.poi.util">@Beta</a>
 public&nbsp;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in 
org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&nbsp;createPivotTable(<a 
href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in 
org.apache.poi.ss.util">AreaReference</a>&nbsp;source,
                                    <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position)</pre>
-<div class="block">Create a pivot table and set area of source and a position 
for pivot table</div>
-<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - 
Area from where data will be collected</dd><dd><code>position</code> - A 
reference to the cell where the table will start</dd>
+<div class="block">Create a pivot table using the AreaReference range, at the 
given position.
+ If the source reference contains a sheet name, that sheet is used, otherwise 
this sheet is assumed as the source sheet.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - 
location of pivot data</dd><dd><code>position</code> - A reference to the top 
left cell where the pivot table will start</dd>
+<dt><span class="strong">Returns:</span></dt><dd>The pivot table</dd></dl>
+</li>
+</ul>
+<a name="createPivotTable(org.apache.poi.ss.usermodel.Name, 
org.apache.poi.ss.util.CellReference, org.apache.poi.ss.usermodel.Sheet)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>createPivotTable</h4>
+<pre><a href="../../../../../org/apache/poi/util/Beta.html" title="annotation 
in org.apache.poi.util">@Beta</a>
+public&nbsp;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in 
org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&nbsp;createPivotTable(<a 
href="../../../../../org/apache/poi/ss/usermodel/Name.html" title="interface in 
org.apache.poi.ss.usermodel">Name</a>&nbsp;source,
+                                   <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position,
+                                   <a 
href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface 
in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sourceSheet)</pre>
+<div class="block">Create a pivot table using the Name range reference on 
sourceSheet, at the given position.
+ If the source reference contains a sheet name, it must match the 
sourceSheet</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - 
location of pivot data</dd><dd><code>position</code> - A reference to the top 
left cell where the pivot table will start</dd><dd><code>sourceSheet</code> - 
The sheet containing the source data, if the source reference doesn't contain a 
sheet name</dd>
+<dt><span class="strong">Returns:</span></dt><dd>The pivot table</dd>
+<dt><span class="strong">Throws:</span></dt>
+<dd><code>java.lang.IllegalArgumentException</code> - if source references a 
sheet different than sourceSheet</dd></dl>
+</li>
+</ul>
+<a name="createPivotTable(org.apache.poi.ss.usermodel.Name, 
org.apache.poi.ss.util.CellReference)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>createPivotTable</h4>
+<pre><a href="../../../../../org/apache/poi/util/Beta.html" title="annotation 
in org.apache.poi.util">@Beta</a>
+public&nbsp;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in 
org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&nbsp;createPivotTable(<a 
href="../../../../../org/apache/poi/ss/usermodel/Name.html" title="interface in 
org.apache.poi.ss.usermodel">Name</a>&nbsp;source,
+                                   <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position)</pre>
+<div class="block">Create a pivot table using the Name range, at the given 
position.
+ If the source reference contains a sheet name, that sheet is used, otherwise 
this sheet is assumed as the source sheet.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - 
location of pivot data</dd><dd><code>position</code> - A reference to the top 
left cell where the pivot table will start</dd>
+<dt><span class="strong">Returns:</span></dt><dd>The pivot table</dd></dl>
+</li>
+</ul>
+<a name="createPivotTable(org.apache.poi.ss.usermodel.Table, 
org.apache.poi.ss.util.CellReference)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>createPivotTable</h4>
+<pre><a href="../../../../../org/apache/poi/util/Beta.html" title="annotation 
in org.apache.poi.util">@Beta</a>
+public&nbsp;<a 
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" 
title="class in 
org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&nbsp;createPivotTable(<a 
href="../../../../../org/apache/poi/ss/usermodel/Table.html" title="interface 
in org.apache.poi.ss.usermodel">Table</a>&nbsp;source,
+                                   <a 
href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in 
org.apache.poi.ss.util">CellReference</a>&nbsp;position)</pre>
+<div class="block">Create a pivot table using the Table, at the given position.
+ Tables are required to have a sheet reference, so no additional logic around 
reference sheet is needed.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - 
location of pivot data</dd><dd><code>position</code> - A reference to the top 
left cell where the pivot table will start</dd>
 <dt><span class="strong">Returns:</span></dt><dd>The pivot table</dd></dl>
 </li>
 </ul>



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

Reply via email to