Author: nick
Date: Fri Apr 1 07:11:25 2016
New Revision: 1737315
URL: http://svn.apache.org/viewvc?rev=1737315&view=rev
Log:
Republish site
Modified:
poi/site/publish/apidocs/index-all.html
poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/class-use/HashAlgorithm.html
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/SignatureInfo.html
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/services/TSPTimeStampService.html
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html
poi/site/publish/changes.html
poi/site/publish/changes.rss
Modified: poi/site/publish/apidocs/index-all.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/apidocs/index-all.html?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
--- poi/site/publish/apidocs/index-all.html (original)
+++ poi/site/publish/apidocs/index-all.html Fri Apr 1 07:11:25 2016
@@ -5640,6 +5640,10 @@
<dd>
<div class="block">Create an XSSFSheet from an existing sheet in the
XSSFWorkbook.</div>
</dd>
+<dt><span class="strong"><a
href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html#cloneSheet(int,%20java.lang.String)">cloneSheet(int,
String)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a
href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in
org.apache.poi.xssf.usermodel">XSSFWorkbook</a></dt>
+<dd>
+<div class="block">Create an XSSFSheet from an existing sheet in the
XSSFWorkbook.</div>
+</dd>
<dt><span class="strong"><a
href="./org/apache/poi/hssf/record/ExtendedFormatRecord.html#cloneStyleFrom(org.apache.poi.hssf.record.ExtendedFormatRecord)">cloneStyleFrom(ExtendedFormatRecord)</a></span>
- Method in class org.apache.poi.hssf.record.<a
href="./org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in
org.apache.poi.hssf.record">ExtendedFormatRecord</a></dt>
<dd>
<div class="block">Clones all the style information from another
Modified:
poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
(original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
Fri Apr 1 07:11:25 2016
@@ -1180,11 +1180,12 @@ public short getSelectedTab()<
<h4>setFirstVisibleTab</h4>
<pre>public void setFirstVisibleTab(int index)</pre>
<div class="block">sets the first tab that is displayed in the list of tabs
- in excel.</div>
+ in excel. This method does <b>not</b> hide, select or focus sheets.
+ It just sets the scroll position in the tab-bar.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a
href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#setFirstVisibleTab(int)">setFirstVisibleTab</a></code> in
interface <code><a
href="../../../../../org/apache/poi/ss/usermodel/Workbook.html"
title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></dd>
-<dt><span class="strong">Parameters:</span></dt><dd><code>index</code> -
</dd></dl>
+<dt><span class="strong">Parameters:</span></dt><dd><code>index</code> - the
sheet index of the tab that will become the first in the tab-bar</dd></dl>
</li>
</ul>
<a name="setDisplayedTab(short)">
Modified:
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/class-use/HashAlgorithm.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/poifs/crypt/class-use/HashAlgorithm.html?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
---
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/class-use/HashAlgorithm.html
(original)
+++
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/class-use/HashAlgorithm.html
Fri Apr 1 07:11:25 2016
@@ -530,7 +530,7 @@ the order they are declared.</div>
</tr>
<tbody>
<tr class="altColor">
-<td
class="colFirst"><code>org.bouncycastle.asn1.ASN1ObjectIdentifier</code></td>
+<td class="colFirst"><code>ASN1ObjectIdentifier</code></td>
<td class="colLast"><span
class="strong">TSPTimeStampService.</span><code><strong><a
href="../../../../../../org/apache/poi/poifs/crypt/dsig/services/TSPTimeStampService.html#mapDigestAlgoToOID(org.apache.poi.poifs.crypt.HashAlgorithm)">mapDigestAlgoToOID</a></strong>(<a
href="../../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html"
title="enum in
org.apache.poi.poifs.crypt">HashAlgorithm</a> digestAlgo)</code>
<div class="block">Maps the digest algorithm to corresponding OID value.</div>
</td>
Modified:
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/SignatureInfo.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/SignatureInfo.html?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/SignatureInfo.html
(original)
+++ poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/SignatureInfo.html
Fri Apr 1 07:11:25 2016
@@ -162,7 +162,7 @@ implements <a href="../../../../../../or
<p>To use SignatureInfo and its sibling classes, you'll need to have the
following libs
in the classpath:</p>
<ul>
- <li>BouncyCastle bcpkix and bcprov (tested against 1.53)</li>
+ <li>BouncyCastle bcpkix and bcprov (tested against 1.54)</li>
<li>Apache Santuario "xmlsec" (tested against 2.0.5)</li>
<li>and slf4j-api (tested against 1.7.12)</li>
</ul></div>
Modified:
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/services/TSPTimeStampService.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/services/TSPTimeStampService.html?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
---
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/services/TSPTimeStampService.html
(original)
+++
poi/site/publish/apidocs/org/apache/poi/poifs/crypt/dsig/services/TSPTimeStampService.html
Fri Apr 1 07:11:25 2016
@@ -140,7 +140,7 @@ implements <a href="../../../../../../..
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tr class="altColor">
-<td
class="colFirst"><code>org.bouncycastle.asn1.ASN1ObjectIdentifier</code></td>
+<td class="colFirst"><code>ASN1ObjectIdentifier</code></td>
<td class="colLast"><code><strong><a
href="../../../../../../../org/apache/poi/poifs/crypt/dsig/services/TSPTimeStampService.html#mapDigestAlgoToOID(org.apache.poi.poifs.crypt.HashAlgorithm)">mapDigestAlgoToOID</a></strong>(<a
href="../../../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html"
title="enum in
org.apache.poi.poifs.crypt">HashAlgorithm</a> digestAlgo)</code>
<div class="block">Maps the digest algorithm to corresponding OID value.</div>
</td>
@@ -202,7 +202,7 @@ implements <a href="../../../../../../..
<ul class="blockList">
<li class="blockList">
<h4>mapDigestAlgoToOID</h4>
-<pre>public org.bouncycastle.asn1.ASN1ObjectIdentifier mapDigestAlgoToOID(<a
href="../../../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html"
title="enum in
org.apache.poi.poifs.crypt">HashAlgorithm</a> digestAlgo)</pre>
+<pre>public ASN1ObjectIdentifier mapDigestAlgoToOID(<a
href="../../../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html"
title="enum in
org.apache.poi.poifs.crypt">HashAlgorithm</a> digestAlgo)</pre>
<div class="block">Maps the digest algorithm to corresponding OID value.</div>
</li>
</ul>
Modified:
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html
(original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html
Fri Apr 1 07:11:25 2016
@@ -287,54 +287,61 @@ implements <a href="../../../../../org/a
</td>
</tr>
<tr class="altColor">
+<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class
in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
+<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#cloneSheet(int,%20java.lang.String)">cloneSheet</a></strong>(int sheetNum,
+ java.lang.String newName)</code>
+<div class="block">Create an XSSFSheet from an existing sheet in the
XSSFWorkbook.</div>
+</td>
+</tr>
+<tr class="rowColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#commit()">commit</a></strong>()</code>
<div class="block">Save the content in the underlying package part.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html"
title="class in org.apache.poi.xssf.usermodel">XSSFCellStyle</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createCellStyle()">createCellStyle</a></strong>()</code>
<div class="block">Create a new XSSFCellStyle and add it to the workbook's
style table</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataFormat.html"
title="class in org.apache.poi.xssf.usermodel">XSSFDataFormat</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createDataFormat()">createDataFormat</a></strong>()</code>
<div class="block">Returns the workbook's data format table (a factory for
creating data format strings).</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>protected <a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFDialogsheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFDialogsheet</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createDialogsheet(java.lang.String,%20org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet)">createDialogsheet</a></strong>(java.lang.String sheetname,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet dialogsheet)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class
in org.apache.poi.xssf.usermodel">XSSFFont</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createFont()">createFont</a></strong>()</code>
<div class="block">Create a new Font and add it to the workbook's font
table</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class
in org.apache.poi.xssf.usermodel">XSSFName</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createName()">createName</a></strong>()</code>
<div class="block">Creates a new (uninitialised) defined name in this
workbook</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class
in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createSheet()">createSheet</a></strong>()</code>
<div class="block">Create an XSSFSheet for this workbook, adds it to the
sheets and returns
the high level representation.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class
in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createSheet(java.lang.String)">createSheet</a></strong>(java.lang.String sheetname)</code>
<div class="block">Create a new sheet for this Workbook and return the high
level representation.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class
in org.apache.poi.xssf.usermodel">XSSFFont</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#findFont(short,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></strong>(short boldWeight,
short color,
@@ -347,97 +354,97 @@ implements <a href="../../../../../org/a
<div class="block">Finds a font that matches the one with the supplied
attributes</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/XSSFWorkbook.html#getActiveSheetIndex()">getActiveSheetIndex</a></strong>()</code>
<div class="block">Convenience method to get the active sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.List<<a
href="../../../../../org/apache/poi/openxml4j/opc/PackagePart.html"
title="class in org.apache.poi.openxml4j.opc">PackagePart</a>></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getAllEmbedds()">getAllEmbedds</a></strong>()</code>
<div class="block">Get the document's embedded files.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.List<<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPictureData.html"
title="class in
org.apache.poi.xssf.usermodel">XSSFPictureData</a>></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getAllPictures()">getAllPictures</a></strong>()</code>
<div class="block">Gets all pictures from the Workbook.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/model/CalculationChain.html"
title="class in org.apache.poi.xssf.model">CalculationChain</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCalculationChain()">getCalculationChain</a></strong>()</code>
<div class="block">Return the <a
href="../../../../../org/apache/poi/xssf/model/CalculationChain.html"
title="class in org.apache.poi.xssf.model"><code>CalculationChain</code></a>
object for this workbook</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html"
title="class in org.apache.poi.xssf.usermodel">XSSFCellStyle</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCellStyleAt(int)">getCellStyleAt</a></strong>(int idx)</code>
<div class="block">Get the cell style object at the given index</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFCreationHelper.html"
title="class in
org.apache.poi.xssf.usermodel">XSSFCreationHelper</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCreationHelper()">getCreationHelper</a></strong>()</code>
<div class="block">Returns an object that handles instantiating concrete
classes of the various instances for XSSF.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td
class="colFirst"><code>org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook</code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCTWorkbook()">getCTWorkbook</a></strong>()</code>
<div class="block">Return the underlying XML bean</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.Collection<<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFMap.html" title="class
in org.apache.poi.xssf.usermodel">XSSFMap</a>></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCustomXMLMappings()">getCustomXMLMappings</a></strong>()</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.List<<a
href="../../../../../org/apache/poi/xssf/model/ExternalLinksTable.html"
title="class in
org.apache.poi.xssf.model">ExternalLinksTable</a>></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getExternalLinksTable()">getExternalLinksTable</a></strong>()</code>
<div class="block">Returns the list of <a
href="../../../../../org/apache/poi/xssf/model/ExternalLinksTable.html"
title="class in org.apache.poi.xssf.model"><code>ExternalLinksTable</code></a>
object for this workbook</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/XSSFWorkbook.html#getFirstVisibleTab()">getFirstVisibleTab</a></strong>()</code>
<div class="block">Gets the first tab that is displayed in the list of tabs in
excel.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class
in org.apache.poi.xssf.usermodel">XSSFFont</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getFontAt(short)">getFontAt</a></strong>(short idx)</code>
<div class="block">Get the font at the given index number</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/XSSFWorkbook.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="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/model/MapInfo.html" title="class in
org.apache.poi.xssf.model">MapInfo</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getMapInfo()">getMapInfo</a></strong>()</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html"
title="enum in
org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getMissingCellPolicy()">getMissingCellPolicy</a></strong>()</code>
<div class="block">Retrieves the current policy on what to do when
getting missing or blank cells from a row.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class
in org.apache.poi.xssf.usermodel">XSSFName</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getName(java.lang.String)">getName</a></strong>(java.lang.String name)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class
in org.apache.poi.xssf.usermodel">XSSFName</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getNameAt(int)">getNameAt</a></strong>(int nameIndex)</code> </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/XSSFWorkbook.html#getNameIndex(java.lang.String)">getNameIndex</a></strong>(java.lang.String name)</code>
<div class="block">Gets the named range index by his name
@@ -445,153 +452,153 @@ implements <a href="../../../../../org/a
this method performs a case-insensitive search.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.List<<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class
in org.apache.poi.xssf.usermodel">XSSFName</a>></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getNames(java.lang.String)">getNames</a></strong>(java.lang.String name)</code>
<div class="block">Returns all defined names with the given name.</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/XSSFWorkbook.html#getNumberOfFonts()">getNumberOfFonts</a></strong>()</code>
<div class="block">Get the number of fonts in the this workbook</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/XSSFWorkbook.html#getNumberOfNames()">getNumberOfNames</a></strong>()</code>
<div class="block">Get the number of named ranges in the this workbook</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/XSSFWorkbook.html#getNumberOfSheets()">getNumberOfSheets</a></strong>()</code>
<div class="block">Get the number of worksheets in the this workbook</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/XSSFWorkbook.html#getNumCellStyles()">getNumCellStyles</a></strong>()</code>
<div class="block">Get the number of styles the workbook contains</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.List<<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/XSSFWorkbook.html#getPivotTables()">getPivotTables</a></strong>()</code> </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/XSSFWorkbook.html#getPrintArea(int)">getPrintArea</a></strong>(int sheetIndex)</code>
<div class="block">Retrieves the reference for the printarea of the specified
sheet, the sheet name is appended to the reference even if it was not
specified.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/model/SharedStringsTable.html"
title="class in org.apache.poi.xssf.model">SharedStringsTable</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSharedStringSource()">getSharedStringSource</a></strong>()</code>
<div class="block">Returns SharedStringsTable - tha cache of string for this
workbook</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class
in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSheet(java.lang.String)">getSheet</a></strong>(java.lang.String name)</code>
<div class="block">Get sheet with the given name (case insensitive match)</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class
in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSheetAt(int)">getSheetAt</a></strong>(int index)</code>
<div class="block">Get the XSSFSheet object at the given index.</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/XSSFWorkbook.html#getSheetIndex(org.apache.poi.ss.usermodel.Sheet)">getSheetIndex</a></strong>(<a
href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface
in org.apache.poi.ss.usermodel">Sheet</a> sheet)</code>
<div class="block">Returns the index of the given 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/XSSFWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex</a></strong>(java.lang.String name)</code>
<div class="block">Returns the index of the sheet by his name (case
insensitive match)</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/XSSFWorkbook.html#getSheetName(int)">getSheetName</a></strong>(int sheetIx)</code>
<div class="block">Get the sheet name</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/ss/SpreadsheetVersion.html" title="enum in
org.apache.poi.ss">SpreadsheetVersion</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSpreadsheetVersion()">getSpreadsheetVersion</a></strong>()</code>
<div class="block">Returns the spreadsheet version (EXCLE2007) of this
workbook</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/model/StylesTable.html" title="class
in org.apache.poi.xssf.model">StylesTable</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getStylesSource()">getStylesSource</a></strong>()</code>
<div class="block">Return a object representing a collection of shared objects
used for styling content,
e.g.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/model/ThemesTable.html" title="class
in org.apache.poi.xssf.model">ThemesTable</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getTheme()">getTheme</a></strong>()</code>
<div class="block">Returns the Theme of current workbook.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbookType.html"
title="enum in org.apache.poi.xssf.usermodel">XSSFWorkbookType</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getWorkbookType()">getWorkbookType</a></strong>()</code> </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/XSSFWorkbook.html#isDate1904()">isDate1904</a></strong>()</code>
<div class="block">Gets a boolean value that indicates whether the date
systems used in the workbook starts in 1904.</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/XSSFWorkbook.html#isHidden()">isHidden</a></strong>()</code> </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/XSSFWorkbook.html#isMacroEnabled()">isMacroEnabled</a></strong>()</code>
<div class="block">Are we a normal workbook (.xlsx), or a
macro enabled workbook (.xlsm)?</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/XSSFWorkbook.html#isRevisionLocked()">isRevisionLocked</a></strong>()</code>
<div class="block">Specifies a boolean value that indicates whether the
workbook is locked for revisions.</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/XSSFWorkbook.html#isSheetHidden(int)">isSheetHidden</a></strong>(int sheetIx)</code>
<div class="block">Check whether a sheet is hidden.</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/XSSFWorkbook.html#isSheetVeryHidden(int)">isSheetVeryHidden</a></strong>(int sheetIx)</code>
<div class="block">Check whether a sheet is very hidden.</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/XSSFWorkbook.html#isStructureLocked()">isStructureLocked</a></strong>()</code>
<div class="block">Specifies a boolean value that indicates whether structure
of workbook is locked.</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/XSSFWorkbook.html#isWindowsLocked()">isWindowsLocked</a></strong>()</code>
<div class="block">Specifies a boolean value that indicates whether the
windows that comprise the workbook are locked.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.Iterator<<a
href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface
in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
<div class="block">Alias for <a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a>
to allow
@@ -601,7 +608,7 @@ implements <a href="../../../../../org/a
to make iterating over a container (Workbook, Sheet, Row) consistent across
POI spreadsheets.</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/XSSFWorkbook.html#linkExternalWorkbook(java.lang.String,%20org.apache.poi.ss.usermodel.Workbook)">linkExternalWorkbook</a></strong>(java.lang.String name,
<a
href="../../../../../org/apache/poi/ss/usermodel/Workbook.html"
title="interface in
org.apache.poi.ss.usermodel">Workbook</a> workbook)</code>
@@ -609,44 +616,44 @@ implements <a href="../../../../../org/a
referencing the specified external workbook to be added to this one.</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/XSSFWorkbook.html#lockRevision()">lockRevision</a></strong>()</code>
<div class="block">Locks the workbook for revisions.</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/XSSFWorkbook.html#lockStructure()">lockStructure</a></strong>()</code>
<div class="block">Locks the structure of workbook.</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/XSSFWorkbook.html#lockWindows()">lockWindows</a></strong>()</code>
<div class="block">Locks the windows that comprise the workbook.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>protected static <a
href="../../../../../org/apache/poi/openxml4j/opc/OPCPackage.html" title="class
in org.apache.poi.openxml4j.opc">OPCPackage</a></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#newPackage(org.apache.poi.xssf.usermodel.XSSFWorkbookType)">newPackage</a></strong>(<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbookType.html"
title="enum in
org.apache.poi.xssf.usermodel">XSSFWorkbookType</a> workbookType)</code>
<div class="block">Create a new SpreadsheetML package and setup the default
minimal content</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/XSSFWorkbook.html#onDeleteFormula(org.apache.poi.xssf.usermodel.XSSFCell)">onDeleteFormula</a></strong>(<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class
in org.apache.poi.xssf.usermodel">XSSFCell</a> cell)</code>
<div class="block">Fired when a formula is deleted from this workbook,
for example when calling cell.setCellFormula(null)</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/XSSFWorkbook.html#onDocumentRead()">onDocumentRead</a></strong>()</code>
<div class="block">Fired when a package part is read</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/XSSFWorkbook.html#parseSheet(java.util.Map,%20org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet)">parseSheet</a></strong>(java.util.Map<java.lang.String,<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>> shIdMap,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet ctSheet)</code>
@@ -654,25 +661,25 @@ implements <a href="../../../../../org/a
the DOM based parse of large sheets (see examples).</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/XSSFWorkbook.html#removeName(int)">removeName</a></strong>(int nameIndex)</code>
<div class="block">Remove the defined name at the specified index</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/XSSFWorkbook.html#removeName(java.lang.String)">removeName</a></strong>(java.lang.String name)</code>
<div class="block">Remove a defined name by name</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/XSSFWorkbook.html#removePrintArea(int)">removePrintArea</a></strong>(int sheetIndex)</code>
<div class="block">Delete the printarea for the sheet specified</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/XSSFWorkbook.html#removeSheetAt(int)">removeSheetAt</a></strong>(int index)</code>
<div class="block">Removes sheet at the given index.<p/>
@@ -681,40 +688,40 @@ implements <a href="../../../../../org/a
the 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/xssf/usermodel/XSSFWorkbook.html#setActiveSheet(int)">setActiveSheet</a></strong>(int index)</code>
<div class="block">Convenience method to set the active 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/XSSFWorkbook.html#setFirstVisibleTab(int)">setFirstVisibleTab</a></strong>(int index)</code>
<div class="block">Sets the first tab that is displayed in the list of tabs in
excel.</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/XSSFWorkbook.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code>
<div class="block">Whether the application shall perform a full recalculation
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/XSSFWorkbook.html#setHidden(boolean)">setHidden</a></strong>(boolean hiddenFlag)</code> </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/XSSFWorkbook.html#setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy)">setMissingCellPolicy</a></strong>(<a
href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html"
title="enum in
org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a> missingCellPolicy)</code>
<div class="block">Sets the policy on what to do when
getting missing or blank cells from a row.</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/XSSFWorkbook.html#setPivotTables(java.util.List)">setPivotTables</a></strong>(java.util.List<<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html"
title="class in
org.apache.poi.xssf.usermodel">XSSFPivotTable</a>> pivotTables)</code> </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/XSSFWorkbook.html#setPrintArea(int,%20int,%20int,%20int,%20int)">setPrintArea</a></strong>(int sheetIndex,
int startColumn,
@@ -724,125 +731,125 @@ implements <a href="../../../../../org/a
<div class="block">For the Convenience of Java Programmers maintaining
pointers.</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/XSSFWorkbook.html#setPrintArea(int,%20java.lang.String)">setPrintArea</a></strong>(int sheetIndex,
java.lang.String reference)</code>
<div class="block">Sets the printarea for the sheet provided</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/XSSFWorkbook.html#setRevisionsPassword(java.lang.String,%20org.apache.poi.poifs.crypt.HashAlgorithm)">setRevisionsPassword</a></strong>(java.lang.String password,
<a
href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum
in org.apache.poi.poifs.crypt">HashAlgorithm</a> hashAlgo)</code>
<div class="block">Sets the revisions password.</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/XSSFWorkbook.html#setSelectedTab(int)">setSelectedTab</a></strong>(int index)</code>
<div class="block">We only set one sheet as selected for compatibility with
HSSF.</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/XSSFWorkbook.html#setSheetHidden(int,%20boolean)">setSheetHidden</a></strong>(int sheetIx,
boolean hidden)</code>
<div class="block">Sets the visible state of 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/XSSFWorkbook.html#setSheetHidden(int,%20int)">setSheetHidden</a></strong>(int sheetIx,
int state)</code>
<div class="block">Hide or unhide a 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/XSSFWorkbook.html#setSheetName(int,%20java.lang.String)">setSheetName</a></strong>(int sheetIndex,
java.lang.String sheetname)</code>
<div class="block">Set the sheet name.</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/XSSFWorkbook.html#setSheetOrder(java.lang.String,%20int)">setSheetOrder</a></strong>(java.lang.String sheetname,
int pos)</code>
<div class="block">sets the order of appearance for a given 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/XSSFWorkbook.html#setVBAProject(java.io.InputStream)">setVBAProject</a></strong>(java.io.InputStream vbaProjectStream)</code>
<div class="block">Adds a vbaProject.bin file to the workbook.</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/XSSFWorkbook.html#setVBAProject(org.apache.poi.xssf.usermodel.XSSFWorkbook)">setVBAProject</a></strong>(<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html"
title="class in
org.apache.poi.xssf.usermodel">XSSFWorkbook</a> macroWorkbook)</code>
<div class="block">Adds a vbaProject.bin file taken from another, given
workbook to this one.</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/XSSFWorkbook.html#setWorkbookPassword(java.lang.String,%20org.apache.poi.poifs.crypt.HashAlgorithm)">setWorkbookPassword</a></strong>(java.lang.String password,
<a
href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum
in org.apache.poi.poifs.crypt">HashAlgorithm</a> hashAlgo)</code>
<div class="block">Sets the workbook password.</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/XSSFWorkbook.html#setWorkbookType(org.apache.poi.xssf.usermodel.XSSFWorkbookType)">setWorkbookType</a></strong>(<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbookType.html"
title="enum in
org.apache.poi.xssf.usermodel">XSSFWorkbookType</a> type)</code>
<div class="block">Sets whether the workbook will be an .xlsx or .xlsm
(macro-enabled) file.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.Iterator<<a
href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface
in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
<div class="block">Returns an iterator of the sheets in the workbook
in sheet order.</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/XSSFWorkbook.html#unLock()">unLock</a></strong>()</code>
<div class="block">Removes the workbook protection settings</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/XSSFWorkbook.html#unLockRevision()">unLockRevision</a></strong>()</code>
<div class="block">Unlocks the workbook for revisions.</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/XSSFWorkbook.html#unLockStructure()">unLockStructure</a></strong>()</code>
<div class="block">Unlocks the structure of 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/xssf/usermodel/XSSFWorkbook.html#unLockWindows()">unLockWindows</a></strong>()</code>
<div class="block">Unlocks the windows that comprise the workbook.</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/XSSFWorkbook.html#validateRevisionsPassword(java.lang.String)">validateRevisionsPassword</a></strong>(java.lang.String 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>boolean</code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#validateWorkbookPassword(java.lang.String)">validateWorkbookPassword</a></strong>(java.lang.String 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="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.Iterator<<a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class
in org.apache.poi.xssf.usermodel">XSSFSheet</a>></code></td>
<td class="colLast"><code><strong><a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#xssfSheetIterator()">xssfSheetIterator</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong> </div>
@@ -1197,12 +1204,32 @@ public org.openxmlformats.schemas.s
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a
href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#cloneSheet(int)">cloneSheet</a></code> in
interface <code><a
href="../../../../../org/apache/poi/ss/usermodel/Workbook.html"
title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></dd>
+<dt><span class="strong">Parameters:</span></dt><dd><code>sheetNum</code> -
The index of the sheet to clone</dd>
<dt><span class="strong">Returns:</span></dt><dd>XSSFSheet representing the
cloned sheet.</dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalArgumentException</code> - if the sheet index in
invalid</dd>
<dd><code><a href="../../../../../org/apache/poi/POIXMLException.html"
title="class in org.apache.poi">POIXMLException</a></code> - if there were
errors when cloning</dd></dl>
</li>
</ul>
+<a name="cloneSheet(int, java.lang.String)">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>cloneSheet</h4>
+<pre>public <a
href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class
in
org.apache.poi.xssf.usermodel">XSSFSheet</a> cloneSheet(int sheetNum,
+ java.lang.String newName)</pre>
+<div class="block">Create an XSSFSheet from an existing sheet in the
XSSFWorkbook.
+ The cloned sheet is a deep copy of the original but with a new given
+ name.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>sheetNum</code>
- The index of the sheet to clone</dd><dd><code>newName</code> - The name to
set for the newly created sheet</dd>
+<dt><span class="strong">Returns:</span></dt><dd>XSSFSheet representing the
cloned sheet.</dd>
+<dt><span class="strong">Throws:</span></dt>
+<dd><code>java.lang.IllegalArgumentException</code> - if the sheet index or
the sheet
+ name is invalid</dd>
+<dd><code><a href="../../../../../org/apache/poi/POIXMLException.html"
title="class in org.apache.poi">POIXMLException</a></code> - if there were
errors when cloning</dd></dl>
+</li>
+</ul>
<a name="createCellStyle()">
<!-- -->
</a>
Modified:
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
---
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html
(original)
+++
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html
Fri Apr 1 07:11:25 2016
@@ -167,46 +167,53 @@
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
+<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#cloneSheet(int,%20java.lang.String)">cloneSheet</a></strong>(int sheetNum,
+ java.lang.String newName)</code>
+<div class="block">Create an XSSFSheet from an existing sheet in the
XSSFWorkbook.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createSheet()">createSheet</a></strong>()</code>
<div class="block">Create an XSSFSheet for this workbook, adds it to the
sheets and returns
the high level representation.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createSheet(java.lang.String)">createSheet</a></strong>(java.lang.String sheetname)</code>
<div class="block">Create a new sheet for this Workbook and return the high
level representation.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><span class="strong">XSSFPicture.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFPicture.html#getSheet()">getSheet</a></strong>()</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><span class="strong">XSSFCell.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html#getSheet()">getSheet</a></strong>()</code>
<div class="block">Returns the sheet this cell belongs to</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><span class="strong">XSSFRow.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html#getSheet()">getSheet</a></strong>()</code>
<div class="block">Returns the XSSFSheet this row belongs to</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSheet(java.lang.String)">getSheet</a></strong>(java.lang.String name)</code>
<div class="block">Get sheet with the given name (case insensitive match)</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSheetAt(int)">getSheetAt</a></strong>(int index)</code>
<div class="block">Get the XSSFSheet object at the given index.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html"
title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><span class="strong">XSSFTable.</span><code><strong><a
href="../../../../../../org/apache/poi/xssf/usermodel/XSSFTable.html#getXSSFSheet()">getXSSFSheet</a></strong>()</code> </td>
</tr>
Modified: poi/site/publish/changes.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Fri Apr 1 07:11:25 2016
@@ -265,6 +265,9 @@ if (VERSION > 3) {
<ul>
<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=58909">58909</a> - Add a
cloneSheet() which directly sets the sheetname to allow to avoid a costly
renaming of sheets</li>
+
+<li>
<img class="icon" alt="fix" src="images/fix.jpg"> <a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59132">59132</a> - Adjust
implementation of COUNTBLANK to be conforming to Excel, empty strings are
counted as blank as well</li>
<li>
Modified: poi/site/publish/changes.rss
URL:
http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1737315&r1=1737314&r2=1737315&view=diff
==============================================================================
--- poi/site/publish/changes.rss (original)
+++ poi/site/publish/changes.rss Fri Apr 1 07:11:25 2016
@@ -1,3 +1,3 @@
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN"
"http://my.netscape.com/publish/formats/rss-0.91.dtd">
-<rss version="0.91"><channel><title>Apache POI
Changes</title><link>http://poi.apache.org/changes.html</link><description>Apache
POI Changes</description><language>en-us</language><item><title> fix(bug
59132)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59132) - Adjust implementation of COUNTBLANK to be
conforming to Excel, empty strings are counted as blank as
well</description></item><item><title> fix(bug
59199)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59199) - Gracefully handle null-values in
Cell.setValue() for Date and Calendar similar to
String.</description></item><item><title> fix(bug
59224)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59224) - XSSF: fix XSSFColor.hasTint which incorrectly
used the alpha channel, add
XSSFColor.hasAlpha</description></item><item><title> fix(bug
59222)</title><link>http://poi.apache.org/chang
es.html</link><description> fix by POI Developers (bug 59222) - XSSF: fix NPE
raised by XSSFSheet.getCellComments()</description></item><item><title> fix(bug
59212)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59212) - Common SS: copy non-validating
XSSFSheet.addMergedRegionUnsafe from bug 58885 to Sheet
interface</description></item><item><title> fix(bug
59208)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59208) - XWPF: bold xml value of "1" treated as
false</description></item><item><title>
add</title><link>http://poi.apache.org/changes.html</link><description> add by
POI Developers - HSLF: Add support for system
colors</description></item><item><title> fix(bug
56930)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 56930) - Add Workbook.getNames() to allow to query for
names that appear multiple times</description></item><item><title> f
ix(bug
55791)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 55791) - Avoid using an existing file-name when creating
a new slide, it could still be left over from previous partial
removal</description></item><item><title> fix(bug
55668)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 55668) - Try to avoid NullPointerException by setting
the cell to BLANK instead, when changing cell-type and a formula leads to
null-string</description></item><item><title> fix(bug
59135)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59135) - Password gets truncated when using passwords
longer than 15 characters for the function
protectSheet()</description></item><item><title> add(bug
56549)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 56549) - Correctly calculate char index ranges for HWPF
in the TextPieceTabl
e</description></item><item><title> add(bug
57495)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 57495) - Fix problem with tables in documents at pos
0</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - Fix a number of edge-cases where file-handles would be
leaked</description></item><item><title> fix(bug
59170)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) -
*Workbook.setRepeatingRowsAndColumns()</description></item><item><title>
fix(bug
59170)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) -
org.apache.poi.hssf/ss.util.Region</description></item><item><title> add(bug
57031)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 57
031) - Out of Memory when extracting text from attached
files</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - More helpful exception when POIFSFileSystem is given a raw XML
file</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - More helpful exceptions when OPCPackage is given OLE2 or ODF
or raw XML files</description></item></channel></rss>
\ No newline at end of file
+<rss version="0.91"><channel><title>Apache POI
Changes</title><link>http://poi.apache.org/changes.html</link><description>Apache
POI Changes</description><language>en-us</language><item><title> fix(bug
58909)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 58909) - Add a cloneSheet() which directly sets the
sheetname to allow to avoid a costly renaming of
sheets</description></item><item><title> fix(bug
59132)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59132) - Adjust implementation of COUNTBLANK to be
conforming to Excel, empty strings are counted as blank as
well</description></item><item><title> fix(bug
59199)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59199) - Gracefully handle null-values in
Cell.setValue() for Date and Calendar similar to
String.</description></item><item><title> fix(bug
59224)</title><link>http://poi.apache.org
/changes.html</link><description> fix by POI Developers (bug 59224) - XSSF:
fix XSSFColor.hasTint which incorrectly used the alpha channel, add
XSSFColor.hasAlpha</description></item><item><title> fix(bug
59222)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59222) - XSSF: fix NPE raised by
XSSFSheet.getCellComments()</description></item><item><title> fix(bug
59212)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59212) - Common SS: copy non-validating
XSSFSheet.addMergedRegionUnsafe from bug 58885 to Sheet
interface</description></item><item><title> fix(bug
59208)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59208) - XWPF: bold xml value of "1" treated as
false</description></item><item><title>
add</title><link>http://poi.apache.org/changes.html</link><description> add by
POI Developers - HSLF: Add support for system colors</description></
item><item><title> fix(bug
56930)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 56930) - Add Workbook.getNames() to allow to query for
names that appear multiple times</description></item><item><title> fix(bug
55791)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 55791) - Avoid using an existing file-name when creating
a new slide, it could still be left over from previous partial
removal</description></item><item><title> fix(bug
55668)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 55668) - Try to avoid NullPointerException by setting
the cell to BLANK instead, when changing cell-type and a formula leads to
null-string</description></item><item><title> fix(bug
59135)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59135) - Password gets truncated when using passwords
longer than 15 characters
for the function protectSheet()</description></item><item><title> add(bug
56549)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 56549) - Correctly calculate char index ranges for HWPF
in the TextPieceTable</description></item><item><title> add(bug
57495)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 57495) - Fix problem with tables in documents at pos
0</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - Fix a number of edge-cases where file-handles would be
leaked</description></item><item><title> fix(bug
59170)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) -
*Workbook.setRepeatingRowsAndColumns()</description></item><item><title>
fix(bug
59170)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) -
org.apache.poi.hssf/ss.util.Region</description></item><item><title> add(bug
57031)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 57031) - Out of Memory when extracting text from
attached files</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - More helpful exception when POIFSFileSystem is given a raw XML
file</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - More helpful exceptions when OPCPackage is given OLE2 or ODF
or raw XML files</description></item></channel></rss>
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]