You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2016/06/20 09:13:48 UTC
svn commit: r1749281 [2/6] - in /poi/site/publish: ./ apidocs/
apidocs/org/apache/poi/hssf/record/cf/ apidocs/org/apache/poi/hssf/usermodel/
apidocs/org/apache/poi/hssf/usermodel/class-use/
apidocs/org/apache/poi/hssf/util/ apidocs/org/apache/poi/ss/fo...
Modified: poi/site/publish/apidocs/index-all.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/index-all.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/index-all.html (original)
+++ poi/site/publish/apidocs/index-all.html Mon Jun 20 09:13:46 2016
@@ -4240,7 +4240,7 @@
<dd>
<div class="block">See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'<p/>
- Common subclass of 8-bit and 16-bit versions</div>
+ Common superclass of 8-bit and 16-bit versions</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeAddressBase.html#CellRangeAddressBase(int,%20int,%20int,%20int)">CellRangeAddressBase(int, int, int, int)</a></span> - Constructor for class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></dt>
<dd> </dd>
@@ -4262,9 +4262,11 @@
</dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeAddressList.html#CellRangeAddressList(org.apache.poi.hssf.record.RecordInputStream)">CellRangeAddressList(RecordInputStream)</a></span> - Constructor for class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeAddressList.html" title="class in org.apache.poi.ss.util">CellRangeAddressList</a></dt>
<dd> </dd>
-<dt><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">CellRangeUtil</span></a> - Class in <a href="./org/apache/poi/hssf/record/cf/package-summary.html">org.apache.poi.hssf.record.cf</a></dt>
+<dt><a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">CellRangeUtil</span></a> - Class in <a href="./org/apache/poi/ss/util/package-summary.html">org.apache.poi.ss.util</a></dt>
<dd>
-<div class="block">TODO Should this move to org.apache.poi.ss.util ?</div>
+<div class="block">Utility class that builds on <a href="./org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a>
+
+ Portions of this class may be moved to <a href="./org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddressBase</code></a></div>
</dd>
<dt><a href="./org/apache/poi/hssf/record/CellRecord.html" title="class in org.apache.poi.hssf.record"><span class="strong">CellRecord</span></a> - Class in <a href="./org/apache/poi/hssf/record/package-summary.html">org.apache.poi.hssf.record</a></dt>
<dd>
@@ -6559,10 +6561,6 @@
<dd>
<div class="block">Check if a part already exists in this package from its name.</div>
</dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#contains(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">contains(CellRangeAddress, CellRangeAddress)</a></span> - Static method in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
-<dd>
-<div class="block">Check if the specified range is located inside of this cell range.</div>
-</dd>
<dt><span class="strong"><a href="./org/apache/poi/POIXMLProperties.CustomProperties.html#contains(java.lang.String)">contains(String)</a></span> - Method in class org.apache.poi.<a href="./org/apache/poi/POIXMLProperties.CustomProperties.html" title="class in org.apache.poi">POIXMLProperties.CustomProperties</a></dt>
<dd>
<div class="block">Check if a property with this name already exists in the collection of custom properties</div>
@@ -6575,6 +6573,12 @@
</dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html#contains(int,%20int)">contains(int, int)</a></span> - Method in class org.apache.poi.ss.formula.eval.<a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html" title="class in org.apache.poi.ss.formula.eval">AreaEvalBase</a></dt>
<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#contains(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">contains(CellRangeAddress, CellRangeAddress)</a></span> - Static method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
+<dd>
+<div class="block">Check if cell range A contains cell range B (B <= A)
+
+ TODO: move this into <a href="./org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddressBase</code></a></div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/util/IntList.html#contains(int)">contains(int)</a></span> - Method in class org.apache.poi.util.<a href="./org/apache/poi/util/IntList.html" title="class in org.apache.poi.util">IntList</a></dt>
<dd>
<div class="block">Returns true if this list contains the specified element.</div>
@@ -6590,7 +6594,9 @@
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/util/SheetUtil.html#containsCell(org.apache.poi.ss.util.CellRangeAddress,%20int,%20int)">containsCell(CellRangeAddress, int, int)</a></span> - Static method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/SheetUtil.html" title="class in org.apache.poi.ss.util">SheetUtil</a></dt>
<dd>
-<div class="block">Check if the cell is in the specified cell range</div>
+<div class="block"><span class="strong">Deprecated.</span>
+<div class="block"><i>3.15 beta 2. Use <a href="./org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)"><code>CellRangeAddressBase.isInRange(int, int)</code></a>.</i></div>
+</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFPatriarch.html#containsChart()">containsChart()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFPatriarch.html" title="class in org.apache.poi.hssf.usermodel">HSSFPatriarch</a></dt>
<dd>
@@ -6610,6 +6616,10 @@
</dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html#containsColumn(int)">containsColumn(int)</a></span> - Method in class org.apache.poi.ss.formula.eval.<a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html" title="class in org.apache.poi.ss.formula.eval">AreaEvalBase</a></dt>
<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeAddressBase.html#containsColumn(int)">containsColumn(int)</a></span> - Method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></dt>
+<dd>
+<div class="block">Check if the column is in the specified cell range</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/hssf/record/CFRule12Record.html#containsDataBarBlock()">containsDataBarBlock()</a></span> - Method in class org.apache.poi.hssf.record.<a href="./org/apache/poi/hssf/record/CFRule12Record.html" title="class in org.apache.poi.hssf.record">CFRule12Record</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/hssf/record/CFRuleBase.html#containsFontFormattingBlock()">containsFontFormattingBlock()</a></span> - Method in class org.apache.poi.hssf.record.<a href="./org/apache/poi/hssf/record/CFRuleBase.html" title="class in org.apache.poi.hssf.record">CFRuleBase</a></dt>
@@ -6630,6 +6640,10 @@
</dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html#containsRow(int)">containsRow(int)</a></span> - Method in class org.apache.poi.ss.formula.eval.<a href="./org/apache/poi/ss/formula/eval/AreaEvalBase.html" title="class in org.apache.poi.ss.formula.eval">AreaEvalBase</a></dt>
<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeAddressBase.html#containsRow(int)">containsRow(int)</a></span> - Method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></dt>
+<dd>
+<div class="block">Check if the row is in the specified cell range</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/hpsf/CustomProperties.html#containsValue(java.lang.Object)">containsValue(Object)</a></span> - Method in class org.apache.poi.hpsf.<a href="./org/apache/poi/hpsf/CustomProperties.html" title="class in org.apache.poi.hpsf">CustomProperties</a></dt>
<dd>
<div class="block">Checks against both the property, and its values.</div>
@@ -9109,7 +9123,7 @@
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/hslf/usermodel/HSLFTextParagraph.html#createEmptyParagraph(org.apache.poi.hslf.record.EscherTextboxWrapper)">createEmptyParagraph(EscherTextboxWrapper)</a></span> - Static method in class org.apache.poi.hslf.usermodel.<a href="./org/apache/poi/hslf/usermodel/HSLFTextParagraph.html" title="class in org.apache.poi.hslf.usermodel">HSLFTextParagraph</a></dt>
<dd> </dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#createEnclosingCellRange(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">createEnclosingCellRange(CellRangeAddress, CellRangeAddress)</a></span> - Static method in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#createEnclosingCellRange(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">createEnclosingCellRange(CellRangeAddress, CellRangeAddress)</a></span> - Static method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
<dd>
<div class="block">Create an enclosing CellRange for the two cell ranges.</div>
</dd>
@@ -13260,7 +13274,7 @@
<dd>
<div class="block">The PowerPoint magic number for an encrypted file</div>
</dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#ENCLOSES">ENCLOSES</a></span> - Static variable in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#ENCLOSES">ENCLOSES</a></span> - Static variable in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
<dd>
<div class="block">first range encloses or is equal to the second</div>
</dd>
@@ -42284,7 +42298,7 @@
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/hwpf/model/PicturesTable.html#hasEscherPicture(org.apache.poi.hwpf.usermodel.CharacterRun)">hasEscherPicture(CharacterRun)</a></span> - Method in class org.apache.poi.hwpf.model.<a href="./org/apache/poi/hwpf/model/PicturesTable.html" title="class in org.apache.poi.hwpf.model">PicturesTable</a></dt>
<dd> </dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#hasExactSharedBorder(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">hasExactSharedBorder(CellRangeAddress, CellRangeAddress)</a></span> - Static method in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#hasExactSharedBorder(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">hasExactSharedBorder(CellRangeAddress, CellRangeAddress)</a></span> - Static method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
<dd>
<div class="block">Check if the two cell ranges have a shared border.</div>
</dd>
@@ -44384,6 +44398,14 @@
<dd>
<div class="block">High level representation of a row of a spreadsheet.</div>
</dd>
+<dt><a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html" title="class in org.apache.poi.hssf.usermodel.helpers"><span class="strong">HSSFRowShifter</span></a> - Class in <a href="./org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a></dt>
+<dd>
+<div class="block">Helper for shifting rows up or down
+
+ When possible, code should be implemented in the RowShifter abstract class to avoid duplication with <a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers"><code>XSSFRowShifter</code></a></div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#HSSFRowShifter(org.apache.poi.hssf.usermodel.HSSFSheet)">HSSFRowShifter(HSSFSheet)</a></span> - Constructor for class org.apache.poi.hssf.usermodel.helpers.<a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html" title="class in org.apache.poi.hssf.usermodel.helpers">HSSFRowShifter</a></dt>
+<dd> </dd>
<dt><a href="./org/apache/poi/hssf/usermodel/HSSFShape.html" title="class in org.apache.poi.hssf.usermodel"><span class="strong">HSSFShape</span></a> - Class in <a href="./org/apache/poi/hssf/usermodel/package-summary.html">org.apache.poi.hssf.usermodel</a></dt>
<dd>
<div class="block">An abstract shape.</div>
@@ -46284,7 +46306,7 @@
<div class="block">Creates and initializes a new <code>Insets</code> object with the
specified top, left, bottom, and right insets.</div>
</dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#INSIDE">INSIDE</a></span> - Static variable in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#INSIDE">INSIDE</a></span> - Static variable in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
<dd>
<div class="block">first range is within the second range</div>
</dd>
@@ -46528,9 +46550,9 @@
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/hsmf/datatypes/MAPIProperty.html#INTERNET_REFERENCES">INTERNET_REFERENCES</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> </dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#intersect(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">intersect(CellRangeAddress, CellRangeAddress)</a></span> - Static method in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#intersect(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">intersect(CellRangeAddress, CellRangeAddress)</a></span> - Static method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
<dd>
-<div class="block">Intersect this range with the specified range.</div>
+<div class="block">Get the type of intersection between two cell ranges</div>
</dd>
<dt><a href="./org/apache/poi/ss/formula/eval/IntersectionEval.html" title="class in org.apache.poi.ss.formula.eval"><span class="strong">IntersectionEval</span></a> - Class in <a href="./org/apache/poi/ss/formula/eval/package-summary.html">org.apache.poi.ss.formula.eval</a></dt>
<dd> </dd>
@@ -52348,11 +52370,13 @@
</dd>
<dt><span class="strong"><a href="./org/apache/poi/openxml4j/opc/internal/MemoryPackagePartOutputStream.html#MemoryPackagePartOutputStream(org.apache.poi.openxml4j.opc.internal.MemoryPackagePart)">MemoryPackagePartOutputStream(MemoryPackagePart)</a></span> - Constructor for class org.apache.poi.openxml4j.opc.internal.<a href="./org/apache/poi/openxml4j/opc/internal/MemoryPackagePartOutputStream.html" title="class in org.apache.poi.openxml4j.opc.internal">MemoryPackagePartOutputStream</a></dt>
<dd> </dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#mergeCellRanges(org.apache.poi.ss.util.CellRangeAddress[])">mergeCellRanges(CellRangeAddress[])</a></span> - Static method in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#mergeCellRanges(org.apache.poi.ss.util.CellRangeAddress[])">mergeCellRanges(CellRangeAddress[])</a></span> - Static method in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
<dd>
-<div class="block">Do all possible cell merges between cells of the list so that:<br>
- if a cell range is completely inside of another cell range, it gets removed from the list
- if two cells have a shared border, merge them into one bigger cell range</div>
+<div class="block">Do all possible cell merges between cells of the list so that:<br/>
+
+ if a cell range is completely inside of another cell range, it gets removed from the list
+ if two cells have a shared border, merge them into one bigger cell range
+ </div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/xslf/usermodel/XSLFTable.html#mergeCells(int,%20int,%20int,%20int)">mergeCells(int, int, int, int)</a></span> - Method in class org.apache.poi.xslf.usermodel.<a href="./org/apache/poi/xslf/usermodel/XSLFTable.html" title="class in org.apache.poi.xslf.usermodel">XSLFTable</a></dt>
<dd>
@@ -53188,7 +53212,7 @@
<dd>
<div class="block">Place holder for indicating that NO_FONT has been applied here</div>
</dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#NO_INTERSECTION">NO_INTERSECTION</a></span> - Static variable in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#NO_INTERSECTION">NO_INTERSECTION</a></span> - Static variable in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/util/NumericRanges.html#NO_OVERLAPS">NO_OVERLAPS</a></span> - Static variable in class org.apache.poi.xssf.util.<a href="./org/apache/poi/xssf/util/NumericRanges.html" title="class in org.apache.poi.xssf.util">NumericRanges</a></dt>
<dd> </dd>
@@ -54735,6 +54759,8 @@
<dd>
<div class="block">usermodel package maps HSSF low level strutures to familiar workbook/sheet model</div>
</dd>
+<dt><a href="./org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a> - package org.apache.poi.hssf.usermodel.helpers</dt>
+<dd> </dd>
<dt><a href="./org/apache/poi/hssf/util/package-summary.html">org.apache.poi.hssf.util</a> - package org.apache.poi.hssf.util</dt>
<dd>
<div class="block">util package contains tools needed for writing HSSF files that are not necesarily "real"
@@ -54865,6 +54891,8 @@ Compound Document Format.</div>
<dd> </dd>
<dt><a href="./org/apache/poi/ss/usermodel/charts/package-summary.html">org.apache.poi.ss.usermodel.charts</a> - package org.apache.poi.ss.usermodel.charts</dt>
<dd> </dd>
+<dt><a href="./org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a> - package org.apache.poi.ss.usermodel.helpers</dt>
+<dd> </dd>
<dt><a href="./org/apache/poi/ss/util/package-summary.html">org.apache.poi.ss.util</a> - package org.apache.poi.ss.util</dt>
<dd> </dd>
<dt><a href="./org/apache/poi/ss/util/cellwalk/package-summary.html">org.apache.poi.ss.util.cellwalk</a> - package org.apache.poi.ss.util.cellwalk</dt>
@@ -55109,7 +55137,7 @@ Compound Document Format.</div>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/hslf/record/DocumentAtom.SlideSize.html#OVERHEAD">OVERHEAD</a></span> - Static variable in class org.apache.poi.hslf.record.<a href="./org/apache/poi/hslf/record/DocumentAtom.SlideSize.html" title="class in org.apache.poi.hslf.record">DocumentAtom.SlideSize</a></dt>
<dd> </dd>
-<dt><span class="strong"><a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html#OVERLAP">OVERLAP</a></span> - Static variable in class org.apache.poi.hssf.record.cf.<a href="./org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/ss/util/CellRangeUtil.html#OVERLAP">OVERLAP</a></span> - Static variable in class org.apache.poi.ss.util.<a href="./org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util">CellRangeUtil</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/util/NumericRanges.html#OVERLAPS_1_MINOR">OVERLAPS_1_MINOR</a></span> - Static variable in class org.apache.poi.xssf.util.<a href="./org/apache/poi/xssf/util/NumericRanges.html" title="class in org.apache.poi.xssf.util">NumericRanges</a></dt>
<dd> </dd>
@@ -60150,6 +60178,18 @@ Compound Document Format.</div>
<dd>
<div class="block">Removes a merged region of cells (hence letting them free)</div>
</dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFSheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions(Collection<Integer>)</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a></dt>
+<dd>
+<div class="block">Removes a number of merged regions of cells (hence letting them free)</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/Sheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions(Collection<Integer>)</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></dt>
+<dd>
+<div class="block">Removes a number of merged regions of cells (hence letting them free)</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions(Collection<Integer>)</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">Removes a merged region of cells (hence letting them free)</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFSheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions(Collection<Integer>)</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">Removes a number of merged regions of cells (hence letting them free)
@@ -61072,6 +61112,14 @@ Compound Document Format.</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/formula/functions/Rows.html#Rows()">Rows()</a></span> - Constructor for class org.apache.poi.ss.formula.functions.<a href="./org/apache/poi/ss/formula/functions/Rows.html" title="class in org.apache.poi.ss.formula.functions">Rows</a></dt>
<dd> </dd>
+<dt><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers"><span class="strong">RowShifter</span></a> - Class in <a href="./org/apache/poi/ss/usermodel/helpers/package-summary.html">org.apache.poi.ss.usermodel.helpers</a></dt>
+<dd>
+<div class="block">Helper for shifting rows up or down
+
+ This abstract class exists to consolidate duplicated code between XSSFRowShifter and HSSFRowShifter (currently methods sprinkled throughout HSSFSheet)</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#RowShifter(org.apache.poi.ss.usermodel.Sheet)">RowShifter(Sheet)</a></span> - Constructor for class org.apache.poi.ss.usermodel.helpers.<a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers">RowShifter</a></dt>
+<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/ShapeTypes.html#RT_TRIANGLE">RT_TRIANGLE</a></span> - Static variable in class org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/ShapeTypes.html" title="class in org.apache.poi.ss.usermodel">ShapeTypes</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/hsmf/datatypes/MAPIProperty.html#RTF_COMPRESSED">RTF_COMPRESSED</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>
@@ -76909,6 +76957,8 @@ Compound Document Format.</div>
<dd>
<div class="block">Common parent of Slides, Notes and Masters</div>
</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#sheet">sheet</a></span> - Variable in class org.apache.poi.ss.usermodel.helpers.<a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers">RowShifter</a></dt>
+<dd> </dd>
<dt><a href="./org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Sheet</span></a> - Interface in <a href="./org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></dt>
<dd>
<div class="block">High level representation of a Excel worksheet.</div>
@@ -77027,13 +77077,19 @@ Compound Document Format.</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFSheet.html#shiftMerged(int,%20int,%20int,%20boolean)">shiftMerged(int, int, int, boolean)</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a></dt>
<dd>
-<div class="block">Shifts the merged regions left or right depending on mode
- <p/>
- TODO: MODE , this is only row specific</div>
+<div class="block"><span class="strong">Deprecated.</span>
+<div class="block"><i>POI 3.15 beta 2. Use <a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#shiftMergedRegions(int,%20int,%20int)"><code>RowShifter.shiftMergedRegions(int, int, int)</code></a>.</i></div>
+</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#shiftMerged(int,%20int,%20int)">shiftMerged(int, int, int)</a></span> - Method in class org.apache.poi.xssf.usermodel.helpers.<a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers">XSSFRowShifter</a></dt>
<dd>
-<div class="block">Shift merged regions</div>
+<div class="block"><span class="strong">Deprecated.</span>
+<div class="block"><i>POI 3.15 beta 2. Use <a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#shiftMergedRegions(int,%20int,%20int)"><code>RowShifter.shiftMergedRegions(int, int, int)</code></a> instead.</i></div>
+</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#shiftMergedRegions(int,%20int,%20int)">shiftMergedRegions(int, int, int)</a></span> - Method in class org.apache.poi.ss.usermodel.helpers.<a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers">RowShifter</a></dt>
+<dd>
+<div class="block">Shifts, grows, or shrinks the merged regions due to a row shift</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/hssf/record/aggregates/PageSettingsBlock.html#shiftRowBreaks(int,%20int,%20int)">shiftRowBreaks(int, int, int)</a></span> - Method in class org.apache.poi.hssf.record.aggregates.<a href="./org/apache/poi/hssf/record/aggregates/PageSettingsBlock.html" title="class in org.apache.poi.hssf.record.aggregates">PageSettingsBlock</a></dt>
<dd>
@@ -83566,6 +83622,10 @@ Compound Document Format.</div>
<div class="block">Updates the cell record's idea of what
column it belongs in (0 based)</div>
</dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateConditionalFormatting(org.apache.poi.ss.formula.FormulaShifter)">updateConditionalFormatting(FormulaShifter)</a></span> - Method in class org.apache.poi.hssf.usermodel.helpers.<a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html" title="class in org.apache.poi.hssf.usermodel.helpers">HSSFRowShifter</a></dt>
+<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateConditionalFormatting(org.apache.poi.ss.formula.FormulaShifter)">updateConditionalFormatting(FormulaShifter)</a></span> - Method in class org.apache.poi.ss.usermodel.helpers.<a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers">RowShifter</a></dt>
+<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateConditionalFormatting(org.apache.poi.ss.formula.FormulaShifter)">updateConditionalFormatting(FormulaShifter)</a></span> - Method in class org.apache.poi.xssf.usermodel.helpers.<a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers">XSSFRowShifter</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/poifs/filesystem/NPOIFSStream.html#updateContents(byte[])">updateContents(byte[])</a></span> - Method in class org.apache.poi.poifs.filesystem.<a href="./org/apache/poi/poifs/filesystem/NPOIFSStream.html" title="class in org.apache.poi.poifs.filesystem">NPOIFSStream</a></dt>
@@ -83577,6 +83637,12 @@ Compound Document Format.</div>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/hslf/usermodel/HSLFSlideShowEncrypted.html#updateEncryptionRecord(org.apache.poi.hslf.record.Record[])">updateEncryptionRecord(Record[])</a></span> - Method in class org.apache.poi.hslf.usermodel.<a href="./org/apache/poi/hslf/usermodel/HSLFSlideShowEncrypted.html" title="class in org.apache.poi.hslf.usermodel">HSLFSlideShowEncrypted</a></dt>
<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateFormulas(org.apache.poi.ss.formula.FormulaShifter)">updateFormulas(FormulaShifter)</a></span> - Method in class org.apache.poi.hssf.usermodel.helpers.<a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html" title="class in org.apache.poi.hssf.usermodel.helpers">HSSFRowShifter</a></dt>
+<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateFormulas(org.apache.poi.ss.formula.FormulaShifter)">updateFormulas(FormulaShifter)</a></span> - Method in class org.apache.poi.ss.usermodel.helpers.<a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers">RowShifter</a></dt>
+<dd>
+<div class="block">Update formulas.</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateFormulas(org.apache.poi.ss.formula.FormulaShifter)">updateFormulas(FormulaShifter)</a></span> - Method in class org.apache.poi.xssf.usermodel.helpers.<a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers">XSSFRowShifter</a></dt>
<dd>
<div class="block">Update formulas.</div>
@@ -83597,6 +83663,13 @@ Compound Document Format.</div>
<dd>
<div class="block">Synchronize table headers with cell values in the parent sheet.</div>
</dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateHyperlinks(org.apache.poi.ss.formula.FormulaShifter)">updateHyperlinks(FormulaShifter)</a></span> - Method in class org.apache.poi.hssf.usermodel.helpers.<a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html" title="class in org.apache.poi.hssf.usermodel.helpers">HSSFRowShifter</a></dt>
+<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateHyperlinks(org.apache.poi.ss.formula.FormulaShifter)">updateHyperlinks(FormulaShifter)</a></span> - Method in class org.apache.poi.ss.usermodel.helpers.<a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers">RowShifter</a></dt>
+<dd>
+<div class="block">Shift the Hyperlink anchors (not the hyperlink text, even if the hyperlink
+ is of type LINK_DOCUMENT and refers to a cell that was shifted).</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateHyperlinks(org.apache.poi.ss.formula.FormulaShifter)">updateHyperlinks(FormulaShifter)</a></span> - Method in class org.apache.poi.xssf.usermodel.helpers.<a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers">XSSFRowShifter</a></dt>
<dd>
<div class="block">Shift the Hyperlink anchors (not the hyperlink text, even if the hyperlink
@@ -83612,6 +83685,12 @@ Compound Document Format.</div>
<div class="block">If a <a href="./org/apache/poi/hssf/record/NameCommentRecord.html" title="class in org.apache.poi.hssf.record"><code>NameCommentRecord</code></a> is added or the name it references
is renamed, then this will update the lookup cache for it.</div>
</dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateNamedRanges(org.apache.poi.ss.formula.FormulaShifter)">updateNamedRanges(FormulaShifter)</a></span> - Method in class org.apache.poi.hssf.usermodel.helpers.<a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html" title="class in org.apache.poi.hssf.usermodel.helpers">HSSFRowShifter</a></dt>
+<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateNamedRanges(org.apache.poi.ss.formula.FormulaShifter)">updateNamedRanges(FormulaShifter)</a></span> - Method in class org.apache.poi.ss.usermodel.helpers.<a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers">RowShifter</a></dt>
+<dd>
+<div class="block">Updated named ranges</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateNamedRanges(org.apache.poi.ss.formula.FormulaShifter)">updateNamedRanges(FormulaShifter)</a></span> - Method in class org.apache.poi.xssf.usermodel.helpers.<a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers">XSSFRowShifter</a></dt>
<dd>
<div class="block">Updated named ranges</div>
@@ -83648,7 +83727,13 @@ Compound Document Format.</div>
<div class="block">At write-out time, update the references to PersistPtrs and
other UserEditAtoms to point to their new positions</div>
</dd>
-<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateRowFormulas(org.apache.poi.xssf.usermodel.XSSFRow,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas(XSSFRow, FormulaShifter)</a></span> - Method in class org.apache.poi.xssf.usermodel.helpers.<a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers">XSSFRowShifter</a></dt>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas(Row, FormulaShifter)</a></span> - Method in class org.apache.poi.hssf.usermodel.helpers.<a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html" title="class in org.apache.poi.hssf.usermodel.helpers">HSSFRowShifter</a></dt>
+<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas(Row, FormulaShifter)</a></span> - Method in class org.apache.poi.ss.usermodel.helpers.<a href="./org/apache/poi/ss/usermodel/helpers/RowShifter.html" title="class in org.apache.poi.ss.usermodel.helpers">RowShifter</a></dt>
+<dd>
+<div class="block">Update the formulas in specified row using the formula shifting policy specified by shifter</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#updateRowFormulas(org.apache.poi.ss.usermodel.Row,%20org.apache.poi.ss.formula.FormulaShifter)">updateRowFormulas(Row, FormulaShifter)</a></span> - Method in class org.apache.poi.xssf.usermodel.helpers.<a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers">XSSFRowShifter</a></dt>
<dd>
<div class="block">Update the formulas in specified row using the formula shifting policy specified by shifter</div>
</dd>
@@ -87985,13 +88070,17 @@ the order they are declared.</div>
<dt><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">XSSFDataValidationConstraint</span></a> - Class in <a href="./org/apache/poi/xssf/usermodel/package-summary.html">org.apache.poi.xssf.usermodel</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#XSSFDataValidationConstraint(java.lang.String[])">XSSFDataValidationConstraint(String[])</a></span> - Constructor for class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidationConstraint</a></dt>
-<dd> </dd>
+<dd>
+<div class="block">list literal constructor</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#XSSFDataValidationConstraint(int,%20java.lang.String)">XSSFDataValidationConstraint(int, String)</a></span> - Constructor for class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidationConstraint</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#XSSFDataValidationConstraint(int,%20int,%20java.lang.String)">XSSFDataValidationConstraint(int, int, String)</a></span> - Constructor for class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidationConstraint</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#XSSFDataValidationConstraint(int,%20int,%20java.lang.String,%20java.lang.String)">XSSFDataValidationConstraint(int, int, String, String)</a></span> - Constructor for class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidationConstraint</a></dt>
-<dd> </dd>
+<dd>
+<div class="block">This is the constructor called using the OOXML raw data.</div>
+</dd>
<dt><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationHelper.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">XSSFDataValidationHelper</span></a> - Class in <a href="./org/apache/poi/xssf/usermodel/package-summary.html">org.apache.poi.xssf.usermodel</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationHelper.html#XSSFDataValidationHelper(org.apache.poi.xssf.usermodel.XSSFSheet)">XSSFDataValidationHelper(XSSFSheet)</a></span> - Constructor for class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataValidationHelper.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidationHelper</a></dt>
@@ -88375,7 +88464,9 @@ the order they are declared.</div>
</dd>
<dt><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers"><span class="strong">XSSFRowShifter</span></a> - Class in <a href="./org/apache/poi/xssf/usermodel/helpers/package-summary.html">org.apache.poi.xssf.usermodel.helpers</a></dt>
<dd>
-<div class="block">Helper for shifting rows up or down</div>
+<div class="block">Helper for shifting rows up or down
+
+ When possible, code should be implemented in the RowShifter abstract class to avoid duplication with <a href="./org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html" title="class in org.apache.poi.hssf.usermodel.helpers"><code>HSSFRowShifter</code></a></div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html#XSSFRowShifter(org.apache.poi.xssf.usermodel.XSSFSheet)">XSSFRowShifter(XSSFSheet)</a></span> - Constructor for class org.apache.poi.xssf.usermodel.helpers.<a href="./org/apache/poi/xssf/usermodel/helpers/XSSFRowShifter.html" title="class in org.apache.poi.xssf.usermodel.helpers">XSSFRowShifter</a></dt>
<dd> </dd>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/BorderFormatting.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/BorderFormatting.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/BorderFormatting.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/BorderFormatting.html Mon Jun 20 09:13:46 2016
@@ -35,7 +35,7 @@
<div class="subNav">
<ul class="navList">
<li>Prev Class</li>
-<li><a href="../../../../../../org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Next Class</span></a></li>
+<li><a href="../../../../../../org/apache/poi/hssf/record/cf/ColorGradientFormatting.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Next Class</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../../index.html?org/apache/poi/hssf/record/cf/BorderFormatting.html" target="_top">Frames</a></li>
@@ -1086,7 +1086,7 @@ implements java.lang.Cloneable</pre>
<div class="subNav">
<ul class="navList">
<li>Prev Class</li>
-<li><a href="../../../../../../org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Next Class</span></a></li>
+<li><a href="../../../../../../org/apache/poi/hssf/record/cf/ColorGradientFormatting.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Next Class</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../../index.html?org/apache/poi/hssf/record/cf/BorderFormatting.html" target="_top">Frames</a></li>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/ColorGradientFormatting.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/ColorGradientFormatting.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/ColorGradientFormatting.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/ColorGradientFormatting.html Mon Jun 20 09:13:46 2016
@@ -34,7 +34,7 @@
</div>
<div class="subNav">
<ul class="navList">
-<li><a href="../../../../../../org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../../org/apache/poi/hssf/record/cf/BorderFormatting.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Prev Class</span></a></li>
<li><a href="../../../../../../org/apache/poi/hssf/record/cf/ColorGradientThreshold.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Next Class</span></a></li>
</ul>
<ul class="navList">
@@ -380,7 +380,7 @@ implements java.lang.Cloneable</pre>
</div>
<div class="subNav">
<ul class="navList">
-<li><a href="../../../../../../org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../../org/apache/poi/hssf/record/cf/BorderFormatting.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Prev Class</span></a></li>
<li><a href="../../../../../../org/apache/poi/hssf/record/cf/ColorGradientThreshold.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">Next Class</span></a></li>
</ul>
<ul class="navList">
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-frame.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-frame.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-frame.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-frame.html Mon Jun 20 09:13:46 2016
@@ -11,7 +11,6 @@
<h2 title="Classes">Classes</h2>
<ul title="Classes">
<li><a href="BorderFormatting.html" title="class in org.apache.poi.hssf.record.cf" target="classFrame">BorderFormatting</a></li>
-<li><a href="CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf" target="classFrame">CellRangeUtil</a></li>
<li><a href="ColorGradientFormatting.html" title="class in org.apache.poi.hssf.record.cf" target="classFrame">ColorGradientFormatting</a></li>
<li><a href="ColorGradientThreshold.html" title="class in org.apache.poi.hssf.record.cf" target="classFrame">ColorGradientThreshold</a></li>
<li><a href="DataBarFormatting.html" title="class in org.apache.poi.hssf.record.cf" target="classFrame">DataBarFormatting</a></li>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-summary.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-summary.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-summary.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-summary.html Mon Jun 20 09:13:46 2016
@@ -80,63 +80,57 @@
</td>
</tr>
<tr class="rowColor">
-<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf">CellRangeUtil</a></td>
-<td class="colLast">
-<div class="block">TODO Should this move to org.apache.poi.ss.util ?</div>
-</td>
-</tr>
-<tr class="altColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/ColorGradientFormatting.html" title="class in org.apache.poi.hssf.record.cf">ColorGradientFormatting</a></td>
<td class="colLast">
<div class="block">Color Gradient / Color Scale Conditional Formatting Rule Record.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/ColorGradientThreshold.html" title="class in org.apache.poi.hssf.record.cf">ColorGradientThreshold</a></td>
<td class="colLast">
<div class="block">Color Gradient / Color Scale specific Threshold / value (CFVO),
for changes in Conditional Formatting</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/DataBarFormatting.html" title="class in org.apache.poi.hssf.record.cf">DataBarFormatting</a></td>
<td class="colLast">
<div class="block">Data Bar Conditional Formatting Rule Record.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/DataBarThreshold.html" title="class in org.apache.poi.hssf.record.cf">DataBarThreshold</a></td>
<td class="colLast">
<div class="block">Data Bar specific Threshold / value (CFVO),
for changes in Conditional Formatting</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/FontFormatting.html" title="class in org.apache.poi.hssf.record.cf">FontFormatting</a></td>
<td class="colLast">
<div class="block">Font Formatting Block of the Conditional Formatting Rule Record.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/IconMultiStateFormatting.html" title="class in org.apache.poi.hssf.record.cf">IconMultiStateFormatting</a></td>
<td class="colLast">
<div class="block">Icon / Multi-State Conditional Formatting Rule Record.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/IconMultiStateThreshold.html" title="class in org.apache.poi.hssf.record.cf">IconMultiStateThreshold</a></td>
<td class="colLast">
<div class="block">Icon / Multi-State specific Threshold / value (CFVO),
for changes in Conditional Formatting</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/PatternFormatting.html" title="class in org.apache.poi.hssf.record.cf">PatternFormatting</a></td>
<td class="colLast">
<div class="block">Pattern Formatting Block of the Conditional Formatting Rule Record.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><a href="../../../../../../org/apache/poi/hssf/record/cf/Threshold.html" title="class in org.apache.poi.hssf.record.cf">Threshold</a></td>
<td class="colLast">
<div class="block">Threshold / value (CFVO) for changes in Conditional Formatting</div>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-tree.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-tree.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/record/cf/package-tree.html Mon Jun 20 09:13:46 2016
@@ -73,7 +73,6 @@
<li type="circle">java.lang.Object
<ul>
<li type="circle">org.apache.poi.hssf.record.cf.<a href="../../../../../../org/apache/poi/hssf/record/cf/BorderFormatting.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">BorderFormatting</span></a> (implements java.lang.Cloneable)</li>
-<li type="circle">org.apache.poi.hssf.record.cf.<a href="../../../../../../org/apache/poi/hssf/record/cf/CellRangeUtil.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">CellRangeUtil</span></a></li>
<li type="circle">org.apache.poi.hssf.record.cf.<a href="../../../../../../org/apache/poi/hssf/record/cf/ColorGradientFormatting.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">ColorGradientFormatting</span></a> (implements java.lang.Cloneable)</li>
<li type="circle">org.apache.poi.hssf.record.cf.<a href="../../../../../../org/apache/poi/hssf/record/cf/DataBarFormatting.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">DataBarFormatting</span></a> (implements java.lang.Cloneable)</li>
<li type="circle">org.apache.poi.hssf.record.cf.<a href="../../../../../../org/apache/poi/hssf/record/cf/FontFormatting.html" title="class in org.apache.poi.hssf.record.cf"><span class="strong">FontFormatting</span></a> (implements java.lang.Cloneable)</li>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html Mon Jun 20 09:13:46 2016
@@ -741,86 +741,92 @@ implements <a href="../../../../../org/a
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions</a></strong>(java.util.Collection<java.lang.Integer> indices)</code>
+<div class="block">Removes a number of merged regions of cells (hence letting them free)</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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> 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/hssf/usermodel/HSSFSheet.html#removeRowBreak(int)">removeRowBreak</a></strong>(int 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<<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.html#setActive(boolean)">setActive</a></strong>(boolean sel)</code>
<div class="block">Sets whether sheet is selected.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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> address)</code>
<div class="block">Sets location of the active cell</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setAlternativeExpression(boolean)">setAlternativeExpression</a></strong>(boolean b)</code>
<div class="block">whether alternate expression evaluation is on</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/hssf/usermodel/HSSFSheet.html#setAlternativeFormula(boolean)">setAlternativeFormula</a></strong>(boolean b)</code>
<div class="block">whether alternative formula entry is on</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a><<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html" title="class in org.apache.poi.hssf.usermodel">HSSFCell</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setArrayFormula(java.lang.String,%20org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a></strong>(java.lang.String formula,
<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range)</code>
<div class="block">Sets array formula to specified region for result.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setAutobreaks(boolean)">setAutobreaks</a></strong>(boolean b)</code>
<div class="block">show automatic page breaks or not</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFAutoFilter.html" title="class in org.apache.poi.hssf.usermodel">HSSFAutoFilter</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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> range)</code>
<div class="block">Enable filtering for a range of cells</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnBreak(int)">setColumnBreak</a></strong>(int column)</code>
<div class="block">Sets a page break at the indicated column.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnGroupCollapsed(int,%20boolean)">setColumnGroupCollapsed</a></strong>(int columnNumber,
boolean collapsed)</code>
<div class="block">Expands or collapses a column group.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnHidden(int,%20boolean)">setColumnHidden</a></strong>(int columnIndex,
boolean hidden)</code>
<div class="block">Get the visibility state for a given column.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnWidth(int,%20int)">setColumnWidth</a></strong>(int columnIndex,
int width)</code>
@@ -828,179 +834,179 @@ implements <a href="../../../../../org/a
<p/></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/hssf/usermodel/HSSFSheet.html#setDefaultColumnStyle(int,%20org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a></strong>(int column,
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a> style)</code>
<div class="block">Sets the default column style for a given column.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a></strong>(int width)</code>
<div class="block">set the default column width for the sheet (if the columns do not define their own width) in
characters</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDefaultRowHeight(short)">setDefaultRowHeight</a></strong>(short height)</code>
<div class="block">set the default row height for the sheet (if the rows do not define their own height) in
twips (1/20 of a point)</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a></strong>(float height)</code>
<div class="block">set the default row height for the sheet (if the rows do not define their own height) in
points</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDialog(boolean)">setDialog</a></strong>(boolean b)</code>
<div class="block">set whether sheet is a dialog sheet or not</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a></strong>(boolean 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/hssf/usermodel/HSSFSheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></strong>(boolean 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/hssf/usermodel/HSSFSheet.html#setDisplayGuts(boolean)">setDisplayGuts</a></strong>(boolean b)</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/hssf/usermodel/HSSFSheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></strong>(boolean 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/hssf/usermodel/HSSFSheet.html#setDisplayZeros(boolean)">setDisplayZeros</a></strong>(boolean 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/hssf/usermodel/HSSFSheet.html#setFitToPage(boolean)">setFitToPage</a></strong>(boolean b)</code>
<div class="block">fit to page option is on</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/hssf/usermodel/HSSFSheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code>
<div class="block">Control if Excel should be asked to recalculate all formulas on this sheet
when the workbook is opened.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setGridsPrinted(boolean)">setGridsPrinted</a></strong>(boolean value)</code>
<div class="block">set whether gridlines printed.</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/hssf/usermodel/HSSFSheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></strong>(boolean value)</code>
<div class="block">determines whether the output is horizontally centered on the page.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setMargin(short,%20double)">setMargin</a></strong>(short margin,
double size)</code>
<div class="block">Sets the size of the margin in inches.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></strong>(boolean show)</code>
<div class="block">Turns on or off the printing of gridlines.</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/hssf/usermodel/HSSFSheet.html#setPrintRowAndColumnHeadings(boolean)">setPrintRowAndColumnHeadings</a></strong>(boolean show)</code>
<div class="block">Turns on or off the printing of row and column headings.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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> columnRangeRef)</code>
<div class="block">Sets the repeating columns used when printing the sheet, as found in
File->PageSetup->Sheet.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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> rowRangeRef)</code>
<div class="block">Sets the repeating rows used when printing the sheet, as found in
File->PageSetup->Sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRightToLeft(boolean)">setRightToLeft</a></strong>(boolean 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/hssf/usermodel/HSSFSheet.html#setRowBreak(int)">setRowBreak</a></strong>(int row)</code>
<div class="block">Sets a page break at the indicated row
Breaks occur above the specified row and left of the specified column inclusive.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int rowIndex,
boolean 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/hssf/usermodel/HSSFSheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a></strong>(boolean b)</code>
<div class="block">set if row summaries appear below detail in the 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/hssf/usermodel/HSSFSheet.html#setRowSumsRight(boolean)">setRowSumsRight</a></strong>(boolean b)</code>
<div class="block">set if col summaries appear right of the detail in the 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/hssf/usermodel/HSSFSheet.html#setSelected(boolean)">setSelected</a></strong>(boolean sel)</code>
<div class="block">Sets whether sheet is selected.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a></strong>(boolean value)</code>
<div class="block">determines whether the output is vertically centered on the page.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setZoom(int)">setZoom</a></strong>(int scale)</code>
<div class="block">Window zoom magnification for current view representing percent values.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setZoom(int,%20int)">setZoom</a></strong>(int numerator,
int denominator)</code>
@@ -1009,18 +1015,18 @@ implements <a href="../../../../../org/a
</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/hssf/usermodel/HSSFSheet.html#shiftMerged(int,%20int,%20int,%20boolean)">shiftMerged</a></strong>(int startRow,
int endRow,
int n,
boolean isRow)</code>
-<div class="block">Shifts the merged regions left or right depending on mode
- <p/>
- TODO: MODE , this is only row specific</div>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#shiftMergedRegions(int,%20int,%20int)"><code>RowShifter.shiftMergedRegions(int, int, int)</code></a>.</i></div>
+</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/hssf/usermodel/HSSFSheet.html#shiftRows(int,%20int,%20int)">shiftRows</a></strong>(int startRow,
int endRow,
@@ -1028,7 +1034,7 @@ implements <a href="../../../../../org/a
<div class="block">Shifts rows between startRow and endRow n number of rows.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a></strong>(int startRow,
int endRow,
@@ -1038,7 +1044,7 @@ implements <a href="../../../../../org/a
<div class="block">Shifts rows between startRow and endRow n number of rows.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean,%20boolean)">shiftRows</a></strong>(int startRow,
int endRow,
@@ -1049,7 +1055,7 @@ implements <a href="../../../../../org/a
<div class="block">Shifts rows between startRow and endRow n number of rows.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#showInPane(int,%20int)">showInPane</a></strong>(int toprow,
int leftcol)</code>
@@ -1057,34 +1063,34 @@ implements <a href="../../../../../org/a
file is first opened in a viewer.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#ungroupColumn(int,%20int)">ungroupColumn</a></strong>(int fromColumn,
int toColumn)</code>
<div class="block">Ungroup a range of columns that were previously grouped</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#ungroupRow(int,%20int)">ungroupRow</a></strong>(int fromRow,
int toRow)</code>
<div class="block">Ungroup a range of rows that were previously grouped</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#validateColumn(int)">validateColumn</a></strong>(int column)</code>
<div class="block">Runs a bounds check for column numbers</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/hssf/usermodel/HSSFSheet.html#validateMergedRegions()">validateMergedRegions</a></strong>()</code>
<div class="block">Verify that merged regions do not intersect multi-cell array formulas and
no merged regions intersect another merged region in this sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#validateRow(int)">validateRow</a></strong>(int row)</code>
<div class="block">Runs a bounds check for row numbers</div>
@@ -1781,6 +1787,20 @@ implements <a href="../../../../../org/a
<dt><span class="strong">Parameters:</span></dt><dd><code>index</code> - of the region to unmerge</dd></dl>
</li>
</ul>
+<a name="removeMergedRegions(java.util.Collection)">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>removeMergedRegions</h4>
+<pre>public void removeMergedRegions(java.util.Collection<java.lang.Integer> indices)</pre>
+<div class="block">Removes a number of merged regions of cells (hence letting them free)</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
+<dt><span class="strong">Parameters:</span></dt><dd><code>indices</code> - A set of the regions to unmerge</dd></dl>
+</li>
+</ul>
<a name="getNumMergedRegions()">
<!-- -->
</a>
@@ -2449,9 +2469,8 @@ implements <a href="../../../../../org/a
int endRow,
int n,
boolean isRow)</pre>
-<div class="block">Shifts the merged regions left or right depending on mode
- <p/>
- TODO: MODE , this is only row specific</div>
+<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/helpers/RowShifter.html#shiftMergedRegions(int,%20int,%20int)"><code>RowShifter.shiftMergedRegions(int, int, int)</code></a>.</i></div>
+<div class="block">Shifts, grows, or shrinks the merged regions due to a row shift</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>startRow</code> - the start-index of the rows to shift, zero-based</dd><dd><code>endRow</code> - the end-index of the rows to shift, zero-based</dd><dd><code>n</code> - how far to shift, negative to shift up</dd><dd><code>isRow</code> - unused, kept for backwards compatibility</dd></dl>
</li>
</ul>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/class-use/HSSFSheet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/class-use/HSSFSheet.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/class-use/HSSFSheet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/class-use/HSSFSheet.html Mon Jun 20 09:13:46 2016
@@ -90,6 +90,10 @@
</td>
</tr>
<tr class="rowColor">
+<td class="colFirst"><a href="#org.apache.poi.hssf.usermodel.helpers">org.apache.poi.hssf.usermodel.helpers</a></td>
+<td class="colLast"> </td>
+</tr>
+<tr class="altColor">
<td class="colFirst"><a href="#org.apache.poi.hssf.util">org.apache.poi.hssf.util</a></td>
<td class="colLast">
<div class="block">util package contains tools needed for writing HSSF files that are not necesarily "real"
@@ -423,6 +427,22 @@ HSSF concepts.</div>
</tr>
</tbody>
</table>
+</li>
+<li class="blockList"><a name="org.apache.poi.hssf.usermodel.helpers">
+<!-- -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a> in <a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing constructors, and an explanation">
+<caption><span>Constructors in <a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a> with parameters of type <a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a></span><span class="tabEnd"> </span></caption>
+<tr>
+<th class="colOne" scope="col">Constructor and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/helpers/HSSFRowShifter.html#HSSFRowShifter(org.apache.poi.hssf.usermodel.HSSFSheet)">HSSFRowShifter</a></strong>(<a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a> sh)</code> </td>
+</tr>
+</tbody>
+</table>
</li>
<li class="blockList"><a name="org.apache.poi.hssf.util">
<!-- -->
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-summary.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-summary.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-summary.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-summary.html Mon Jun 20 09:13:46 2016
@@ -35,7 +35,7 @@
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/hssf/record/pivottable/package-summary.html">Prev Package</a></li>
-<li><a href="../../../../../org/apache/poi/hssf/util/package-summary.html">Next Package</a></li>
+<li><a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">Next Package</a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/hssf/usermodel/package-summary.html" target="_top">Frames</a></li>
@@ -507,7 +507,7 @@ For overviews, tutorials, examples, guid
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/hssf/record/pivottable/package-summary.html">Prev Package</a></li>
-<li><a href="../../../../../org/apache/poi/hssf/util/package-summary.html">Next Package</a></li>
+<li><a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">Next Package</a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/hssf/usermodel/package-summary.html" target="_top">Frames</a></li>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-tree.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-tree.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-tree.html Mon Jun 20 09:13:46 2016
@@ -35,7 +35,7 @@
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/hssf/record/pivottable/package-tree.html">Prev</a></li>
-<li><a href="../../../../../org/apache/poi/hssf/util/package-tree.html">Next</a></li>
+<li><a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-tree.html">Next</a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/hssf/usermodel/package-tree.html" target="_top">Frames</a></li>
@@ -217,7 +217,7 @@
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/hssf/record/pivottable/package-tree.html">Prev</a></li>
-<li><a href="../../../../../org/apache/poi/hssf/util/package-tree.html">Next</a></li>
+<li><a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-tree.html">Next</a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/hssf/usermodel/package-tree.html" target="_top">Frames</a></li>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-use.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-use.html?rev=1749281&r1=1749280&r2=1749281&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-use.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/package-use.html Mon Jun 20 09:13:46 2016
@@ -106,6 +106,10 @@
</td>
</tr>
<tr class="altColor">
+<td class="colFirst"><a href="#org.apache.poi.hssf.usermodel.helpers">org.apache.poi.hssf.usermodel.helpers</a></td>
+<td class="colLast"> </td>
+</tr>
+<tr class="rowColor">
<td class="colFirst"><a href="#org.apache.poi.hssf.util">org.apache.poi.hssf.util</a></td>
<td class="colLast">
<div class="block">util package contains tools needed for writing HSSF files that are not necesarily "real"
@@ -527,6 +531,23 @@ HSSF concepts.</div>
</td>
</tr>
</tbody>
+</table>
+</li>
+<li class="blockList"><a name="org.apache.poi.hssf.usermodel.helpers">
+<!-- -->
+</a>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing classes, and an explanation">
+<caption><span>Classes in <a href="../../../../../org/apache/poi/hssf/usermodel/package-summary.html">org.apache.poi.hssf.usermodel</a> used by <a href="../../../../../org/apache/poi/hssf/usermodel/helpers/package-summary.html">org.apache.poi.hssf.usermodel.helpers</a></span><span class="tabEnd"> </span></caption>
+<tr>
+<th class="colOne" scope="col">Class and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/hssf/usermodel/class-use/HSSFSheet.html#org.apache.poi.hssf.usermodel.helpers">HSSFSheet</a>
+<div class="block">High level representation of a worksheet.</div>
+</td>
+</tr>
+</tbody>
</table>
</li>
<li class="blockList"><a name="org.apache.poi.hssf.util">
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org