You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2015/11/01 23:50:53 UTC
svn commit: r1711857 [3/5] - in /poi/site/publish: ./ apidocs/
apidocs/org/apache/poi/ apidocs/org/apache/poi/hslf/model/textproperties/
apidocs/org/apache/poi/hslf/model/textproperties/class-use/
apidocs/org/apache/poi/hslf/usermodel/ apidocs/org/apac...
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html?rev=1711857&r1=1711856&r2=1711857&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html Sun Nov 1 22:50:51 2015
@@ -147,27 +147,33 @@ implements <a href="../../../../../org/a
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#create(org.apache.poi.hssf.usermodel.HSSFWorkbook)">create</a></strong>(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a> book)</code> </td>
</tr>
<tr class="altColor">
+<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFName.html" title="class in org.apache.poi.hssf.usermodel">HSSFName</a></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#createName()">createName</a></strong>()</code>
+<div class="block">Return the underlying workbook</div>
+</td>
+</tr>
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/ptg/Ptg.html" title="class in org.apache.poi.ss.formula.ptg">Ptg</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#get3DReferencePtg(org.apache.poi.ss.util.AreaReference,%20org.apache.poi.ss.formula.SheetIdentifier)">get3DReferencePtg</a></strong>(<a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a> areaRef,
<a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html" title="class in org.apache.poi.ss.formula">SheetIdentifier</a> sheet)</code>
<div class="block">Produce the appropriate Ptg for a 3d area reference</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/ptg/Ptg.html" title="class in org.apache.poi.ss.formula.ptg">Ptg</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#get3DReferencePtg(org.apache.poi.ss.util.CellReference,%20org.apache.poi.ss.formula.SheetIdentifier)">get3DReferencePtg</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a> cr,
<a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html" title="class in org.apache.poi.ss.formula">SheetIdentifier</a> sheet)</code>
<div class="block">Produce the appropriate Ptg for a 3d cell reference</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalName.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalName</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getExternalName(int,%20int)">getExternalName</a></strong>(int externSheetIndex,
int externNameIndex)</code>
<div class="block">HSSF Only - fetch the external-style name details</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalName.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalName</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getExternalName(java.lang.String,%20java.lang.String,%20int)">getExternalName</a></strong>(java.lang.String nameName,
java.lang.String sheetName,
@@ -175,13 +181,13 @@ implements <a href="../../../../../org/a
<div class="block">XSSF Only - fetch the external-style name details</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getExternalSheet(int)">getExternalSheet</a></strong>(int externSheetIndex)</code>
<div class="block">HSSF Only - fetch the external-style sheet details</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getExternalSheet(java.lang.String,%20java.lang.String,%20int)">getExternalSheet</a></strong>(java.lang.String firstSheetName,
java.lang.String lastSheetName,
@@ -189,81 +195,83 @@ implements <a href="../../../../../org/a
<div class="block">XSSF Only - fetch the external-style sheet details</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/HSSFEvaluationWorkbook.html#getExternalSheetIndex(java.lang.String)">getExternalSheetIndex</a></strong>(java.lang.String sheetName)</code>
<div class="block">gets the externSheet index for a sheet from this workbook</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/HSSFEvaluationWorkbook.html#getExternalSheetIndex(java.lang.String,%20java.lang.String)">getExternalSheetIndex</a></strong>(java.lang.String workbookName,
java.lang.String sheetName)</code>
<div class="block">gets the externSheet index for a sheet from an external workbook</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/ptg/Ptg.html" title="class in org.apache.poi.ss.formula.ptg">Ptg</a>[]</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getFormulaTokens(org.apache.poi.ss.formula.EvaluationCell)">getFormulaTokens</a></strong>(<a href="../../../../../org/apache/poi/ss/formula/EvaluationCell.html" title="interface in org.apache.poi.ss.formula">EvaluationCell</a> evalCell)</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationName.html" title="interface in org.apache.poi.ss.formula">EvaluationName</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getName(org.apache.poi.ss.formula.ptg.NamePtg)">getName</a></strong>(<a href="../../../../../org/apache/poi/ss/formula/ptg/NamePtg.html" title="class in org.apache.poi.ss.formula.ptg">NamePtg</a> namePtg)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationName.html" title="interface in org.apache.poi.ss.formula">EvaluationName</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getName(java.lang.String,%20int)">getName</a></strong>(java.lang.String name,
int sheetIndex)</code>
<div class="block">Lookup a named range by its name.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getNameText(org.apache.poi.ss.formula.ptg.NamePtg)">getNameText</a></strong>(<a href="../../../../../org/apache/poi/ss/formula/ptg/NamePtg.html" title="class in org.apache.poi.ss.formula.ptg">NamePtg</a> namePtg)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getNameXPtg(java.lang.String,%20org.apache.poi.ss.formula.SheetIdentifier)">getNameXPtg</a></strong>(java.lang.String name,
- <a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html" title="class in org.apache.poi.ss.formula">SheetIdentifier</a> sheet)</code> </td>
+ <a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html" title="class in org.apache.poi.ss.formula">SheetIdentifier</a> sheet)</code>
+<div class="block">Return an external name (named range, function, user-defined function) Ptg</div>
+</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationSheet.html" title="interface in org.apache.poi.ss.formula">EvaluationSheet</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheet(int)">getSheet</a></strong>(int sheetIndex)</code> </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/HSSFEvaluationWorkbook.html#getSheetFirstNameByExternSheet(int)">getSheetFirstNameByExternSheet</a></strong>(int externSheetIndex)</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/HSSFEvaluationWorkbook.html#getSheetIndex(org.apache.poi.ss.formula.EvaluationSheet)">getSheetIndex</a></strong>(<a href="../../../../../org/apache/poi/ss/formula/EvaluationSheet.html" title="interface in org.apache.poi.ss.formula">EvaluationSheet</a> evalSheet)</code> </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/HSSFEvaluationWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex</a></strong>(java.lang.String sheetName)</code>
<div class="block">Finds a sheet index by case insensitive name.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheetLastNameByExternSheet(int)">getSheetLastNameByExternSheet</a></strong>(int externSheetIndex)</code> </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/HSSFEvaluationWorkbook.html#getSheetName(int)">getSheetName</a></strong>(int sheetIndex)</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/SpreadsheetVersion.html" title="enum in org.apache.poi.ss">SpreadsheetVersion</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSpreadsheetVersion()">getSpreadsheetVersion</a></strong>()</code>
<div class="block">Returns an enum holding spreadhseet properties specific to an Excel version (
max column and row numbers, max arguments to a function, etc.)</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/udf/UDFFinder.html" title="interface in org.apache.poi.ss.formula.udf">UDFFinder</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getUDFFinder()">getUDFFinder</a></strong>()</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#resolveNameXText(org.apache.poi.ss.formula.ptg.NameXPtg)">resolveNameXText</a></strong>(<a href="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</a> n)</code> </td>
</tr>
@@ -298,6 +306,21 @@ implements <a href="../../../../../org/a
<pre>public static <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFEvaluationWorkbook</a> create(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a> book)</pre>
</li>
</ul>
+<a name="createName()">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>createName</h4>
+<pre>public <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFName.html" title="class in org.apache.poi.hssf.usermodel">HSSFName</a> createName()</pre>
+<div class="block"><strong>Description copied from interface: <code><a href="../../../../../org/apache/poi/ss/formula/FormulaParsingWorkbook.html#createName()">FormulaParsingWorkbook</a></code></strong></div>
+<div class="block">Return the underlying workbook</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code><a href="../../../../../org/apache/poi/ss/formula/FormulaParsingWorkbook.html#createName()">createName</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/formula/FormulaParsingWorkbook.html" title="interface in org.apache.poi.ss.formula">FormulaParsingWorkbook</a></code></dd>
+</dl>
+</li>
+</ul>
<a name="getExternalSheetIndex(java.lang.String)">
<!-- -->
</a>
@@ -369,6 +392,7 @@ implements <a href="../../../../../org/a
<h4>getNameXPtg</h4>
<pre>public <a href="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</a> getNameXPtg(java.lang.String name,
<a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html" title="class in org.apache.poi.ss.formula">SheetIdentifier</a> sheet)</pre>
+<div class="block">Return an external name (named range, function, user-defined function) Ptg</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/formula/FormulaParsingWorkbook.html#getNameXPtg(java.lang.String,%20org.apache.poi.ss.formula.SheetIdentifier)">getNameXPtg</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/formula/FormulaParsingWorkbook.html" title="interface in org.apache.poi.ss.formula">FormulaParsingWorkbook</a></code></dd>
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=1711857&r1=1711856&r2=1711857&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 Sun Nov 1 22:50:51 2015
@@ -192,46 +192,38 @@ 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/hssf/usermodel/HSSFSheet.html#addMergedRegion(org.apache.poi.ss.util.Region)">addMergedRegion</a></strong>(<a href="../../../../../org/apache/poi/ss/util/Region.html" title="class in org.apache.poi.ss.util">Region</a> region)</code>
-<div class="block"><strong>Deprecated.</strong>
-<div class="block"><i>(Aug-2008) use <tt>CellRangeAddress</tt> instead of <tt>Region</tt></i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#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="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#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/hssf/usermodel/HSSFSheet.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><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#createDrawingPatriarch()">createDrawingPatriarch</a></strong>()</code>
<div class="block">Creates the top-level drawing patriarch.</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#createFreezePane(int,%20int)">createFreezePane</a></strong>(int colSplit,
int rowSplit)</code>
<div class="block">Creates a split (freezepane).</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#createFreezePane(int,%20int,%20int,%20int)">createFreezePane</a></strong>(int colSplit,
int rowSplit,
@@ -240,13 +232,13 @@ implements <a href="../../../../../org/a
<div class="block">Creates a split (freezepane).</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#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="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#createSplitPane(int,%20int,%20int,%20int,%20int)">createSplitPane</a></strong>(int xSplitPos,
int ySplitPos,
@@ -256,7 +248,7 @@ implements <a href="../../../../../org/a
<div class="block">Creates a split pane.</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#dumpDrawingRecords(boolean,%20java.io.PrintWriter)">dumpDrawingRecords</a></strong>(boolean fat,
java.io.PrintWriter pw)</code>
@@ -264,49 +256,49 @@ implements <a href="../../../../../org/a
to the standard output.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>protected <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#findCellComment(int,%20int)">findCellComment</a></strong>(int row,
int column)</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#getAlternateExpression()">getAlternateExpression</a></strong>()</code>
<div class="block">whether alternate expression evaluation is on</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#getAlternateFormula()">getAlternateFormula</a></strong>()</code>
<div class="block">whether alternative formula entry is on</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#getAutobreaks()">getAutobreaks</a></strong>()</code>
<div class="block">show automatic page breaks or not</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<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">Returns cell comment for the specified row and 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#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/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="altColor">
+<tr class="rowColor">
<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
@@ -314,13 +306,13 @@ 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/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="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#getColumnWidth(short)">getColumnWidth</a></strong>(short columnIndex)</code>
<div class="block"><strong>Deprecated.</strong>
@@ -328,131 +320,131 @@ implements <a href="../../../../../org/a
</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>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="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#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/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="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#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><a href="../../../../../org/apache/poi/hssf/util/Region.html" title="class in org.apache.poi.hssf.util">Region</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getMergedRegionAt(int)">getMergedRegionAt</a></strong>(int index)</code>
<div class="block"><strong>Deprecated.</strong>
@@ -460,122 +452,122 @@ implements <a href="../../../../../org/a
</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/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/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>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#getVerticallyCenter(boolean)">getVerticallyCenter</a></strong>(boolean value)</code>
<div class="block"><strong>Deprecated.</strong>
@@ -583,20 +575,20 @@ implements <a href="../../../../../org/a
</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<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="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#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="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(short,%20short)">groupColumn</a></strong>(short fromColumn,
short toColumn)</code>
@@ -605,34 +597,34 @@ implements <a href="../../../../../org/a
</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#isColumnHidden(short)">isColumnHidden</a></strong>(short columnIndex)</code>
<div class="block"><strong>Deprecated.</strong>
@@ -640,166 +632,166 @@ implements <a href="../../../../../org/a
</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#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/hssf/usermodel/HSSFSheet.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/hssf/usermodel/HSSFSheet.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/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="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#isGridsPrinted()">isGridsPrinted</a></strong>()</code>
<div class="block">get 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#isPrintGridlines()">isPrintGridlines</a></strong>()</code>
<div class="block">Returns 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#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>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#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/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="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#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/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="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#setColumnGroupCollapsed(short,%20boolean)">setColumnGroupCollapsed</a></strong>(short columnNumber,
boolean collapsed)</code>
@@ -808,14 +800,14 @@ 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#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="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(short,%20boolean)">setColumnHidden</a></strong>(short columnIndex,
boolean hidden)</code>
@@ -824,7 +816,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#setColumnWidth(int,%20int)">setColumnWidth</a></strong>(int columnIndex,
int width)</code>
@@ -832,7 +824,7 @@ implements <a href="../../../../../org/a
<p/></div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html#setColumnWidth(short,%20short)">setColumnWidth</a></strong>(short columnIndex,
short width)</code>
@@ -841,21 +833,21 @@ 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#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="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#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="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(short)">setDefaultColumnWidth</a></strong>(short width)</code>
<div class="block"><strong>Deprecated.</strong>
@@ -863,160 +855,160 @@ implements <a href="../../../../../org/a
</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 newPrintGridlines)</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#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> columnRangeRef)</code>
<div class="block">Sets the repeating columns used when printing the sheet, as found in
File->PageSetup->Sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/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="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#setRightToLeft(boolean)">setRightToLeft</a></strong>(boolean value)</code>
<div class="block">Sets whether the worksheet is displayed from right to left instead of from left to right.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/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="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#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int rowIndex,
boolean collapse)</code>
<div class="block">Set view state of a groupped range of rows</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/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="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#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="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#setSelected(boolean)">setSelected</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#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/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,
@@ -1027,7 +1019,7 @@ implements <a href="../../../../../org/a
TODO: MODE , this is only row specific</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,
@@ -1035,7 +1027,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,
@@ -1045,7 +1037,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,
@@ -1056,7 +1048,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>
@@ -1064,7 +1056,7 @@ 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#showInPane(short,%20short)">showInPane</a></strong>(short toprow,
short leftcol)</code>
@@ -1072,14 +1064,14 @@ 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/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 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/hssf/usermodel/HSSFSheet.html#ungroupColumn(short,%20short)">ungroupColumn</a></strong>(short fromColumn,
short toColumn)</code>
@@ -1088,20 +1080,20 @@ implements <a href="../../../../../org/a
</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 groupped</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>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>
@@ -1650,16 +1642,6 @@ implements <a href="../../../../../org/a
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - false if not printed.</dd></dl>
</li>
</ul>
-<a name="addMergedRegion(org.apache.poi.ss.util.Region)">
-<!-- -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>addMergedRegion</h4>
-<pre>public int addMergedRegion(<a href="../../../../../org/apache/poi/ss/util/Region.html" title="class in org.apache.poi.ss.util">Region</a> region)</pre>
-<div class="block"><span class="strong">Deprecated.</span> <i>(Aug-2008) use <tt>CellRangeAddress</tt> instead of <tt>Region</tt></i></div>
-</li>
-</ul>
<a name="addMergedRegion(org.apache.poi.ss.util.CellRangeAddress)">
<!-- -->
</a>
@@ -1672,7 +1654,10 @@ implements <a href="../../../../../org/a
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegion(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegion</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>
+<dt><span class="strong">Returns:</span></dt><dd>index of this region</dd>
+<dt><span class="strong">Throws:</span></dt>
+<dd><code>java.lang.IllegalStateException</code> - if region intersects with an existing merged region
+ or multi-cell array formula on this sheet</dd></dl>
</li>
</ul>
<a name="setForceFormulaRecalculation(boolean)">
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/class-use/HSSFName.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/class-use/HSSFName.html?rev=1711857&r1=1711856&r2=1711857&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/class-use/HSSFName.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/class-use/HSSFName.html Sun Nov 1 22:50:51 2015
@@ -97,15 +97,19 @@
<tbody>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFName.html" title="class in org.apache.poi.hssf.usermodel">HSSFName</a></code></td>
+<td class="colLast"><span class="strong">HSSFEvaluationWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#createName()">createName</a></strong>()</code> </td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFName.html" title="class in org.apache.poi.hssf.usermodel">HSSFName</a></code></td>
<td class="colLast"><span class="strong">HSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#createName()">createName</a></strong>()</code>
<div class="block">creates a new named range and add it to the model</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFName.html" title="class in org.apache.poi.hssf.usermodel">HSSFName</a></code></td>
<td class="colLast"><span class="strong">HSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getName(java.lang.String)">getName</a></strong>(java.lang.String name)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFName.html" title="class in org.apache.poi.hssf.usermodel">HSSFName</a></code></td>
<td class="colLast"><span class="strong">HSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getNameAt(int)">getNameAt</a></strong>(int nameIndex)</code> </td>
</tr>
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress.html?rev=1711857&r1=1711856&r2=1711857&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress.html Sun Nov 1 22:50:51 2015
@@ -178,7 +178,7 @@ extends <a href="../../../../../org/apac
<!-- -->
</a>
<h3>Methods inherited from class org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></h3>
-<code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstColumn()">getFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstRow()">getFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastColumn()">getLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastRow()">getLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxColumn()">getMaxColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxRow()">getMaxRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinColumn()">getMinColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinRow()">getMinRow</a>, <a href="../../../../../org/apache/p
oi/ss/util/CellRangeAddressBase.html#getNumberOfCells()">getNumberOfCells</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullColumnRange()">isFullColumnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullRowRange()">isFullRowRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)">isInRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstColumn(int)">setFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstRow(int)">setFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastColumn(int)">setLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastRow(int)">setLastRow</a>, <a href="../../../../../org/apache/poi/s
s/util/CellRangeAddressBase.html#toString()">toString</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#validate(org.apache.poi.ss.SpreadsheetVersion)">validate</a></code></li>
+<code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstColumn()">getFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstRow()">getFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastColumn()">getLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastRow()">getLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxColumn()">getMaxColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxRow()">getMaxRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinColumn()">getMinColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinRow()">getMinRow</a>, <a href="../../../../../org/apache/p
oi/ss/util/CellRangeAddressBase.html#getNumberOfCells()">getNumberOfCells</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#intersects(org.apache.poi.ss.util.CellRangeAddressBase)">intersects</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullColumnRange()">isFullColumnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullRowRange()">isFullRowRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)">isInRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstColumn(int)">setFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstRow(int)">setFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastColumn(int)">setLastColumn</a>,
<a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastRow(int)">setLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#toString()">toString</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#validate(org.apache.poi.ss.SpreadsheetVersion)">validate</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress8Bit.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress8Bit.html?rev=1711857&r1=1711856&r2=1711857&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress8Bit.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/util/CellRangeAddress8Bit.html Sun Nov 1 22:50:51 2015
@@ -191,7 +191,7 @@ extends <a href="../../../../../org/apac
<!-- -->
</a>
<h3>Methods inherited from class org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html" title="class in org.apache.poi.ss.util">CellRangeAddressBase</a></h3>
-<code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstColumn()">getFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstRow()">getFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastColumn()">getLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastRow()">getLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxColumn()">getMaxColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxRow()">getMaxRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinColumn()">getMinColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinRow()">getMinRow</a>, <a href="../../../../../org/apache/p
oi/ss/util/CellRangeAddressBase.html#getNumberOfCells()">getNumberOfCells</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullColumnRange()">isFullColumnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullRowRange()">isFullRowRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)">isInRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstColumn(int)">setFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstRow(int)">setFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastColumn(int)">setLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastRow(int)">setLastRow</a>, <a href="../../../../../org/apache/poi/s
s/util/CellRangeAddressBase.html#toString()">toString</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#validate(org.apache.poi.ss.SpreadsheetVersion)">validate</a></code></li>
+<code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstColumn()">getFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getFirstRow()">getFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastColumn()">getLastColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getLastRow()">getLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxColumn()">getMaxColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMaxRow()">getMaxRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinColumn()">getMinColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#getMinRow()">getMinRow</a>, <a href="../../../../../org/apache/p
oi/ss/util/CellRangeAddressBase.html#getNumberOfCells()">getNumberOfCells</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#intersects(org.apache.poi.ss.util.CellRangeAddressBase)">intersects</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullColumnRange()">isFullColumnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isFullRowRange()">isFullRowRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#isInRange(int,%20int)">isInRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstColumn(int)">setFirstColumn</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setFirstRow(int)">setFirstRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastColumn(int)">setLastColumn</a>,
<a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#setLastRow(int)">setLastRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#toString()">toString</a>, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddressBase.html#validate(org.apache.poi.ss.SpreadsheetVersion)">validate</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org