Modified: poi/site/publish/apidocs/org/apache/poi/hwpf/HWPFDocumentCore.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hwpf/HWPFDocumentCore.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/hwpf/HWPFDocumentCore.html (original) +++ poi/site/publish/apidocs/org/apache/poi/hwpf/HWPFDocumentCore.html Tue Mar 22 10:23:19 2016 @@ -318,7 +318,7 @@ extends <a href="../../../../org/apache/ <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../org/apache/poi/poifs/filesystem/POIFSFileSystem.html" title="class in org.apache.poi.poifs.filesystem">POIFSFileSystem</a></code></td> <td class="colLast"><code><strong><a href="../../../../org/apache/poi/hwpf/HWPFDocumentCore.html#verifyAndBuildPOIFS(java.io.InputStream)">verifyAndBuildPOIFS</a></strong>(java.io.InputStream istream)</code> -<div class="block">Takens an InputStream, verifies that it's not RTF or PDF, builds a +<div class="block">Takes an InputStream, verifies that it's not RTF or PDF, builds a POIFSFileSystem from it, and returns that.</div> </td> </tr> @@ -541,7 +541,7 @@ extends <a href="../../../../org/apache/ <h4>verifyAndBuildPOIFS</h4> <pre>public static <a href="../../../../org/apache/poi/poifs/filesystem/POIFSFileSystem.html" title="class in org.apache.poi.poifs.filesystem">POIFSFileSystem</a> verifyAndBuildPOIFS(java.io.InputStream istream) throws java.io.IOException</pre> -<div class="block">Takens an InputStream, verifies that it's not RTF or PDF, builds a +<div class="block">Takes an InputStream, verifies that it's not RTF or PDF, builds a POIFSFileSystem from it, and returns that.</div> <dl><dt><span class="strong">Throws:</span></dt> <dd><code>java.io.IOException</code></dd></dl>
Modified: poi/site/publish/apidocs/org/apache/poi/openxml4j/exceptions/class-use/InvalidFormatException.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/openxml4j/exceptions/class-use/InvalidFormatException.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/openxml4j/exceptions/class-use/InvalidFormatException.html (original) +++ poi/site/publish/apidocs/org/apache/poi/openxml4j/exceptions/class-use/InvalidFormatException.html Tue Mar 22 10:23:19 2016 @@ -167,35 +167,12 @@ <tbody> <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/POITextExtractor.html" title="class in org.apache.poi">POITextExtractor</a></code></td> -<td class="colLast"><span class="strong">ExtractorFactory.</span><code><strong><a href="../../../../../../org/apache/poi/extractor/ExtractorFactory.html#createExtractor(org.apache.poi.poifs.filesystem.DirectoryNode)">createExtractor</a></strong>(<a href="../../../../../../org/apache/poi/poifs/filesystem/DirectoryNode.html" title="class in org.apache.poi.poifs.filesystem">DirectoryNode</a> poifsDir)</code> </td> -</tr> -<tr class="rowColor"> -<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/POITextExtractor.html" title="class in org.apache.poi">POITextExtractor</a></code></td> <td class="colLast"><span class="strong">ExtractorFactory.</span><code><strong><a href="../../../../../../org/apache/poi/extractor/ExtractorFactory.html#createExtractor(java.io.File)">createExtractor</a></strong>(java.io.File f)</code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/POITextExtractor.html" title="class in org.apache.poi">POITextExtractor</a></code></td> <td class="colLast"><span class="strong">ExtractorFactory.</span><code><strong><a href="../../../../../../org/apache/poi/extractor/ExtractorFactory.html#createExtractor(java.io.InputStream)">createExtractor</a></strong>(java.io.InputStream inp)</code> </td> </tr> -<tr class="rowColor"> -<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/POIOLE2TextExtractor.html" title="class in org.apache.poi">POIOLE2TextExtractor</a></code></td> -<td class="colLast"><span class="strong">ExtractorFactory.</span><code><strong><a href="../../../../../../org/apache/poi/extractor/ExtractorFactory.html#createExtractor(org.apache.poi.poifs.filesystem.NPOIFSFileSystem)">createExtractor</a></strong>(<a href="../../../../../../org/apache/poi/poifs/filesystem/NPOIFSFileSystem.html" title="class in org.apache.poi.poifs.filesystem">NPOIFSFileSystem</a> fs)</code> </td> -</tr> -<tr class="altColor"> -<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/POIOLE2TextExtractor.html" title="class in org.apache.poi">POIOLE2TextExtractor</a></code></td> -<td class="colLast"><span class="strong">ExtractorFactory.</span><code><strong><a href="../../../../../../org/apache/poi/extractor/ExtractorFactory.html#createExtractor(org.apache.poi.poifs.filesystem.OPOIFSFileSystem)">createExtractor</a></strong>(<a href="../../../../../../org/apache/poi/poifs/filesystem/OPOIFSFileSystem.html" title="class in org.apache.poi.poifs.filesystem">OPOIFSFileSystem</a> fs)</code> </td> -</tr> -<tr class="rowColor"> -<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/POIOLE2TextExtractor.html" title="class in org.apache.poi">POIOLE2TextExtractor</a></code></td> -<td class="colLast"><span class="strong">ExtractorFactory.</span><code><strong><a href="../../../../../../org/apache/poi/extractor/ExtractorFactory.html#createExtractor(org.apache.poi.poifs.filesystem.POIFSFileSystem)">createExtractor</a></strong>(<a href="../../../../../../org/apache/poi/poifs/filesystem/POIFSFileSystem.html" title="class in org.apache.poi.poifs.filesystem">POIFSFileSystem</a> fs)</code> </td> -</tr> -<tr class="altColor"> -<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/POITextExtractor.html" title="class in org.apache.poi">POITextExtractor</a>[]</code></td> -<td class="colLast"><span class="strong">ExtractorFactory.</span><code><strong><a href="../../../../../../org/apache/poi/extractor/ExtractorFactory.html#getEmbededDocsTextExtractors(org.apache.poi.POIOLE2TextExtractor)">getEmbededDocsTextExtractors</a></strong>(<a href="../../../../../../org/apache/poi/POIOLE2TextExtractor.html" title="class in org.apache.poi">POIOLE2TextExtractor</a> ext)</code> -<div class="block">Returns an array of text extractors, one for each of - the embedded documents in the file (if there are any).</div> -</td> -</tr> </tbody> </table> </li> Modified: poi/site/publish/apidocs/org/apache/poi/poifs/dev/POIFSDump.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/poifs/dev/POIFSDump.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/poifs/dev/POIFSDump.html (original) +++ poi/site/publish/apidocs/org/apache/poi/poifs/dev/POIFSDump.html Tue Mar 22 10:23:19 2016 @@ -194,9 +194,9 @@ extends java.lang.Object</pre> <li class="blockList"> <h4>main</h4> <pre>public static void main(java.lang.String[] args) - throws java.lang.Exception</pre> + throws java.io.IOException</pre> <dl><dt><span class="strong">Throws:</span></dt> -<dd><code>java.lang.Exception</code></dd></dl> +<dd><code>java.io.IOException</code></dd></dl> </li> </ul> <a name="dump(org.apache.poi.poifs.filesystem.DirectoryEntry, java.io.File)"> Modified: poi/site/publish/apidocs/org/apache/poi/poifs/filesystem/class-use/POIFSFileSystem.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/poifs/filesystem/class-use/POIFSFileSystem.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/poifs/filesystem/class-use/POIFSFileSystem.html (original) +++ poi/site/publish/apidocs/org/apache/poi/poifs/filesystem/class-use/POIFSFileSystem.html Tue Mar 22 10:23:19 2016 @@ -564,7 +564,7 @@ <tr class="altColor"> <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/poifs/filesystem/POIFSFileSystem.html" title="class in org.apache.poi.poifs.filesystem">POIFSFileSystem</a></code></td> <td class="colLast"><span class="strong">HWPFDocumentCore.</span><code><strong><a href="../../../../../../org/apache/poi/hwpf/HWPFDocumentCore.html#verifyAndBuildPOIFS(java.io.InputStream)">verifyAndBuildPOIFS</a></strong>(java.io.InputStream istream)</code> -<div class="block">Takens an InputStream, verifies that it's not RTF or PDF, builds a +<div class="block">Takes an InputStream, verifies that it's not RTF or PDF, builds a POIFSFileSystem from it, and returns that.</div> </td> </tr> Modified: poi/site/publish/apidocs/org/apache/poi/poifs/property/DirectoryProperty.PropertyComparator.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/poifs/property/DirectoryProperty.PropertyComparator.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/poifs/property/DirectoryProperty.PropertyComparator.html (original) +++ poi/site/publish/apidocs/org/apache/poi/poifs/property/DirectoryProperty.PropertyComparator.html Tue Mar 22 10:23:19 2016 @@ -94,7 +94,7 @@ <li class="blockList"> <dl> <dt>All Implemented Interfaces:</dt> -<dd>java.util.Comparator<<a href="../../../../../org/apache/poi/poifs/property/Property.html" title="class in org.apache.poi.poifs.property">Property</a>></dd> +<dd>java.io.Serializable, java.util.Comparator<<a href="../../../../../org/apache/poi/poifs/property/Property.html" title="class in org.apache.poi.poifs.property">Property</a>></dd> </dl> <dl> <dt>Enclosing class:</dt> @@ -104,7 +104,8 @@ <br> <pre>public static class <span class="strong">DirectoryProperty.PropertyComparator</span> extends java.lang.Object -implements java.util.Comparator<<a href="../../../../../org/apache/poi/poifs/property/Property.html" title="class in org.apache.poi.poifs.property">Property</a>></pre> +implements java.util.Comparator<<a href="../../../../../org/apache/poi/poifs/property/Property.html" title="class in org.apache.poi.poifs.property">Property</a>>, java.io.Serializable</pre> +<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../serialized-form.html#org.apache.poi.poifs.property.DirectoryProperty.PropertyComparator">Serialized Form</a></dd></dl> </li> </ul> </div> Modified: poi/site/publish/apidocs/org/apache/poi/poifs/property/package-tree.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/poifs/property/package-tree.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/poifs/property/package-tree.html (original) +++ poi/site/publish/apidocs/org/apache/poi/poifs/property/package-tree.html Tue Mar 22 10:23:19 2016 @@ -72,7 +72,7 @@ <ul> <li type="circle">java.lang.Object <ul> -<li type="circle">org.apache.poi.poifs.property.<a href="../../../../../org/apache/poi/poifs/property/DirectoryProperty.PropertyComparator.html" title="class in org.apache.poi.poifs.property"><span class="strong">DirectoryProperty.PropertyComparator</span></a> (implements java.util.Comparator<T>)</li> +<li type="circle">org.apache.poi.poifs.property.<a href="../../../../../org/apache/poi/poifs/property/DirectoryProperty.PropertyComparator.html" title="class in org.apache.poi.poifs.property"><span class="strong">DirectoryProperty.PropertyComparator</span></a> (implements java.util.Comparator<T>, java.io.Serializable)</li> <li type="circle">org.apache.poi.poifs.property.<a href="../../../../../org/apache/poi/poifs/property/Property.html" title="class in org.apache.poi.poifs.property"><span class="strong">Property</span></a> (implements org.apache.poi.poifs.property.<a href="../../../../../org/apache/poi/poifs/property/Child.html" title="interface in org.apache.poi.poifs.property">Child</a>, org.apache.poi.poifs.dev.<a href="../../../../../org/apache/poi/poifs/dev/POIFSViewable.html" title="interface in org.apache.poi.poifs.dev">POIFSViewable</a>) <ul> <li type="circle">org.apache.poi.poifs.property.<a href="../../../../../org/apache/poi/poifs/property/DirectoryProperty.html" title="class in org.apache.poi.poifs.property"><span class="strong">DirectoryProperty</span></a> (implements java.lang.Iterable<T>, org.apache.poi.poifs.property.<a href="../../../../../org/apache/poi/poifs/property/Parent.html" title="interface in org.apache.poi.poifs.property">Parent</a>) Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html Tue Mar 22 10:23:19 2016 @@ -183,38 +183,44 @@ extends java.lang.Iterable<<a href=". </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>int</code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegionUnsafe</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> region)</code> +<div class="block">Adds a merged region of cells (hence those cells form one).</div> +</td> +</tr> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addValidationData(org.apache.poi.ss.usermodel.DataValidation)">addValidationData</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel">DataValidation</a> dataValidation)</code> <div class="block">Creates a data validation object</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#autoSizeColumn(int)">autoSizeColumn</a></strong>(int column)</code> <div class="block">Adjusts the column width to fit the contents.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#autoSizeColumn(int,%20boolean)">autoSizeColumn</a></strong>(int column, boolean useMergedCells)</code> <div class="block">Adjusts the column width to fit the contents.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Drawing.html" title="interface in org.apache.poi.ss.usermodel">Drawing</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createDrawingPatriarch()">createDrawingPatriarch</a></strong>()</code> <div class="block">Creates the top-level drawing patriarch.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createFreezePane(int,%20int)">createFreezePane</a></strong>(int colSplit, int rowSplit)</code> <div class="block">Creates a split (freezepane).</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createFreezePane(int,%20int,%20int,%20int)">createFreezePane</a></strong>(int colSplit, int rowSplit, @@ -223,13 +229,13 @@ extends java.lang.Iterable<<a href=". <div class="block">Creates a split (freezepane).</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createRow(int)">createRow</a></strong>(int rownum)</code> <div class="block">Create a new row within the sheet and return the high level representation</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createSplitPane(int,%20int,%20int,%20int,%20int)">createSplitPane</a></strong>(int xSplitPos, int ySplitPos, @@ -239,25 +245,25 @@ extends java.lang.Iterable<<a href=". <div class="block">Creates a split pane.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getActiveCell()">getActiveCell</a></strong>()</code> <div class="block">Return location of the active cell, e.g.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getAutobreaks()">getAutobreaks</a></strong>()</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/Comment.html" title="interface in org.apache.poi.ss.usermodel">Comment</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(org.apache.poi.ss.util.CellAddress)">getCellComment</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a> ref)</code> <div class="block">Returns cell comment for the specified location</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Comment.html" title="interface in org.apache.poi.ss.usermodel">Comment</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(int,%20int)">getCellComment</a></strong>(int row, int column)</code> @@ -266,25 +272,25 @@ extends java.lang.Iterable<<a href=". </div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>java.util.Map<<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>,? extends <a href="../../../../../org/apache/poi/ss/usermodel/Comment.html" title="interface in org.apache.poi.ss.usermodel">Comment</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComments()">getCellComments</a></strong>()</code> <div class="block">Returns all cell comments on this sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>int[]</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnBreaks()">getColumnBreaks</a></strong>()</code> <div class="block">Retrieves all the vertical page breaks</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnOutlineLevel(int)">getColumnOutlineLevel</a></strong>(int columnIndex)</code> <div class="block">Returns the column outline level.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnStyle(int)">getColumnStyle</a></strong>(int column)</code> <div class="block">Returns the CellStyle that applies to the given @@ -292,573 +298,573 @@ extends java.lang.Iterable<<a href=". set for that column</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidth(int)">getColumnWidth</a></strong>(int columnIndex)</code> <div class="block">get the width (in units of 1/256th of a character width )</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>float</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a></strong>(int columnIndex)</code> <div class="block">get the width in pixel</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationHelper.html" title="interface in org.apache.poi.ss.usermodel">DataValidationHelper</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidationHelper()">getDataValidationHelper</a></strong>()</code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>java.util.List<? extends <a href="../../../../../org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel">DataValidation</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidations()">getDataValidations</a></strong>()</code> <div class="block">Returns the list of DataValidation in the sheet.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultColumnWidth()">getDefaultColumnWidth</a></strong>()</code> <div class="block">Get the default column width for the sheet (if the columns do not define their own width) in characters</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>short</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeight()">getDefaultRowHeight</a></strong>()</code> <div class="block">Get the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>float</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeightInPoints()">getDefaultRowHeightInPoints</a></strong>()</code> <div class="block">Get the default row height for the sheet (if the rows do not define their own height) in points.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDisplayGuts()">getDisplayGuts</a></strong>()</code> <div class="block">Get whether to display the guts or not, default value is true</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Drawing.html" title="interface in org.apache.poi.ss.usermodel">Drawing</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDrawingPatriarch()">getDrawingPatriarch</a></strong>()</code> <div class="block">Return the sheet's existing drawing, or null if there isn't yet one.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFirstRowNum()">getFirstRowNum</a></strong>()</code> <div class="block">Gets the first row on the sheet</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFitToPage()">getFitToPage</a></strong>()</code> <div class="block">Flag indicating whether the Fit to Page print option is enabled.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFooter()">getFooter</a></strong>()</code> <div class="block">Gets the user model for the default document footer.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></strong>()</code> <div class="block">Whether Excel will be asked to recalculate all formulas in this sheet when the workbook is opened.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHeader()">getHeader</a></strong>()</code> <div class="block">Gets the user model for the default document header.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHorizontallyCenter()">getHorizontallyCenter</a></strong>()</code> <div class="block">Determine whether printed output for this sheet will be horizontally centered.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlink(int,%20int)">getHyperlink</a></strong>(int row, int column)</code> <div class="block">Get a Hyperlink in this sheet anchored at row, column</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>java.util.List<? extends <a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlinkList()">getHyperlinkList</a></strong>()</code> <div class="block">Get a list of Hyperlinks in this sheet</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLastRowNum()">getLastRowNum</a></strong>()</code> <div class="block">Gets the last row on the sheet</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>short</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLeftCol()">getLeftCol</a></strong>()</code> <div class="block">The left col in the visible view when the sheet is first viewed after opening it in a viewer</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>double</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMargin(short)">getMargin</a></strong>(short margin)</code> <div class="block">Gets the size of the margin in inches.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegion(int)">getMergedRegion</a></strong>(int index)</code> <div class="block">Returns the merged region at the specified index</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegions()">getMergedRegions</a></strong>()</code> <div class="block">Returns the list of merged regions.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getNumMergedRegions()">getNumMergedRegions</a></strong>()</code> <div class="block">Returns the number of merged regions</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/util/PaneInformation.html" title="class in org.apache.poi.hssf.util">PaneInformation</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPaneInformation()">getPaneInformation</a></strong>()</code> <div class="block">Returns the information regarding the currently configured pane (split or freeze)</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPhysicalNumberOfRows()">getPhysicalNumberOfRows</a></strong>()</code> <div class="block">Returns the number of physically defined rows (NOT the number of rows in the sheet)</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/PrintSetup.html" title="interface in org.apache.poi.ss.usermodel">PrintSetup</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPrintSetup()">getPrintSetup</a></strong>()</code> <div class="block">Gets the print setup object.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getProtect()">getProtect</a></strong>()</code> <div class="block">Answer whether protection is enabled or disabled</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingColumns()">getRepeatingColumns</a></strong>()</code> <div class="block">Gets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingRows()">getRepeatingRows</a></strong>()</code> <div class="block">Gets the repeating rows used when printing the sheet, as found in File->PageSetup->Sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRow(int)">getRow</a></strong>(int rownum)</code> <div class="block">Returns the logical row (not physical) 0-based.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int[]</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowBreaks()">getRowBreaks</a></strong>()</code> <div class="block">Retrieves all the horizontal page breaks</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsBelow()">getRowSumsBelow</a></strong>()</code> <div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsRight()">getRowSumsRight</a></strong>()</code> <div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getScenarioProtect()">getScenarioProtect</a></strong>()</code> <div class="block">Answer whether scenario protection is enabled or disabled</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/SheetConditionalFormatting.html" title="interface in org.apache.poi.ss.usermodel">SheetConditionalFormatting</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetConditionalFormatting()">getSheetConditionalFormatting</a></strong>()</code> <div class="block">The 'Conditional Formatting' facet for this <tt>Sheet</tt></div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>java.lang.String</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetName()">getSheetName</a></strong>()</code> <div class="block">Returns the name of this sheet</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>short</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getTopRow()">getTopRow</a></strong>()</code> <div class="block">The top row in the visible view when the sheet is first viewed after opening it in a viewer</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getVerticallyCenter()">getVerticallyCenter</a></strong>()</code> <div class="block">Determine whether printed output for this sheet will be vertically centered.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getWorkbook()">getWorkbook</a></strong>()</code> <div class="block">Return the parent workbook</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#groupColumn(int,%20int)">groupColumn</a></strong>(int fromColumn, int toColumn)</code> <div class="block">Create an outline for the provided column range.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#groupRow(int,%20int)">groupRow</a></strong>(int fromRow, int toRow)</code> <div class="block">Tie a range of rows together so that they can be collapsed or expanded</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnBroken(int)">isColumnBroken</a></strong>(int column)</code> <div class="block">Determines if there is a page break at the indicated column</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnHidden(int)">isColumnHidden</a></strong>(int columnIndex)</code> <div class="block">Get the hidden state for a given column</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayFormulas()">isDisplayFormulas</a></strong>()</code> <div class="block">Returns if formulas are displayed</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayGridlines()">isDisplayGridlines</a></strong>()</code> <div class="block">Returns if gridlines are displayed</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a></strong>()</code> <div class="block">Returns if RowColHeadings are displayed.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayZeros()">isDisplayZeros</a></strong>()</code> <div class="block">Gets the flag indicating whether the window should show 0 (zero) in cells containing zero value.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isPrintGridlines()">isPrintGridlines</a></strong>()</code> <div class="block">Gets the flag indicating whether this sheet displays the lines between rows and columns to make editing and reading easier.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRightToLeft()">isRightToLeft</a></strong>()</code> <div class="block">Whether the text is displayed in right-to-left mode in the window</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRowBroken(int)">isRowBroken</a></strong>(int row)</code> <div class="block">Determines if there is a page break at the indicated row</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isSelected()">isSelected</a></strong>()</code> <div class="block">Note - this is not the same as whether the sheet is focused (isActive)</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#protectSheet(java.lang.String)">protectSheet</a></strong>(java.lang.String 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><? extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">removeArrayFormula</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a> 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/ss/usermodel/Sheet.html#removeColumnBreak(int)">removeColumnBreak</a></strong>(int 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/ss/usermodel/Sheet.html#removeMergedRegion(int)">removeMergedRegion</a></strong>(int 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/ss/usermodel/Sheet.html#removeRow(org.apache.poi.ss.usermodel.Row)">removeRow</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a> row)</code> <div class="block">Remove a row from this sheet.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeRowBreak(int)">removeRowBreak</a></strong>(int row)</code> <div class="block">Removes the page break at the indicated row</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#rowIterator()">rowIterator</a></strong>()</code> <div class="block">Returns an iterator of the physical rows</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setActiveCell(org.apache.poi.ss.util.CellAddress)">setActiveCell</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a> address)</code> <div class="block">Sets location of the active cell</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a><? extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setArrayFormula(java.lang.String,%20org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a></strong>(java.lang.String 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/ss/usermodel/Sheet.html#setAutobreaks(boolean)">setAutobreaks</a></strong>(boolean value)</code> <div class="block">Flag indicating whether the sheet displays Automatic Page Breaks.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/AutoFilter.html" title="interface in org.apache.poi.ss.usermodel">AutoFilter</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range)</code> <div class="block">Enable filtering for a range of cells</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnBreak(int)">setColumnBreak</a></strong>(int column)</code> <div class="block">Sets a page break at the indicated column.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnGroupCollapsed(int,%20boolean)">setColumnGroupCollapsed</a></strong>(int 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/ss/usermodel/Sheet.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/ss/usermodel/Sheet.html#setColumnWidth(int,%20int)">setColumnWidth</a></strong>(int columnIndex, int width)</code> <div class="block">Set the width (in units of 1/256th of a character width)</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnStyle(int,%20org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a></strong>(int 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/ss/usermodel/Sheet.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/ss/usermodel/Sheet.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/ss/usermodel/Sheet.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/ss/usermodel/Sheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></strong>(boolean show)</code> <div class="block">Sets whether the gridlines are shown in a viewer</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGuts(boolean)">setDisplayGuts</a></strong>(boolean value)</code> <div class="block">Set whether to display the guts or not</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></strong>(boolean show)</code> <div class="block">Sets whether the RowColHeadings are shown in a viewer</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayZeros(boolean)">setDisplayZeros</a></strong>(boolean value)</code> <div class="block">Set whether the window should show 0 (zero) in cells containing zero value.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setFitToPage(boolean)">setFitToPage</a></strong>(boolean value)</code> <div class="block">Flag indicating whether the Fit to Page print option is enabled.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code> <div class="block">Control if Excel should be asked to recalculate all formulas on this sheet when the workbook is opened.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></strong>(boolean value)</code> <div class="block">Determines whether the output is horizontally centered on the page.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setMargin(short,%20double)">setMargin</a></strong>(short 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/ss/usermodel/Sheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></strong>(boolean show)</code> <div class="block">Sets the flag indicating whether this sheet should display the lines between rows and columns to make editing and reading easier.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int row, boolean collapse)</code> <div class="block">Set view state of a grouped range 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/ss/usermodel/Sheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a></strong>(boolean 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/ss/usermodel/Sheet.html#setRowSumsRight(boolean)">setRowSumsRight</a></strong>(boolean 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/ss/usermodel/Sheet.html#setSelected(boolean)">setSelected</a></strong>(boolean value)</code> <div class="block">Sets a flag indicating whether this sheet is selected.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int,%20int)">setZoom</a></strong>(int numerator, int denominator)</code> @@ -867,7 +873,7 @@ extends java.lang.Iterable<<a href=". </div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int)">shiftRows</a></strong>(int startRow, int endRow, @@ -875,7 +881,7 @@ extends java.lang.Iterable<<a href=". <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/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a></strong>(int startRow, int endRow, @@ -885,7 +891,7 @@ extends java.lang.Iterable<<a href=". <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/ss/usermodel/Sheet.html#showInPane(int,%20int)">showInPane</a></strong>(int toprow, int leftcol)</code> @@ -893,20 +899,27 @@ extends java.lang.Iterable<<a href=". file is first opened in a viewer.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#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"> +<td class="colFirst"><code>void</code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.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> </table> <ul class="blockList"> <li class="blockList"><a name="methods_inherited_from_class_java.lang.Iterable"> @@ -1335,6 +1348,40 @@ extends java.lang.Iterable<<a href=". <dt><span class="strong">Returns:</span></dt><dd>index of this region</dd></dl> </li> </ul> +<a name="addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress)"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>addMergedRegionUnsafe</h4> +<pre>int addMergedRegionUnsafe(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> region)</pre> +<div class="block">Adds a merged region of cells (hence those cells form one). + Skips validation. It is possible to create overlapping merged regions + or create a merged region that intersects a multi-cell array formula + with this formula, which may result in a corrupt workbook. + + To check for merged regions overlapping array formulas or other merged regions + after addMergedRegionUnsafe has been called, call <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#validateMergedRegions()"><code>validateMergedRegions()</code></a>, which runs in O(n^2) time.</div> +<dl><dt><span class="strong">Parameters:</span></dt><dd><code>region</code> - to merge</dd> +<dt><span class="strong">Returns:</span></dt><dd>index of this region</dd> +<dt><span class="strong">Throws:</span></dt> +<dd><code>java.lang.IllegalArgumentException</code> - if region contains fewer than 2 cells</dd></dl> +</li> +</ul> +<a name="validateMergedRegions()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>validateMergedRegions</h4> +<pre>void validateMergedRegions()</pre> +<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> +<dl><dt><span class="strong">Throws:</span></dt> +<dd><code>java.lang.IllegalStateException</code> - if region intersects with a multi-cell array formula</dd> +<dd><code>java.lang.IllegalStateException</code> - if at least one region intersects with another merged region in this sheet</dd></dl> +</li> +</ul> <a name="setVerticallyCenter(boolean)"> <!-- --> </a> Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellRangeAddress.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellRangeAddress.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellRangeAddress.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellRangeAddress.html Tue Mar 22 10:23:19 2016 @@ -562,23 +562,29 @@ HSSF concepts.</div> <tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><span class="strong">HSSFSheet.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#addMergedRegion(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegion</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> region)</code> -<div class="block">adds a merged region of cells (hence those cells form one)</div> +<div class="block">Adds a merged region of cells on a sheet.</div> </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>int</code></td> +<td class="colLast"><span class="strong">HSSFSheet.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegionUnsafe</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> region)</code> +<div class="block">Adds a merged region of cells (hence those cells form one).</div> +</td> +</tr> +<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><<a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html" title="class in org.apache.poi.hssf.usermodel">HSSFCell</a>></code></td> <td class="colLast"><span class="strong">HSSFSheet.</span><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> </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"><span class="strong">HSSFSheet.</span><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> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><span class="strong">HSSFSheet.</span><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> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><span class="strong">HSSFSheet.</span><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> </td> </tr> @@ -783,26 +789,32 @@ HSSF concepts.</div> </td> </tr> <tr class="altColor"> +<td class="colFirst"><code>int</code></td> +<td class="colLast"><span class="strong">Sheet.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegionUnsafe</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> region)</code> +<div class="block">Adds a merged region of cells (hence those cells form one).</div> +</td> +</tr> +<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><? extends <a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>></code></td> <td class="colLast"><span class="strong">Sheet.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html#setArrayFormula(java.lang.String,%20org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a></strong>(java.lang.String 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><a href="../../../../../../org/apache/poi/ss/usermodel/AutoFilter.html" title="interface in org.apache.poi.ss.usermodel">AutoFilter</a></code></td> <td class="colLast"><span class="strong">Sheet.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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"><span class="strong">Sheet.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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"><span class="strong">Sheet.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> rowRangeRef)</code> <div class="block">Sets the repeating rows used when printing the sheet, as found in @@ -1060,23 +1072,29 @@ HSSF concepts.</div> </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>int</code></td> +<td class="colLast"><span class="strong">SXSSFSheet.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegionUnsafe</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> region)</code> +<div class="block">Adds a merged region of cells (hence those cells form one)</div> +</td> +</tr> +<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><? extends <a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>></code></td> <td class="colLast"><span class="strong">SXSSFSheet.</span><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 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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../../org/apache/poi/ss/usermodel/AutoFilter.html" title="interface in org.apache.poi.ss.usermodel">AutoFilter</a></code></td> <td class="colLast"><span class="strong">SXSSFSheet.</span><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> 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"><span class="strong">SXSSFSheet.</span><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> columnRangeRef)</code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><span class="strong">SXSSFSheet.</span><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> rowRangeRef)</code> </td> </tr> Modified: poi/site/publish/apidocs/org/apache/poi/util/IOUtils.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/util/IOUtils.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/util/IOUtils.html (original) +++ poi/site/publish/apidocs/org/apache/poi/util/IOUtils.html Tue Mar 22 10:23:19 2016 @@ -184,6 +184,13 @@ extends java.lang.Object</pre> <div class="block">Reads all the data from the input stream, and returns the bytes read.</div> </td> </tr> +<tr class="altColor"> +<td class="colFirst"><code>static byte[]</code></td> +<td class="colLast"><code><strong><a href="../../../../org/apache/poi/util/IOUtils.html#toByteArray(java.io.InputStream,%20int)">toByteArray</a></strong>(java.io.InputStream stream, + int length)</code> +<div class="block">Reads up to <code>length</code> bytes from the input stream, and returns the bytes read.</div> +</td> +</tr> </table> <ul class="blockList"> <li class="blockList"><a name="methods_inherited_from_class_java.lang.Object"> @@ -236,6 +243,20 @@ extends java.lang.Object</pre> <dl><dt><span class="strong">Throws:</span></dt> <dd><code>java.io.IOException</code></dd></dl> </li> +</ul> +<a name="toByteArray(java.io.InputStream, int)"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>toByteArray</h4> +<pre>public static byte[] toByteArray(java.io.InputStream stream, + int length) + throws java.io.IOException</pre> +<div class="block">Reads up to <code>length</code> bytes from the input stream, and returns the bytes read.</div> +<dl><dt><span class="strong">Throws:</span></dt> +<dd><code>java.io.IOException</code></dd></dl> +</li> </ul> <a name="toByteArray(java.nio.ByteBuffer, int)"> <!-- --> Modified: poi/site/publish/apidocs/org/apache/poi/util/XmlSort.QNameComparator.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/util/XmlSort.QNameComparator.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/util/XmlSort.QNameComparator.html (original) +++ poi/site/publish/apidocs/org/apache/poi/util/XmlSort.QNameComparator.html Tue Mar 22 10:23:19 2016 @@ -94,7 +94,7 @@ <li class="blockList"> <dl> <dt>All Implemented Interfaces:</dt> -<dd>java.util.Comparator<org.apache.xmlbeans.XmlCursor></dd> +<dd>java.io.Serializable, java.util.Comparator<org.apache.xmlbeans.XmlCursor></dd> </dl> <dl> <dt>Enclosing class:</dt> @@ -104,12 +104,13 @@ <br> <pre>public static final class <span class="strong">XmlSort.QNameComparator</span> extends java.lang.Object -implements java.util.Comparator<org.apache.xmlbeans.XmlCursor></pre> +implements java.util.Comparator<org.apache.xmlbeans.XmlCursor>, java.io.Serializable</pre> <div class="block">Implements a <code>java.util.Comparator</code> for comparing <code>QName</code>values. The namespace URIs are compared first and if they are equal, the local parts are compared. <p/> The constructor accepts an argument indicating whether the comparison order is the same as the lexicographic order of the strings or the reverse.</div> +<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../serialized-form.html#org.apache.poi.util.XmlSort.QNameComparator">Serialized Form</a></dd></dl> </li> </ul> </div> Modified: poi/site/publish/apidocs/org/apache/poi/util/package-tree.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/util/package-tree.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/util/package-tree.html (original) +++ poi/site/publish/apidocs/org/apache/poi/util/package-tree.html Tue Mar 22 10:23:19 2016 @@ -154,7 +154,7 @@ <li type="circle">org.apache.poi.util.<a href="../../../../org/apache/poi/util/Units.html" title="class in org.apache.poi.util"><span class="strong">Units</span></a></li> <li type="circle">org.apache.poi.util.<a href="../../../../org/apache/poi/util/XMLHelper.html" title="class in org.apache.poi.util"><span class="strong">XMLHelper</span></a></li> <li type="circle">org.apache.poi.util.<a href="../../../../org/apache/poi/util/XmlSort.html" title="class in org.apache.poi.util"><span class="strong">XmlSort</span></a></li> -<li type="circle">org.apache.poi.util.<a href="../../../../org/apache/poi/util/XmlSort.QNameComparator.html" title="class in org.apache.poi.util"><span class="strong">XmlSort.QNameComparator</span></a> (implements java.util.Comparator<T>)</li> +<li type="circle">org.apache.poi.util.<a href="../../../../org/apache/poi/util/XmlSort.QNameComparator.html" title="class in org.apache.poi.util"><span class="strong">XmlSort.QNameComparator</span></a> (implements java.util.Comparator<T>, java.io.Serializable)</li> </ul> </li> </ul> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
