Modified: poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html Tue Mar 22 10:23:19 2016 @@ -160,49 +160,55 @@ implements <a href="../../../../../org/a </td> </tr> <tr class="rowColor"> +<td class="colFirst"><code>int</code></td> +<td class="colLast"><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>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#areAllRowsFlushed()">areAllRowsFlushed</a></strong>()</code> <div class="block">Are all rows flushed to disk?</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#autoSizeColumn(int)">autoSizeColumn</a></strong>(int column)</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>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#changeRowNum(org.apache.poi.xssf.streaming.SXSSFRow,%20int)">changeRowNum</a></strong>(<a href="../../../../../org/apache/poi/xssf/streaming/SXSSFRow.html" title="class in org.apache.poi.xssf.streaming">SXSSFRow</a> row, int newRowNum)</code> </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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#createFreezePane(int,%20int,%20int,%20int)">createFreezePane</a></strong>(int colSplit, int rowSplit, @@ -211,13 +217,13 @@ implements <a href="../../../../../org/a <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/xssf/streaming/SXSSFRow.html" title="class in org.apache.poi.xssf.streaming">SXSSFRow</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#createSplitPane(int,%20int,%20int,%20int,%20int)">createSplitPane</a></strong>(int xSplitPos, int ySplitPos, @@ -227,37 +233,37 @@ implements <a href="../../../../../org/a <div class="block">Creates a split pane.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#flushRows()">flushRows</a></strong>()</code> <div class="block">Flush all rows to disk.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#flushRows(int)">flushRows</a></strong>(int remaining)</code> <div class="block">Specifies how many rows can be accessed at most via getRow().</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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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 row and column</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getCellComment(int,%20int)">getCellComment</a></strong>(int row, int column)</code> @@ -266,25 +272,25 @@ implements <a href="../../../../../org/a </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>,<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#getColumnStyle(int)">getColumnStyle</a></strong>(int column)</code> <div class="block">Returns the CellStyle that applies to the given @@ -292,613 +298,613 @@ implements <a href="../../../../../org/a set for that column</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a></strong>(int columnIndex)</code> <div class="block">Get the actual column width in pixels</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationHelper.html" title="interface in org.apache.poi.ss.usermodel">DataValidationHelper</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getDataValidationHelper()">getDataValidationHelper</a></strong>()</code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidation.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidation</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getDataValidations()">getDataValidations</a></strong>()</code> <div class="block">Returns the list of DataValidation in the sheet.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getDefaultColumnWidth()">getDefaultColumnWidth</a></strong>()</code> <div class="block">Get the default column width for the sheet (if the columns do not define their own width) in characters</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>short</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getDefaultRowHeight()">getDefaultRowHeight</a></strong>()</code> <div class="block">Get the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>float</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#getFirstRowNum()">getFirstRowNum</a></strong>()</code> <div class="block">Gets the first row on the sheet</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getFitToPage()">getFitToPage</a></strong>()</code> <div class="block">Flag indicating whether the Fit to Page print option is enabled.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></strong>()</code> <div class="block">Whether Excel will be asked to recalculate all formulas when the workbook is opened.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#getHorizontallyCenter()">getHorizontallyCenter</a></strong>()</code> <div class="block">Determine whether printed output for this sheet will be horizontally centered.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#getLastFlushedRowNum()">getLastFlushedRowNum</a></strong>()</code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getLastRowNum()">getLastRowNum</a></strong>()</code> <div class="block">Gets the last row on the sheet</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>short</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>double</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="rowColor"> +<tr class="altColor"> <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/xssf/streaming/SXSSFSheet.html#getMergedRegions()">getMergedRegions</a></strong>()</code> <div class="block">Returns the list of merged regions.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getNumMergedRegions()">getNumMergedRegions</a></strong>()</code> <div class="block">Returns the number of merged regions</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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/xssf/streaming/SXSSFSheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="rowColor"> +<tr class="altColor"> <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/xssf/streaming/SXSSFSheet.html#getPrintSetup()">getPrintSetup</a></strong>()</code> <div class="block">Gets the print setup object.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getProtect()">getProtect</a></strong>()</code> <div class="block">Answer whether protection is enabled or disabled</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFRow.html" title="class in org.apache.poi.xssf.streaming">SXSSFRow</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>int[]</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getRowBreaks()">getRowBreaks</a></strong>()</code> <div class="block">Retrieves all the horizontal 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/xssf/streaming/SXSSFSheet.html#getRowNum(org.apache.poi.xssf.streaming.SXSSFRow)">getRowNum</a></strong>(<a href="../../../../../org/apache/poi/xssf/streaming/SXSSFRow.html" title="class in org.apache.poi.xssf.streaming">SXSSFRow</a> row)</code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#getSheetConditionalFormatting()">getSheetConditionalFormatting</a></strong>()</code> <div class="block">The 'Conditional Formatting' facet for this <tt>Sheet</tt></div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>java.lang.String</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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>java.util.Set<java.lang.Integer></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getTrackedColumnsForAutoSizing()">getTrackedColumnsForAutoSizing</a></strong>()</code> <div class="block">Get the currently tracked columns for auto-sizing.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html" title="class in org.apache.poi.xssf.streaming">SXSSFWorkbook</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getWorkbook()">getWorkbook</a></strong>()</code> <div class="block">Return the parent workbook</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>java.io.InputStream</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#getWorksheetXMLInputStream()">getWorksheetXMLInputStream</a></strong>()</code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#isColumnTrackedForAutoSizing(int)">isColumnTrackedForAutoSizing</a></strong>(int column)</code> <div class="block">Returns true if column is currently tracked for auto-sizing.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#isDisplayFormulas()">isDisplayFormulas</a></strong>()</code> <div class="block">Returns if formulas 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/xssf/streaming/SXSSFSheet.html#isDisplayGridlines()">isDisplayGridlines</a></strong>()</code> <div class="block">Returns if gridlines 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/xssf/streaming/SXSSFSheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a></strong>()</code> <div class="block">Returns if RowColHeadings 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/xssf/streaming/SXSSFSheet.html#isDisplayZeros()">isDisplayZeros</a></strong>()</code> <div class="block">Gets the flag indicating whether the window should show 0 (zero) in cells containing zero value.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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="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/xssf/streaming/SXSSFSheet.html#iterator()">iterator</a></strong>()</code> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">removeArrayFormula</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a> cell)</code> <div class="block">Remove a Array Formula from this sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#removeColumnBreak(int)">removeColumnBreak</a></strong>(int column)</code> <div class="block">Removes a page break at the indicated column</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#removeMergedRegion(int)">removeMergedRegion</a></strong>(int index)</code> <div class="block">Removes a merged region of cells (hence letting them free)</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#rowIterator()">rowIterator</a></strong>()</code> <div class="block">Returns an iterator of the physical rows</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setActiveCell(org.apache.poi.ss.util.CellAddress)">setActiveCell</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a> 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/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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#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/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"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code> <div class="block">Control if Excel should be asked to recalculate all formulas when the workbook is opened, via the "sheetCalcPr fullCalcOnLoad" option.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#setRandomAccessWindowSize(int)">setRandomAccessWindowSize</a></strong>(int value)</code> <div class="block">Specifies how many rows can be accessed at most via getRow().</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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/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> <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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#setRowBreak(int)">setRowBreak</a></strong>(int row)</code> <div class="block">Sets a page break at the indicated row</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int row, boolean collapse)</code> <div class="block">Set view state of a groupped range of rows</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRowOutlineLevel(int,%20int)">setRowOutlineLevel</a></strong>(int rownum, int level)</code> <div class="block">Set row groupings (like groupRow) in a stream-friendly manner</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a></strong>(boolean value)</code> <div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setRowSumsRight(boolean)">setRowSumsRight</a></strong>(boolean value)</code> <div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#setSelected(boolean)">setSelected</a></strong>(boolean value)</code> <div class="block">Sets a flag indicating whether this sheet is selected.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.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/xssf/streaming/SXSSFSheet.html#setZoom(int,%20int)">setZoom</a></strong>(int numerator, int denominator)</code> @@ -907,7 +913,7 @@ implements <a href="../../../../../org/a </div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#shiftRows(int,%20int,%20int)">shiftRows</a></strong>(int startRow, int endRow, @@ -917,7 +923,7 @@ implements <a href="../../../../../org/a Shifts rows between startRow and endRow n number of rows.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a></strong>(int startRow, int endRow, @@ -929,7 +935,7 @@ implements <a href="../../../../../org/a Shifts rows between startRow and endRow n number of rows.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#showInPane(int,%20int)">showInPane</a></strong>(int toprow, int leftcol)</code> @@ -937,56 +943,63 @@ implements <a href="../../../../../org/a 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/xssf/streaming/SXSSFSheet.html#trackAllColumnsForAutoSizing()">trackAllColumnsForAutoSizing</a></strong>()</code> <div class="block">Tracks all columns in the sheet for auto-sizing.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#trackColumnForAutoSizing(int)">trackColumnForAutoSizing</a></strong>(int column)</code> <div class="block">Track a column in the sheet for auto-sizing.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#trackColumnsForAutoSizing(java.util.Collection)">trackColumnsForAutoSizing</a></strong>(java.util.Collection<java.lang.Integer> columns)</code> <div class="block">Track several columns in the sheet for auto-sizing.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#ungroupColumn(int,%20int)">ungroupColumn</a></strong>(int fromColumn, int toColumn)</code> <div class="block">Ungroup a range of columns that were previously groupped</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#ungroupRow(int,%20int)">ungroupRow</a></strong>(int fromRow, int toRow)</code> <div class="block">Ungroup a range of rows that were previously groupped</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#untrackAllColumnsForAutoSizing()">untrackAllColumnsForAutoSizing</a></strong>()</code> <div class="block">Untracks all columns in the sheet for auto-sizing.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#untrackColumnForAutoSizing(int)">untrackColumnForAutoSizing</a></strong>(int column)</code> <div class="block">Removes a column that was previously marked for inclusion in auto-size column tracking.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#untrackColumnsForAutoSizing(java.util.Collection)">untrackColumnsForAutoSizing</a></strong>(java.util.Collection<java.lang.Integer> columns)</code> <div class="block">Untracks several columns in the sheet for auto-sizing.</div> </td> </tr> +<tr class="altColor"> +<td class="colFirst"><code>void</code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html#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.Object"> @@ -1351,6 +1364,38 @@ implements <a href="../../../../../org/a <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>public 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)</div> +<dl> +<dt><strong>Specified by:</strong></dt> +<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegionUnsafe</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>region</code> - (rowfrom/colfrom-rowto/colto) to merge</dd> +<dt><span class="strong">Returns:</span></dt><dd>index of this region</dd></dl> +</li> +</ul> +<a name="validateMergedRegions()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>validateMergedRegions</h4> +<pre>public 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><strong>Specified by:</strong></dt> +<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#validateMergedRegions()">validateMergedRegions</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">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/xssf/usermodel/XSSFDialogsheet.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDialogsheet.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDialogsheet.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDialogsheet.html Tue Mar 22 10:23:19 2016 @@ -273,7 +273,7 @@ implements <a href="../../../../../org/a <!-- --> </a> <h3>Methods inherited from 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></h3> -<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegion(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegion</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addValidationData(org.apache.poi.ss.usermodel.DataValidation)">addValidationData</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#autoSizeColumn(int)">autoSizeColumn</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#autoSizeColumn(int,%20boolean)">autoSizeColumn</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createDrawingPatriarch()">createDrawingPatriarch</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createFreezePane(int,%20int)">createFreezePane</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createFreezePane(int,%20int,%20int,%20int)">createFreezePane</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createSplitPane(int,%20int,%20int,%20int,%20int)">createS plitPane</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getActiveCell()">getActiveCell</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getAutobreaks()">getAutobreaks</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(org.apache.poi.ss.util.CellAddress)">getCellComment</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(int,%20int)">getCellComment</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComments()">getCellComments</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnBreaks()">getColumnBreaks</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnOutlineLevel(int)">getColumnOutlineLevel</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnStyle(int)">getColumnStyle</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidth(int)">getColumnWidth</a>, <a href ="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidationHelper()">getDataValidationHelper</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidations()">getDataValidations</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultColumnWidth()">getDefaultColumnWidth</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeight()">getDefaultRowHeight</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeightInPoints()">getDefaultRowHeightInPoints</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDisplayGuts()">getDisplayGuts</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDrawingPatriarch()">getDrawingPatriarch</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFirstRowNum()">getFirstRo wNum</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFitToPage()">getFitToPage</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFooter()">getFooter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHeader()">getHeader</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHorizontallyCenter()">getHorizontallyCenter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlink(int,%20int)">getHyperlink</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlinkList()">getHyperlinkList</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLastRowNum()">getLastRowNum</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLeftCol()">getLeftCol</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.ht ml#getMargin(short)">getMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegion(int)">getMergedRegion</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegions()">getMergedRegions</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getNumMergedRegions()">getNumMergedRegions</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPaneInformation()">getPaneInformation</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPhysicalNumberOfRows()">getPhysicalNumberOfRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPrintSetup()">getPrintSetup</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getProtect()">getProtect</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingColumns()">getRepeatingColumns</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingRows()">getRepeatingRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRow(int)">getRow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowBreaks()">getRowBreaks</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsBelow()">getRowSumsBelow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsRight()">getRowSumsRight</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getScenarioProtect()">getScenarioProtect</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetConditionalFormatting()">getSheetConditionalFormatting</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetName()">getSheetName</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getTopRow()">getTopRow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getVerticallyCenter()">getVerticallyCenter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getWork book()">getWorkbook</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#groupColumn(int,%20int)">groupColumn</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#groupRow(int,%20int)">groupRow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnBroken(int)">isColumnBroken</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnHidden(int)">isColumnHidden</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayFormulas()">isDisplayFormulas</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayGridlines()">isDisplayGridlines</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayZeros()">isDisplayZeros</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isPrintGridlines()">isPrintGridlines</a>, <a href="../../../. ./../org/apache/poi/ss/usermodel/Sheet.html#isRightToLeft()">isRightToLeft</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRowBroken(int)">isRowBroken</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isSelected()">isSelected</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#protectSheet(java.lang.String)">protectSheet</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">removeArrayFormula</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeColumnBreak(int)">removeColumnBreak</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeMergedRegion(int)">removeMergedRegion</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeRow(org.apache.poi.ss.usermodel.Row)">removeRow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeRowBreak(int)">removeRowBreak</a>, <a href="../../../../../ org/apache/poi/ss/usermodel/Sheet.html#rowIterator()">rowIterator</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setActiveCell(org.apache.poi.ss.util.CellAddress)">setActiveCell</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setArrayFormula(java.lang.String,%20org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutobreaks(boolean)">setAutobreaks</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnBreak(int)">setColumnBreak</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnGroupCollapsed(int,%20boolean)">setColumnGroupCollapsed</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnHidden(int,%20boolean)">setColumnHidden</a>, <a href="../../../../../org/apach e/poi/ss/usermodel/Sheet.html#setColumnWidth(int,%20int)">setColumnWidth</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnStyle(int,%20org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultRowHeight(short)">setDefaultRowHeight</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGuts(boolean)">setDisplayGuts</a>, <a href="../../../../../org/apache/poi/ss/usermodel/ Sheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayZeros(boolean)">setDisplayZeros</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setFitToPage(boolean)">setFitToPage</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setMargin(short,%20double)">setMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setPrintGridlines(boolean)">setPrintGridlines</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingRows (org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRightToLeft(boolean)">setRightToLeft</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowBreak(int)">setRowBreak</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowSumsRight(boolean)">setRowSumsRight</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setSelected(boolean)">setSelected</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int)">setZoom</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoo m(int,%20int)">setZoom</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int)">shiftRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#showInPane(int,%20int)">showInPane</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ungroupColumn(int,%20int)">ungroupColumn</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ungroupRow(int,%20int)">ungroupRow</a></code></li> +<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegion(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegion</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegionUnsafe</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addValidationData(org.apache.poi.ss.usermodel.DataValidation)">addValidationData</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#autoSizeColumn(int)">autoSizeColumn</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#autoSizeColumn(int,%20boolean)">autoSizeColumn</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createDrawingPatriarch()">createDrawingPatriarch</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createFreezePane(int,%20int)">createFreezePane</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createFreezePane(int,%20int,%20i nt,%20int)">createFreezePane</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createSplitPane(int,%20int,%20int,%20int,%20int)">createSplitPane</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getActiveCell()">getActiveCell</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getAutobreaks()">getAutobreaks</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(org.apache.poi.ss.util.CellAddress)">getCellComment</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(int,%20int)">getCellComment</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComments()">getCellComments</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnBreaks()">getColumnBreaks</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnOutlineLevel(int)">getColumnOutlineLevel</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.htm l#getColumnStyle(int)">getColumnStyle</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidth(int)">getColumnWidth</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidationHelper()">getDataValidationHelper</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidations()">getDataValidations</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultColumnWidth()">getDefaultColumnWidth</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeight()">getDefaultRowHeight</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeightInPoints()">getDefaultRowHeightInPoints</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDisplayGuts()">getDisplayGuts</a>, <a href="../../../../../org/apache/poi/ss/usermo del/Sheet.html#getDrawingPatriarch()">getDrawingPatriarch</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFirstRowNum()">getFirstRowNum</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFitToPage()">getFitToPage</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFooter()">getFooter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHeader()">getHeader</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHorizontallyCenter()">getHorizontallyCenter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlink(int,%20int)">getHyperlink</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHyperlinkList()">getHyperlinkList</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLastRowNum()">getLastRowNum</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLeftCol()">getLeftCol</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMargin(short)">getMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegion(int)">getMergedRegion</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegions()">getMergedRegions</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getNumMergedRegions()">getNumMergedRegions</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPaneInformation()">getPaneInformation</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPhysicalNumberOfRows()">getPhysicalNumberOfRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPrintSetup()">getPrintSetup</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getProtect()">getProtect</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ge tRepeatingColumns()">getRepeatingColumns</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingRows()">getRepeatingRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRow(int)">getRow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowBreaks()">getRowBreaks</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsBelow()">getRowSumsBelow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsRight()">getRowSumsRight</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getScenarioProtect()">getScenarioProtect</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetConditionalFormatting()">getSheetConditionalFormatting</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetName()">getSheetName</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getTopRow()">getTopRow</a>, <a href="../../../../../org /apache/poi/ss/usermodel/Sheet.html#getVerticallyCenter()">getVerticallyCenter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getWorkbook()">getWorkbook</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#groupColumn(int,%20int)">groupColumn</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#groupRow(int,%20int)">groupRow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnBroken(int)">isColumnBroken</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnHidden(int)">isColumnHidden</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayFormulas()">isDisplayFormulas</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayGridlines()">isDisplayGridlines</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDispla yZeros()">isDisplayZeros</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isPrintGridlines()">isPrintGridlines</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRightToLeft()">isRightToLeft</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRowBroken(int)">isRowBroken</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isSelected()">isSelected</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#protectSheet(java.lang.String)">protectSheet</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">removeArrayFormula</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeColumnBreak(int)">removeColumnBreak</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeMergedRegion(int)">removeMergedRegion</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeRow(org.apache.poi.ss.userm odel.Row)">removeRow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeRowBreak(int)">removeRowBreak</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#rowIterator()">rowIterator</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setActiveCell(org.apache.poi.ss.util.CellAddress)">setActiveCell</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setArrayFormula(java.lang.String,%20org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutobreaks(boolean)">setAutobreaks</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnBreak(int)">setColumnBreak</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnGroupCollapsed(int,%20boolean)">setColumnGroupCollapsed</ a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnHidden(int,%20boolean)">setColumnHidden</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnWidth(int,%20int)">setColumnWidth</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnStyle(int,%20org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultRowHeight(short)">setDefaultRowHeight</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a>, <a hre f="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGuts(boolean)">setDisplayGuts</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayZeros(boolean)">setDisplayZeros</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setFitToPage(boolean)">setFitToPage</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setMargin(short,%20double)">setMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setPrintGridlines(boolean)">setPrintGridlines</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeating Columns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRightToLeft(boolean)">setRightToLeft</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowBreak(int)">setRowBreak</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowSumsRight(boolean)">setRowSumsRight</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setSelected(boolean)">setSelected</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a>, <a hr ef="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int)">setZoom</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int,%20int)">setZoom</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int)">shiftRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#showInPane(int,%20int)">showInPane</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ungroupColumn(int,%20int)">ungroupColumn</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ungroupRow(int,%20int)">ungroupRow</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#validateMergedRegions()">validateMergedRegions</a></code></li> </ul> <ul class="blockList"> <li class="blockList"><a name="methods_inherited_from_class_java.lang.Iterable"> Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html?rev=1736175&r1=1736174&r2=1736175&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html Tue Mar 22 10:23:19 2016 @@ -1606,7 +1606,10 @@ public org.openxmlformats.schemas.s To check for merged regions overlapping array formulas or other merged regions after addMergedRegionUnsafe has been called, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.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> +<dl> +<dt><strong>Specified by:</strong></dt> +<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegionUnsafe</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>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> @@ -1621,7 +1624,10 @@ public org.openxmlformats.schemas.s <pre>public 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> +<dl> +<dt><strong>Specified by:</strong></dt> +<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#validateMergedRegions()">validateMergedRegions</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">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> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
