Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html?rev=1800210&r1=1800209&r2=1800210&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html (original) +++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html Wed Jun 28 23:22:37 2017 @@ -302,33 +302,24 @@ implements <a href="../../../../../org/a </td> </tr> <tr class="rowColor"> -<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFComment.html" title="class in org.apache.poi.hssf.usermodel">HSSFComment</a></code></td> -<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getCellComment(int,%20int)">getCellComment</a></strong>(int row, - int column)</code> -<div class="block"><strong>Deprecated.</strong> -<div class="block"><i>as of 2015-11-23 (circa POI 3.14beta1). Use <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getCellComment(org.apache.poi.ss.util.CellAddress)"><code>getCellComment(CellAddress)</code></a> instead.</i></div> -</div> -</td> -</tr> -<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/hssf/usermodel/HSSFComment.html" title="class in org.apache.poi.hssf.usermodel">HSSFComment</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getCellComments()">getCellComments</a></strong>()</code> <div class="block">Returns all cell comments on this 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/hssf/usermodel/HSSFSheet.html#getColumnBreaks()">getColumnBreaks</a></strong>()</code> <div class="block">Retrieves all the vertical page breaks</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/hssf/usermodel/HSSFSheet.html#getColumnOutlineLevel(int)">getColumnOutlineLevel</a></strong>(int columnIndex)</code> <div class="block">Returns the column outline level.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getColumnStyle(int)">getColumnStyle</a></strong>(int column)</code> <div class="block">Returns the HSSFCellStyle that applies to the given @@ -336,693 +327,693 @@ implements <a href="../../../../../org/a set for that column</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/hssf/usermodel/HSSFSheet.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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>float</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a></strong>(int column)</code> <div class="block">get the width in pixel</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <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/hssf/usermodel/HSSFSheet.html#getDataValidationHelper()">getDataValidationHelper</a></strong>()</code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFDataValidation.html" title="class in org.apache.poi.hssf.usermodel">HSSFDataValidation</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getDataValidations()">getDataValidations</a></strong>()</code> <div class="block">Returns the list of DataValidation in the 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/hssf/usermodel/HSSFSheet.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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>short</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>float</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getDialog()">getDialog</a></strong>()</code> <div class="block">get whether sheet is a dialog sheet or not</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/hssf/usermodel/HSSFSheet.html#getDisplayGuts()">getDisplayGuts</a></strong>()</code> <div class="block">get whether to display the guts or not</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/EscherAggregate.html" title="class in org.apache.poi.hssf.record">EscherAggregate</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getDrawingEscherAggregate()">getDrawingEscherAggregate</a></strong>()</code> <div class="block">Returns the agregate escher records for this sheet, it there is one.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFPatriarch.html" title="class in org.apache.poi.hssf.usermodel">HSSFPatriarch</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getDrawingPatriarch()">getDrawingPatriarch</a></strong>()</code> <div class="block">This will hold any graphics or charts for 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/hssf/usermodel/HSSFSheet.html#getFirstRowNum()">getFirstRowNum</a></strong>()</code> <div class="block">Gets the first row on the sheet</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/hssf/usermodel/HSSFSheet.html#getFitToPage()">getFitToPage</a></strong>()</code> <div class="block">fit to page option is on</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFFooter.html" title="class in org.apache.poi.hssf.usermodel">HSSFFooter</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getFooter()">getFooter</a></strong>()</code> <div class="block">Gets the user model for the default document footer.</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/hssf/usermodel/HSSFSheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></strong>()</code> <div class="block">Whether a record must be inserted or not at generation to indicate that formula must be recalculated when workbook is opened.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFHeader.html" title="class in org.apache.poi.hssf.usermodel">HSSFHeader</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getHeader()">getHeader</a></strong>()</code> <div class="block">Gets the user model for the default document header.</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/hssf/usermodel/HSSFSheet.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="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFHyperlink.html" title="class in org.apache.poi.hssf.usermodel">HSSFHyperlink</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getHyperlink(org.apache.poi.ss.util.CellAddress)">getHyperlink</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a> addr)</code> <div class="block">Get a Hyperlink in this sheet located in a cell specified by {code addr}</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFHyperlink.html" title="class in org.apache.poi.hssf.usermodel">HSSFHyperlink</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFHyperlink.html" title="class in org.apache.poi.hssf.usermodel">HSSFHyperlink</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.html#getLastRowNum()">getLastRowNum</a></strong>()</code> <div class="block">Gets the number 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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getObjectProtect()">getObjectProtect</a></strong>()</code> <div class="block">Answer whether object 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/PaneInformation.html" title="class in org.apache.poi.ss.util">PaneInformation</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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>short</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getPassword()">getPassword</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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFPrintSetup.html" title="class in org.apache.poi.hssf.usermodel">HSSFPrintSetup</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFRow.html" title="class in org.apache.poi.hssf.usermodel">HSSFRow</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getRow(int)">getRow</a></strong>(int rowIndex)</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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.html#getRowSumsBelow()">getRowSumsBelow</a></strong>()</code> <div class="block">get if row summaries appear below detail in the 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/hssf/usermodel/HSSFSheet.html#getRowSumsRight()">getRowSumsRight</a></strong>()</code> <div class="block">get if col summaries appear right of the detail in the 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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheetConditionalFormatting.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheetConditionalFormatting</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.html#groupRow(int,%20int)">groupRow</a></strong>(int fromRow, int toRow)</code> <div class="block">Tie a range of cell together so that they can be collapsed or expanded</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>protected void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#insertChartRecords(java.util.List)">insertChartRecords</a></strong>(java.util.List<<a href="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</a>> records)</code> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#isActive()">isActive</a></strong>()</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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.html#isGridsPrinted()">isGridsPrinted</a></strong>()</code> <div class="block">get whether gridlines are printed.</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/hssf/usermodel/HSSFSheet.html#isPrintGridlines()">isPrintGridlines</a></strong>()</code> <div class="block">Returns whether gridlines are printed.</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/hssf/usermodel/HSSFSheet.html#isPrintRowAndColumnHeadings()">isPrintRowAndColumnHeadings</a></strong>()</code> <div class="block">Returns whether row and column headings are printed.</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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#iterator()">iterator</a></strong>()</code> <div class="block">Alias for <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#rowIterator()"><code>rowIterator()</code></a> to allow foreach loops</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>protected void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#preSerialize()">preSerialize</a></strong>()</code> <div class="block">check whether the data of sheet can be serialized</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#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><<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html" title="class in org.apache.poi.hssf.usermodel">HSSFCell</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#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/hssf/usermodel/HSSFSheet.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>protected void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#removeHyperlink(org.apache.poi.hssf.usermodel.HSSFHyperlink)">removeHyperlink</a></strong>(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFHyperlink.html" title="class in org.apache.poi.hssf.usermodel">HSSFHyperlink</a> link)</code> <div class="block">Remove the underlying HyperlinkRecord from this sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>protected void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#removeHyperlink(org.apache.poi.hssf.record.HyperlinkRecord)">removeHyperlink</a></strong>(<a href="../../../../../org/apache/poi/hssf/record/HyperlinkRecord.html" title="class in org.apache.poi.hssf.record">HyperlinkRecord</a> link)</code> <div class="block">Remove the underlying HyperlinkRecord 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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.html#removeMergedRegions(java.util.Collection)">removeMergedRegions</a></strong>(java.util.Collection<java.lang.Integer> indices)</code> <div class="block">Removes a number of merged regions of cells (hence letting them free)</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#removeRow(org.apache.poi.ss.usermodel.Row)">removeRow</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a> row)</code> <div class="block">Remove a row from this sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#removeRowBreak(int)">removeRowBreak</a></strong>(int row)</code> <div class="block">Removes the page break at the indicated row</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#rowIterator()">rowIterator</a></strong>()</code> <div class="block">Returns an iterator of the physical rows</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setActive(boolean)">setActive</a></strong>(boolean sel)</code> <div class="block">Sets whether sheet is selected.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setActiveCell(org.apache.poi.ss.util.CellAddress)">setActiveCell</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a> address)</code> <div class="block">Sets location of the active cell</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setAlternativeExpression(boolean)">setAlternativeExpression</a></strong>(boolean b)</code> <div class="block">whether alternate expression evaluation is on</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setAlternativeFormula(boolean)">setAlternativeFormula</a></strong>(boolean b)</code> <div class="block">whether alternative formula entry is on</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a><<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html" title="class in org.apache.poi.hssf.usermodel">HSSFCell</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setArrayFormula(java.lang.String,%20org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a></strong>(java.lang.String formula, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range)</code> <div class="block">Sets array formula to specified region for result.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setAutobreaks(boolean)">setAutobreaks</a></strong>(boolean b)</code> <div class="block">show automatic page breaks or not</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFAutoFilter.html" title="class in org.apache.poi.hssf.usermodel">HSSFAutoFilter</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range)</code> <div class="block">Enable filtering for a range of cells</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnBreak(int)">setColumnBreak</a></strong>(int column)</code> <div class="block">Sets a page break at the indicated column.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnGroupCollapsed(int,%20boolean)">setColumnGroupCollapsed</a></strong>(int columnNumber, boolean collapsed)</code> <div class="block">Expands or collapses a column group.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnHidden(int,%20boolean)">setColumnHidden</a></strong>(int columnIndex, boolean hidden)</code> <div class="block">Get the visibility state for a given column.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnWidth(int,%20int)">setColumnWidth</a></strong>(int columnIndex, int width)</code> <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/hssf/usermodel/HSSFSheet.html#setDefaultColumnStyle(int,%20org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a></strong>(int column, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a> style)</code> <div class="block">Sets the default column style for a given column.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a></strong>(int width)</code> <div class="block">set the default column width for the sheet (if the columns do not define their own width) in characters</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDefaultRowHeight(short)">setDefaultRowHeight</a></strong>(short height)</code> <div class="block">set the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a></strong>(float height)</code> <div class="block">set the default row height for the sheet (if the rows do not define their own height) in points</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDialog(boolean)">setDialog</a></strong>(boolean b)</code> <div class="block">set whether sheet is a dialog sheet or not</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a></strong>(boolean show)</code> <div class="block">Sets whether the formulas are shown in a viewer.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></strong>(boolean show)</code> <div class="block">Sets whether the gridlines are shown in a viewer.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDisplayGuts(boolean)">setDisplayGuts</a></strong>(boolean b)</code> <div class="block">set whether to display the guts or not</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></strong>(boolean show)</code> <div class="block">Sets whether the RowColHeadings are shown in a viewer.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setDisplayZeros(boolean)">setDisplayZeros</a></strong>(boolean value)</code> <div class="block">Set whether the window should show 0 (zero) in cells containing zero value.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setFitToPage(boolean)">setFitToPage</a></strong>(boolean b)</code> <div class="block">fit to page option is on</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code> <div class="block">Control if Excel should be asked to recalculate all formulas on this sheet when the workbook is opened.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setGridsPrinted(boolean)">setGridsPrinted</a></strong>(boolean value)</code> <div class="block">set whether gridlines printed.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></strong>(boolean value)</code> <div class="block">determines whether the output is horizontally centered on the page.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setMargin(short,%20double)">setMargin</a></strong>(short margin, double size)</code> <div class="block">Sets the size of the margin in inches.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></strong>(boolean show)</code> <div class="block">Turns on or off the printing of gridlines.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setPrintRowAndColumnHeadings(boolean)">setPrintRowAndColumnHeadings</a></strong>(boolean show)</code> <div class="block">Turns on or off the printing of row and column headings.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> columnRangeRef)</code> <div class="block">Sets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> rowRangeRef)</code> <div class="block">Sets the repeating rows used when printing the sheet, as found in File->PageSetup->Sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRightToLeft(boolean)">setRightToLeft</a></strong>(boolean value)</code> <div class="block">Sets whether the worksheet is displayed from right to left instead of from left to right.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRowBreak(int)">setRowBreak</a></strong>(int row)</code> <div class="block">Sets a page break at the indicated row Breaks occur above the specified row and left of the specified column inclusive.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int rowIndex, boolean collapse)</code> <div class="block">Set view state of a grouped range of rows</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a></strong>(boolean b)</code> <div class="block">set if row summaries appear below detail in the outline</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setRowSumsRight(boolean)">setRowSumsRight</a></strong>(boolean b)</code> <div class="block">set if col summaries appear right of the detail in the outline</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setSelected(boolean)">setSelected</a></strong>(boolean sel)</code> <div class="block">Sets whether sheet is selected.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a></strong>(boolean value)</code> <div class="block">determines whether the output is vertically centered on the page.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setZoom(int)">setZoom</a></strong>(int scale)</code> <div class="block">Window zoom magnification for current view representing percent values.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setZoom(int,%20int)">setZoom</a></strong>(int numerator, int denominator)</code> <div class="block">Sets the zoom magnification for the sheet.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>protected void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#shiftMerged(int,%20int,%20int,%20boolean)">shiftMerged</a></strong>(int startRow, int endRow, @@ -1033,7 +1024,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/hssf/usermodel/HSSFSheet.html#shiftRows(int,%20int,%20int)">shiftRows</a></strong>(int startRow, int endRow, @@ -1041,7 +1032,7 @@ implements <a href="../../../../../org/a <div class="block">Shifts rows between startRow and endRow n number of rows.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a></strong>(int startRow, int endRow, @@ -1051,7 +1042,7 @@ implements <a href="../../../../../org/a <div class="block">Shifts rows between startRow and endRow n number of rows.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean,%20boolean)">shiftRows</a></strong>(int startRow, int endRow, @@ -1062,7 +1053,7 @@ implements <a href="../../../../../org/a <div class="block">Shifts rows between startRow and endRow n number of rows.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#showInPane(int,%20int)">showInPane</a></strong>(int toprow, int leftcol)</code> @@ -1070,34 +1061,34 @@ implements <a href="../../../../../org/a file is first opened in a viewer.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#ungroupColumn(int,%20int)">ungroupColumn</a></strong>(int fromColumn, int toColumn)</code> <div class="block">Ungroup a range of columns that were previously grouped</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#ungroupRow(int,%20int)">ungroupRow</a></strong>(int fromRow, int toRow)</code> <div class="block">Ungroup a range of rows that were previously grouped</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>protected void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#validateColumn(int)">validateColumn</a></strong>(int column)</code> <div class="block">Runs a bounds check for column numbers</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#validateMergedRegions()">validateMergedRegions</a></strong>()</code> <div class="block">Verify that merged regions do not intersect multi-cell array formulas and no merged regions intersect another merged region in this sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>protected void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#validateRow(int)">validateRow</a></strong>(int row)</code> <div class="block">Runs a bounds check for row numbers</div> @@ -2375,10 +2366,7 @@ implements <a href="../../../../../org/a <div class="block">Sets the zoom magnification for the sheet. The zoom is expressed as a fraction. For example to express a zoom of 75% use 3 for the numerator and 4 for the denominator.</div> -<dl> -<dt><strong>Specified by:</strong></dt> -<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int,%20int)">setZoom</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>numerator</code> - The numerator for the zoom magnification.</dd><dd><code>denominator</code> - The denominator for the zoom magnification.</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setZoom(int)"><code>setZoom(int)</code></a></dd></dl> +<dl><dt><span class="strong">Parameters:</span></dt><dd><code>numerator</code> - The numerator for the zoom magnification.</dd><dd><code>denominator</code> - The denominator for the zoom magnification.</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setZoom(int)"><code>setZoom(int)</code></a></dd></dl> </li> </ul> <a name="setZoom(int)"> @@ -3059,22 +3047,6 @@ implements <a href="../../../../../org/a <dt><span class="strong">Parameters:</span></dt><dd><code>column</code> - the column index</dd><dd><code>useMergedCells</code> - whether to use the contents of merged cells when calculating the width of the column</dd></dl> </li> </ul> -<a name="getCellComment(int, int)"> -<!-- --> -</a> -<ul class="blockList"> -<li class="blockList"> -<h4>getCellComment</h4> -<pre>public <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFComment.html" title="class in org.apache.poi.hssf.usermodel">HSSFComment</a> getCellComment(int row, - int column)</pre> -<div class="block"><span class="strong">Deprecated.</span> <i>as of 2015-11-23 (circa POI 3.14beta1). Use <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getCellComment(org.apache.poi.ss.util.CellAddress)"><code>getCellComment(CellAddress)</code></a> instead.</i></div> -<div class="block">Returns cell comment for the specified row and column</div> -<dl> -<dt><strong>Specified by:</strong></dt> -<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(int,%20int)">getCellComment</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">Returns:</span></dt><dd>cell comment or <code>null</code> if not found</dd></dl> -</li> -</ul> <a name="getCellComment(org.apache.poi.ss.util.CellAddress)"> <!-- --> </a>
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
