poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1795317 - in /poi/site/publish/apidocs: index-all.html org/apache/poi/ss/formula/functions/Irr.html org/apache/poi/xssf/streaming/SXSSFSheet.html
Date Tue, 16 May 2017 14:47:11 GMT
Author: nick
Date: Tue May 16 14:47:10 2017
New Revision: 1795317

URL: http://svn.apache.org/viewvc?rev=1795317&view=rev
Log:
Republish javadocs

Modified:
    poi/site/publish/apidocs/index-all.html
    poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Irr.html
    poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html

Modified: poi/site/publish/apidocs/index-all.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/index-all.html?rev=1795317&r1=1795316&r2=1795317&view=diff
==============================================================================
--- poi/site/publish/apidocs/index-all.html (original)
+++ poi/site/publish/apidocs/index-all.html Tue May 16 14:47:10 2017
@@ -12007,6 +12007,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/poifs/property/DirectoryProperty.PropertyComparator.html#DirectoryProperty.PropertyComparator()">DirectoryProperty.PropertyComparator()</a></span> - Constructor for class org.apache.poi.poifs.property.<a href="./org/apache/poi/poifs/property/DirectoryProperty.PropertyComparator.html" title="class in org.apache.poi.poifs.property">DirectoryProperty.PropertyComparator</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()">disableLocking()</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Disable sheet protection</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()">disableLocking()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Disable sheet protection</div>
@@ -13531,6 +13535,10 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hslf/model/textproperties/CharFlagsTextProp.html#ENABLE_NUMBERING_2_IDX">ENABLE_NUMBERING_2_IDX</a></span> - Static variable in class org.apache.poi.hslf.model.textproperties.<a href="./org/apache/poi/hslf/model/textproperties/CharFlagsTextProp.html" title="class in org.apache.poi.hslf.model.textproperties">CharFlagsTextProp</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()">enableLocking()</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable sheet protection</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()">enableLocking()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable sheet protection</div>
@@ -53632,48 +53640,92 @@
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hsmf/datatypes/MAPIProperty.html#LOCK_TYPE">LOCK_TYPE</a></span> - Static variable in class org.apache.poi.hsmf.datatypes.<a href="./org/apache/poi/hsmf/datatypes/MAPIProperty.html" title="class in org.apache.poi.hsmf.datatypes">MAPIProperty</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockAutoFilter(boolean)">lockAutoFilter(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Autofilters locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockAutoFilter(boolean)">lockAutoFilter(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Autofilters locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockDeleteColumns(boolean)">lockDeleteColumns(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Deleting columns locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteColumns(boolean)">lockDeleteColumns(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Deleting columns locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockDeleteRows(boolean)">lockDeleteRows(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Deleting rows locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteRows(boolean)">lockDeleteRows(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Deleting rows locking.</div>
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/ss/util/CellUtil.html#LOCKED">LOCKED</a></span> - Static variable in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellUtil.html" title="class in org.apache.poi.ss.util">CellUtil</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockFormatCells(boolean)">lockFormatCells(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Formatting cells locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatCells(boolean)">lockFormatCells(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Formatting cells locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockFormatColumns(boolean)">lockFormatColumns(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Formatting columns locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatColumns(boolean)">lockFormatColumns(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Formatting columns locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockFormatRows(boolean)">lockFormatRows(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Formatting rows locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatRows(boolean)">lockFormatRows(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Formatting rows locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockInsertColumns(boolean)">lockInsertColumns(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Inserting columns locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertColumns(boolean)">lockInsertColumns(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Inserting columns locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockInsertHyperlinks(boolean)">lockInsertHyperlinks(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Inserting hyperlinks locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertHyperlinks(boolean)">lockInsertHyperlinks(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Inserting hyperlinks locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockInsertRows(boolean)">lockInsertRows(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Inserting rows locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertRows(boolean)">lockInsertRows(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Inserting rows locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockObjects(boolean)">lockObjects(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Objects locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockObjects(boolean)">lockObjects(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Objects locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockPivotTables(boolean)">lockPivotTables(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Pivot Tables locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockPivotTables(boolean)">lockPivotTables(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Pivot Tables locking.</div>
@@ -53682,18 +53734,34 @@
 <dd>
 <div class="block">Locks the workbook for revisions.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockScenarios(boolean)">lockScenarios(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Scenarios locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockScenarios(boolean)">lockScenarios(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Scenarios locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockSelectLockedCells(boolean)">lockSelectLockedCells(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Selection of locked cells locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectLockedCells(boolean)">lockSelectLockedCells(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Selection of locked cells locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockSelectUnlockedCells(boolean)">lockSelectUnlockedCells(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Selection of unlocked cells locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectUnlockedCells(boolean)">lockSelectUnlockedCells(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Selection of unlocked cells locking.</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#lockSort(boolean)">lockSort(boolean)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Enable or disable Sort locking.</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSort(boolean)">lockSort(boolean)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block">Enable or disable Sort locking.</div>
@@ -77202,6 +77270,10 @@ for streaming/read-only processing of xl
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#setTabColor(org.apache.poi.xssf.usermodel.XSSFColor)">setTabColor(XSSFColor)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#setTabColor(int)">setTabColor(int)</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
+<dd>
+<div class="block">Set background color of the sheet tab</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#setTabColor(int)">setTabColor(int)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></dt>
 <dd>
 <div class="block"><span class="strong">Deprecated.</span>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Irr.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Irr.html?rev=1795317&r1=1795316&r2=1795317&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Irr.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/Irr.html Tue May 16 14:47:10 2017
@@ -108,9 +108,7 @@ implements <a href="../../../../../../or
 <div class="block">Calculates the internal rate of return.
 
  Syntax is IRR(values) or IRR(values,guess)</div>
-<dl><dt><span class="strong">Author:</span></dt>
-  <dd>Marcel May, Yegor Kozlov</dd>
-<dt><span class="strong">See Also:</span></dt><dd><a href="http://en.wikipedia.org/wiki/Internal_rate_of_return#Numerical_solution">Wikipedia on IRR</a>, 
+<dl><dt><span class="strong">See Also:</span></dt><dd><a href="http://en.wikipedia.org/wiki/Internal_rate_of_return#Numerical_solution">Wikipedia on IRR</a>, 
 <a href="http://office.microsoft.com/en-us/excel-help/irr-HP005209146.aspx">Excel IRR</a></dd></dl>
 </li>
 </ul>

Modified: poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html?rev=1795317&r1=1795316&r2=1795317&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html Tue May 16 14:47:10 2017
@@ -239,6 +239,18 @@ implements <a href="../../../../../org/a
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()">disableLocking</a></strong>()</code>
+<div class="block">Disable sheet protection</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()">enableLocking</a></strong>()</code>
+<div class="block">Enable sheet protection</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#flushRows()">flushRows</a></strong>()</code>
 <div class="block">Flush all rows to disk.</div>
 </td>
@@ -664,264 +676,360 @@ implements <a href="../../../../../org/a
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#lockAutoFilter(boolean)">lockAutoFilter</a></strong>(boolean&nbsp;enabled)</code>
+<div class="block">Enable or disable Autofilters locking.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#lockObjects(boolean)">lockObjects</a></strong>(boolean&nbsp;enabled)</code>
+<div class="block">Enable or disable Objects locking.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#lockScenarios(boolean)">lockScenarios</a></strong>(boolean&nbsp;enabled)</code>
+<div class="block">Enable or disable Scenarios locking.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#lockSort(boolean)">lockSort</a></strong>(boolean&nbsp;enabled)</code>
+<div class="block">Enable or disable Sort locking.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#protectSheet(java.lang.String)">protectSheet</a></strong>(java.lang.String&nbsp;password)</code>
 <div class="block">Sets the protection enabled as well as the password</div>
 </td>
 </tr>
-<tr class="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;? extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions</a></strong>(java.util.Collection&lt;java.lang.Integer&gt;&nbsp;indices)</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/streaming/SXSSFSheet.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="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="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/streaming/SXSSFSheet.html#rowIterator()">rowIterator</a></strong>()</code>
 <div class="block">Returns an iterator of the physical 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/streaming/SXSSFSheet.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="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;? extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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/ss/usermodel/AutoFilter.html" title="interface in org.apache.poi.ss.usermodel">AutoFilter</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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/streaming/SXSSFSheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a></strong>(int&nbsp;width)</code>
 <div class="block">Set the default column width for the sheet (if the columns do not define their own width)
  in characters</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/streaming/SXSSFSheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a></strong>(float&nbsp;height)</code>
 <div class="block">Set the default row height for the sheet (if the rows do not define their own height) in
  points</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets whether the formulas are shown in a viewer</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets whether the gridlines are shown in a viewer</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/streaming/SXSSFSheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></strong>(boolean&nbsp;show)</code>
 <div class="block">Sets whether the RowColHeadings are shown in a viewer</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/streaming/SXSSFSheet.html#setFitToPage(boolean)">setFitToPage</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Flag indicating whether the Fit to Page print option is enabled.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Control if Excel should be asked to recalculate all formulas when the
   workbook is opened, via the "sheetCalcPr fullCalcOnLoad" option.</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/streaming/SXSSFSheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Determines whether the output is horizontally centered on the page.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/streaming/SXSSFSheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></strong>(boolean&nbsp;show)</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/streaming/SXSSFSheet.html#setPrintRowAndColumnHeadings(boolean)">setPrintRowAndColumnHeadings</a></strong>(boolean&nbsp;show)</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/streaming/SXSSFSheet.html#setRandomAccessWindowSize(int)">setRandomAccessWindowSize</a></strong>(int&nbsp;value)</code>
 <div class="block">Specifies how many rows can be accessed at most via getRow().</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/streaming/SXSSFSheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;columnRangeRef)</code>
 <div class="block">Sets the repeating columns used when printing the sheet, as found in 
  File-&gt;PageSetup-&gt;Sheet.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;rowRangeRef)</code>
 <div class="block">Sets the repeating rows used when printing the sheet, as found in 
  File-&gt;PageSetup-&gt;Sheet.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRightToLeft(boolean)">setRightToLeft</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Sets whether the worksheet is displayed from right to left instead of from left to right.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRowBreak(int)">setRowBreak</a></strong>(int&nbsp;row)</code>
 <div class="block">Sets a page break at the indicated row</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/streaming/SXSSFSheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int&nbsp;row,
                     boolean&nbsp;collapse)</code>
 <div class="block">Set view state of a grouped range of rows.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRowOutlineLevel(int,%20int)">setRowOutlineLevel</a></strong>(int&nbsp;rownum,
                   int&nbsp;level)</code>
 <div class="block">Set row groupings (like groupRow) in a stream-friendly manner</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/streaming/SXSSFSheet.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/streaming/SXSSFSheet.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/streaming/SXSSFSheet.html#setSelected(boolean)">setSelected</a></strong>(boolean&nbsp;value)</code>
 <div class="block">Sets a flag indicating whether this sheet is selected.</div>
 </td>
 </tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setTabColor(int)">setTabColor</a></strong>(int&nbsp;colorIndex)</code>
+<div class="block">Set background color of the sheet tab</div>
+</td>
+</tr>
 <tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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>&nbsp;</td>
@@ -3318,12 +3426,223 @@ public&nbsp;<a href="../../../../../org/
 <a name="setTabColor(org.apache.poi.xssf.usermodel.XSSFColor)">
 <!--   -->
 </a>
-<ul class="blockListLast">
+<ul class="blockList">
 <li class="blockList">
 <h4>setTabColor</h4>
 <pre>public&nbsp;void&nbsp;setTabColor(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</pre>
 </li>
 </ul>
+<a name="enableLocking()">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>enableLocking</h4>
+<pre>public&nbsp;void&nbsp;enableLocking()</pre>
+<div class="block">Enable sheet protection</div>
+</li>
+</ul>
+<a name="disableLocking()">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>disableLocking</h4>
+<pre>public&nbsp;void&nbsp;disableLocking()</pre>
+<div class="block">Disable sheet protection</div>
+</li>
+</ul>
+<a name="lockAutoFilter(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockAutoFilter</h4>
+<pre>public&nbsp;void&nbsp;lockAutoFilter(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Autofilters locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockDeleteColumns(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockDeleteColumns</h4>
+<pre>public&nbsp;void&nbsp;lockDeleteColumns(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Deleting columns locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockDeleteRows(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockDeleteRows</h4>
+<pre>public&nbsp;void&nbsp;lockDeleteRows(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Deleting rows locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockFormatCells(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockFormatCells</h4>
+<pre>public&nbsp;void&nbsp;lockFormatCells(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Formatting cells locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockFormatColumns(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockFormatColumns</h4>
+<pre>public&nbsp;void&nbsp;lockFormatColumns(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Formatting columns locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockFormatRows(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockFormatRows</h4>
+<pre>public&nbsp;void&nbsp;lockFormatRows(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Formatting rows locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockInsertColumns(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockInsertColumns</h4>
+<pre>public&nbsp;void&nbsp;lockInsertColumns(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Inserting columns locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockInsertHyperlinks(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockInsertHyperlinks</h4>
+<pre>public&nbsp;void&nbsp;lockInsertHyperlinks(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Inserting hyperlinks locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockInsertRows(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockInsertRows</h4>
+<pre>public&nbsp;void&nbsp;lockInsertRows(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Inserting rows locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockPivotTables(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockPivotTables</h4>
+<pre>public&nbsp;void&nbsp;lockPivotTables(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Pivot Tables locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockSort(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockSort</h4>
+<pre>public&nbsp;void&nbsp;lockSort(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Sort locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockObjects(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockObjects</h4>
+<pre>public&nbsp;void&nbsp;lockObjects(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Objects locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockScenarios(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockScenarios</h4>
+<pre>public&nbsp;void&nbsp;lockScenarios(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Scenarios locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockSelectLockedCells(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockSelectLockedCells</h4>
+<pre>public&nbsp;void&nbsp;lockSelectLockedCells(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Selection of locked cells locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="lockSelectUnlockedCells(boolean)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>lockSelectUnlockedCells</h4>
+<pre>public&nbsp;void&nbsp;lockSelectUnlockedCells(boolean&nbsp;enabled)</pre>
+<div class="block">Enable or disable Selection of unlocked cells locking.
+ This does not modify sheet protection status.
+ To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
+</li>
+</ul>
+<a name="setTabColor(int)">
+<!--   -->
+</a>
+<ul class="blockListLast">
+<li class="blockList">
+<h4>setTabColor</h4>
+<pre>public&nbsp;void&nbsp;setTabColor(int&nbsp;colorIndex)</pre>
+<div class="block">Set background color of the sheet tab</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>colorIndex</code> - the indexed color to set, must be a constant from <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
+</li>
+</ul>
 </li>
 </ul>
 </li>



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


Mime
View raw message