You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2016/06/19 13:09:35 UTC
svn commit: r1749163 [13/14] - in /poi/site/publish: ./ apidocs/
apidocs/org/apache/poi/hssf/record/
apidocs/org/apache/poi/hssf/record/aggregates/
apidocs/org/apache/poi/hssf/record/class-use/
apidocs/org/apache/poi/hssf/record/common/ apidocs/org/apa...
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html?rev=1749163&r1=1749162&r2=1749163&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html Sun Jun 19 13:09:33 2016
@@ -295,7 +295,7 @@ implements <a href="../../../../../org/a
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#findFont(short,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></strong>(short boldWeight,
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#findFont(boolean,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></strong>(boolean bold,
short color,
short fontHeight,
java.lang.String name,
@@ -307,24 +307,39 @@ implements <a href="../../../../../org/a
</td>
</tr>
<tr class="altColor">
+<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#findFont(short,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></strong>(short boldWeight,
+ short color,
+ short fontHeight,
+ java.lang.String name,
+ boolean italic,
+ boolean strikeout,
+ short typeOffset,
+ byte underline)</code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 2. Use <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#findFont(boolean,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)"><code>findFont(boolean, short, short, String, boolean, boolean, short, byte)</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getActiveSheetIndex()">getActiveSheetIndex</a></strong>()</code>
<div class="block">Convenience method to get the active sheet.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.List<? extends <a href="../../../../../org/apache/poi/ss/usermodel/PictureData.html" title="interface in org.apache.poi.ss.usermodel">PictureData</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getAllPictures()">getAllPictures</a></strong>()</code>
<div class="block">Gets all pictures from the Workbook.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getCellStyleAt(int)">getCellStyleAt</a></strong>(int idx)</code>
<div class="block">Get the cell style object at the given index</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html" title="interface in org.apache.poi.ss.usermodel">CreationHelper</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getCreationHelper()">getCreationHelper</a></strong>()</code>
<div class="block">Returns an object that handles instantiating concrete
@@ -332,40 +347,40 @@ implements <a href="../../../../../org/a
and SXSSF.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getFirstVisibleTab()">getFirstVisibleTab</a></strong>()</code>
<div class="block">Gets the first tab that is displayed in the list of tabs in excel.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getFontAt(short)">getFontAt</a></strong>(short idx)</code>
<div class="block">Get the font at the given index number</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></strong>()</code>
<div class="block">Whether Excel will be asked to recalculate all formulas when the workbook is opened.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html" title="enum in org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getMissingCellPolicy()">getMissingCellPolicy</a></strong>()</code>
<div class="block">Retrieves the current policy on what to do when
getting missing or blank cells from a row.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Name.html" title="interface in org.apache.poi.ss.usermodel">Name</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getName(java.lang.String)">getName</a></strong>(java.lang.String name)</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Name.html" title="interface in org.apache.poi.ss.usermodel">Name</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getNameAt(int)">getNameAt</a></strong>(int nameIndex)</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/xssf/streaming/SXSSFWorkbook.html#getNameIndex(java.lang.String)">getNameIndex</a></strong>(java.lang.String name)</code>
<div class="block">Gets the defined name index by name<br/>
@@ -373,115 +388,115 @@ implements <a href="../../../../../org/a
this method performs a case-insensitive search.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.List<? extends <a href="../../../../../org/apache/poi/ss/usermodel/Name.html" title="interface in org.apache.poi.ss.usermodel">Name</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getNames(java.lang.String)">getNames</a></strong>(java.lang.String name)</code>
<div class="block">Returns all defined names with the given name.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getNumberOfFonts()">getNumberOfFonts</a></strong>()</code>
<div class="block">Get the number of fonts in the font table</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getNumberOfNames()">getNumberOfNames</a></strong>()</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/xssf/streaming/SXSSFWorkbook.html#getNumberOfSheets()">getNumberOfSheets</a></strong>()</code>
<div class="block">Get the number of spreadsheets in the 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/xssf/streaming/SXSSFWorkbook.html#getNumCellStyles()">getNumCellStyles</a></strong>()</code>
<div class="block">Get the number of styles the workbook contains</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getPrintArea(int)">getPrintArea</a></strong>(int sheetIndex)</code>
<div class="block">Retrieves the reference for the printarea of the specified sheet,
the sheet name is appended to the reference even if it was not specified.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getRandomAccessWindowSize()">getRandomAccessWindowSize</a></strong>()</code>
<div class="block">See the constructors for a more detailed description of the sliding window of rows.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getSheet(java.lang.String)">getSheet</a></strong>(java.lang.String name)</code>
<div class="block">Get sheet with the given name</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getSheetAt(int)">getSheetAt</a></strong>(int index)</code>
<div class="block">Get the Sheet object at the given index.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getSheetIndex(org.apache.poi.ss.usermodel.Sheet)">getSheetIndex</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a> sheet)</code>
<div class="block">Returns the index of the given sheet</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex</a></strong>(java.lang.String name)</code>
<div class="block">Returns the index of the sheet by his name</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getSheetName(int)">getSheetName</a></strong>(int sheet)</code>
<div class="block">Set the sheet name</div>
</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/xssf/streaming/SXSSFWorkbook.html#getSpreadsheetVersion()">getSpreadsheetVersion</a></strong>()</code>
<div class="block">Returns the spreadsheet version (EXCLE2007) of this workbook</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#getXSSFWorkbook()">getXSSFWorkbook</a></strong>()</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>protected boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#isDate1904()">isDate1904</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/xssf/streaming/SXSSFWorkbook.html#isHidden()">isHidden</a></strong>()</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/xssf/streaming/SXSSFWorkbook.html#isSheetHidden(int)">isSheetHidden</a></strong>(int sheetIx)</code>
<div class="block">Check whether a sheet is hidden.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#isSheetVeryHidden(int)">isSheetVeryHidden</a></strong>(int sheetIx)</code>
<div class="block">Check whether a sheet is very hidden.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
<div class="block">Alias for <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a> to allow
foreach loops</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#linkExternalWorkbook(java.lang.String,%20org.apache.poi.ss.usermodel.Workbook)">linkExternalWorkbook</a></strong>(java.lang.String name,
<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a> workbook)</code>
@@ -491,66 +506,66 @@ implements <a href="../../../../../org/a
the specified external workbook to be added to this one.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#removeName(int)">removeName</a></strong>(int index)</code>
<div class="block">Remove the defined name at the specified index</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#removeName(java.lang.String)">removeName</a></strong>(java.lang.String name)</code>
<div class="block">Remove a defined name by name</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#removePrintArea(int)">removePrintArea</a></strong>(int sheetIndex)</code>
<div class="block">Delete the printarea for the sheet specified</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#removeSheetAt(int)">removeSheetAt</a></strong>(int index)</code>
<div class="block">Removes sheet at the given index</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setActiveSheet(int)">setActiveSheet</a></strong>(int sheetIndex)</code>
<div class="block">Convenience method to set the active sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setCompressTempFiles(boolean)">setCompressTempFiles</a></strong>(boolean compress)</code>
<div class="block">Set whether temp files should be compressed.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setFirstVisibleTab(int)">setFirstVisibleTab</a></strong>(int sheetIndex)</code>
<div class="block">Sets the first tab that is displayed in the list of tabs in excel.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code>
<div class="block">Whether the application shall perform a full recalculation 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/xssf/streaming/SXSSFWorkbook.html#setHidden(boolean)">setHidden</a></strong>(boolean hiddenFlag)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy)">setMissingCellPolicy</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html" title="enum in org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a> missingCellPolicy)</code>
<div class="block">Sets the policy on what to do when
getting missing or blank cells from a row.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setPrintArea(int,%20int,%20int,%20int,%20int)">setPrintArea</a></strong>(int sheetIndex,
int startColumn,
@@ -560,20 +575,20 @@ implements <a href="../../../../../org/a
<div class="block">For the Convenience of Java Programmers maintaining pointers.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setPrintArea(int,%20java.lang.String)">setPrintArea</a></strong>(int sheetIndex,
java.lang.String reference)</code>
<div class="block">Sets the printarea for the sheet provided</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSelectedTab(int)">setSelectedTab</a></strong>(int index)</code>
<div class="block">Sets the tab whose data is actually seen when the sheet is opened.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSheetHidden(int,%20boolean)">setSheetHidden</a></strong>(int sheetIx,
boolean hidden)</code>
@@ -583,35 +598,35 @@ implements <a href="../../../../../org/a
created workbook or the one set via setActiveSheet()) cannot be hidden.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSheetHidden(int,%20int)">setSheetHidden</a></strong>(int sheetIx,
int hidden)</code>
<div class="block">Hide or unhide a sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSheetName(int,%20java.lang.String)">setSheetName</a></strong>(int sheet,
java.lang.String name)</code>
<div class="block">Set the sheet name.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSheetOrder(java.lang.String,%20int)">setSheetOrder</a></strong>(java.lang.String sheetname,
int pos)</code>
<div class="block">Sets the order of appearance for a given sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
<div class="block">Returns an iterator of the sheets in the workbook
in sheet order.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#write(java.io.OutputStream)">write</a></strong>(java.io.OutputStream stream)</code>
<div class="block">Write out this workbook to an Outputstream.</div>
@@ -1192,6 +1207,7 @@ public <a href="../../../../../org/
boolean strikeout,
short typeOffset,
byte underline)</pre>
+<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 2. Use <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#findFont(boolean,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)"><code>findFont(boolean, short, short, String, boolean, boolean, short, byte)</code></a> instead.</i></div>
<div class="block">Finds a font that matches the one with the supplied attributes</div>
<dl>
<dt><strong>Specified by:</strong></dt>
@@ -1199,6 +1215,27 @@ public <a href="../../../../../org/
<dt><span class="strong">Returns:</span></dt><dd>the font with the matched attributes or <code>null</code></dd></dl>
</li>
</ul>
+<a name="findFont(boolean, short, short, java.lang.String, boolean, boolean, short, byte)">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>findFont</h4>
+<pre>public <a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a> findFont(boolean bold,
+ short color,
+ short fontHeight,
+ java.lang.String name,
+ boolean italic,
+ boolean strikeout,
+ short typeOffset,
+ byte underline)</pre>
+<div class="block">Finds a font that matches the one with the supplied attributes</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#findFont(boolean,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></dd>
+<dt><span class="strong">Returns:</span></dt><dd>the font with the matched attributes or <code>null</code></dd></dl>
+</li>
+</ul>
<a name="getNumberOfFonts()">
<!-- -->
</a>
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html?rev=1749163&r1=1749162&r2=1749163&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html Sun Jun 19 13:09:33 2016
@@ -108,21 +108,6 @@ implements <a href="../../../../../org/a
<div class="summary">
<ul class="blockList">
<li class="blockList">
-<!-- =========== FIELD SUMMARY =========== -->
-<ul class="blockList">
-<li class="blockList"><a name="field_summary">
-<!-- -->
-</a>
-<h3>Field Summary</h3>
-<ul class="blockList">
-<li class="blockList"><a name="fields_inherited_from_class_org.apache.poi.ss.usermodel.ConditionalFormattingRule">
-<!-- -->
-</a>
-<h3>Fields inherited from interface org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></h3>
-<code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS">CONDITION_TYPE_CELL_VALUE_IS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_FORMULA">CONDITION_TYPE_FORMULA</a></code></li>
-</ul>
-</li>
-</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method_summary">
@@ -180,48 +165,42 @@ implements <a href="../../../../../org/a
<td class="colFirst"><code>byte</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getComparisonOperation()">getComparisonOperation</a></strong>()</code>
<div class="block">The comparison function used when the type of conditional formatting is set to
- <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS"><code>ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS</code></a></div>
+ <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS"><code>ConditionType.CELL_VALUE_IS</code></a></div>
</td>
</tr>
<tr class="rowColor">
-<td class="colFirst"><code>byte</code></td>
+<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getConditionType()">getConditionType</a></strong>()</code>
<div class="block">Type of conditional formatting rule.</div>
</td>
</tr>
<tr class="altColor">
-<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getConditionTypeType()">getConditionTypeType</a></strong>()</code>
-<div class="block">Type of conditional formatting rule.</div>
-</td>
-</tr>
-<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataBarFormatting.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataBarFormatting</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getDataBarFormatting()">getDataBarFormatting</a></strong>()</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFFontFormatting.html" title="class in org.apache.poi.xssf.usermodel">XSSFFontFormatting</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getFontFormatting()">getFontFormatting</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/xssf/usermodel/XSSFConditionalFormattingRule.html#getFormula1()">getFormula1</a></strong>()</code>
<div class="block">The formula used to evaluate the first operand for the conditional formatting rule.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getFormula2()">getFormula2</a></strong>()</code>
<div class="block">The formula used to evaluate the second operand of the comparison when
- comparison type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS"><code>ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS</code></a> and operator
+ comparison type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS"><code>ConditionType.CELL_VALUE_IS</code></a> and operator
is either <a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html#BETWEEN"><code>ComparisonOperator.BETWEEN</code></a> or <a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html#NOT_BETWEEN"><code>ComparisonOperator.NOT_BETWEEN</code></a></div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFIconMultiStateFormatting.html" title="class in org.apache.poi.xssf.usermodel">XSSFIconMultiStateFormatting</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getMultiStateFormatting()">getMultiStateFormatting</a></strong>()</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPatternFormatting.html" title="class in org.apache.poi.xssf.usermodel">XSSFPatternFormatting</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getPatternFormatting()">getPatternFormatting</a></strong>()</code> </td>
</tr>
@@ -403,28 +382,11 @@ implements <a href="../../../../../org/a
<ul class="blockList">
<li class="blockList">
<h4>getConditionType</h4>
-<pre>public byte getConditionType()</pre>
-<div class="block">Type of conditional formatting rule.
- <p>
- MUST be one of the IDs of a <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel"><code>ConditionType</code></a>
- </p></div>
-<dl>
-<dt><strong>Specified by:</strong></dt>
-<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionType()">getConditionType</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></code></dd>
-<dt><span class="strong">Returns:</span></dt><dd>the type of condition</dd></dl>
-</li>
-</ul>
-<a name="getConditionTypeType()">
-<!-- -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>getConditionTypeType</h4>
-<pre>public <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> getConditionTypeType()</pre>
+<pre>public <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> getConditionType()</pre>
<div class="block">Type of conditional formatting rule.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
-<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionTypeType()">getConditionTypeType</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></code></dd>
+<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionType()">getConditionType</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the type of condition</dd></dl>
</li>
</ul>
@@ -436,7 +398,7 @@ implements <a href="../../../../../org/a
<h4>getComparisonOperation</h4>
<pre>public byte getComparisonOperation()</pre>
<div class="block">The comparison function used when the type of conditional formatting is set to
- <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS"><code>ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS</code></a>
+ <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS"><code>ConditionType.CELL_VALUE_IS</code></a>
<p>
MUST be a constant from <a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html" title="class in org.apache.poi.ss.usermodel"><code>ComparisonOperator</code></a>
</p></div>
@@ -455,13 +417,13 @@ implements <a href="../../../../../org/a
<pre>public java.lang.String getFormula1()</pre>
<div class="block">The formula used to evaluate the first operand for the conditional formatting rule.
<p>
- If the condition type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS"><code>ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS</code></a>,
+ If the condition type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS"><code>ConditionType.CELL_VALUE_IS</code></a>,
this field is the first operand of the comparison.
- If type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_FORMULA"><code>ConditionalFormattingRule.CONDITION_TYPE_FORMULA</code></a>, this formula is used
+ If type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FORMULA"><code>ConditionType.FORMULA</code></a>, this formula is used
to determine if the conditional formatting is applied.
</p>
<p>
- If comparison type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_FORMULA"><code>ConditionalFormattingRule.CONDITION_TYPE_FORMULA</code></a> the formula MUST be a Boolean function
+ If comparison type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FORMULA"><code>ConditionType.FORMULA</code></a> the formula MUST be a Boolean function
</p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
@@ -477,7 +439,7 @@ implements <a href="../../../../../org/a
<h4>getFormula2</h4>
<pre>public java.lang.String getFormula2()</pre>
<div class="block">The formula used to evaluate the second operand of the comparison when
- comparison type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS"><code>ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS</code></a> and operator
+ comparison type is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS"><code>ConditionType.CELL_VALUE_IS</code></a> and operator
is either <a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html#BETWEEN"><code>ComparisonOperator.BETWEEN</code></a> or <a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html#NOT_BETWEEN"><code>ComparisonOperator.NOT_BETWEEN</code></a></div>
<dl>
<dt><strong>Specified by:</strong></dt>
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html?rev=1749163&r1=1749162&r2=1749163&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html Sun Jun 19 13:09:33 2016
@@ -170,7 +170,11 @@ implements <a href="../../../../../org/a
</tr>
<tr class="altColor">
<td class="colFirst"><code>java.lang.String[]</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#getExplicitListValues()">getExplicitListValues</a></strong>()</code> </td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#getExplicitListValues()">getExplicitListValues</a></strong>()</code>
+<div class="block">If validation type is <a href="../../../../../org/apache/poi/ss/usermodel/DataValidationConstraint.ValidationType.html#LIST"><code>DataValidationConstraint.ValidationType.LIST</code></a>
+ and <code>formula1</code> was comma-separated literal values rather than a range or named range,
+ returns list of literal values.</div>
+</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.lang.String</code></td>
@@ -189,7 +193,7 @@ implements <a href="../../../../../org/a
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#getValidationType()">getValidationType</a></strong>()</code> </td>
</tr>
<tr class="rowColor">
-<td class="colFirst"><code>protected boolean</code></td>
+<td class="colFirst"><code>protected static boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#isFormulaEmpty(java.lang.String)">isFormulaEmpty</a></strong>(java.lang.String formula1)</code> </td>
</tr>
<tr class="altColor">
@@ -197,7 +201,7 @@ implements <a href="../../../../../org/a
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#prettyPrint()">prettyPrint</a></strong>()</code> </td>
</tr>
<tr class="rowColor">
-<td class="colFirst"><code>protected java.lang.String</code></td>
+<td class="colFirst"><code>protected static java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidationConstraint.html#removeLeadingEquals(java.lang.String)">removeLeadingEquals</a></strong>(java.lang.String formula1)</code> </td>
</tr>
<tr class="altColor">
@@ -305,6 +309,11 @@ implements <a href="../../../../../org/a
<li class="blockList">
<h4>getExplicitListValues</h4>
<pre>public java.lang.String[] getExplicitListValues()</pre>
+<div class="block"><strong>Description copied from interface: <code><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationConstraint.html#getExplicitListValues()">DataValidationConstraint</a></code></strong></div>
+<div class="block">If validation type is <a href="../../../../../org/apache/poi/ss/usermodel/DataValidationConstraint.ValidationType.html#LIST"><code>DataValidationConstraint.ValidationType.LIST</code></a>
+ and <code>formula1</code> was comma-separated literal values rather than a range or named range,
+ returns list of literal values.
+ Otherwise returns <code>null</code>.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationConstraint.html#getExplicitListValues()">getExplicitListValues</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationConstraint.html" title="interface in org.apache.poi.ss.usermodel">DataValidationConstraint</a></code></dd>
@@ -397,7 +406,7 @@ implements <a href="../../../../../org/a
<ul class="blockList">
<li class="blockList">
<h4>removeLeadingEquals</h4>
-<pre>protected java.lang.String removeLeadingEquals(java.lang.String formula1)</pre>
+<pre>protected static java.lang.String removeLeadingEquals(java.lang.String formula1)</pre>
</li>
</ul>
<a name="setFormula2(java.lang.String)">
@@ -445,7 +454,7 @@ implements <a href="../../../../../org/a
<ul class="blockList">
<li class="blockList">
<h4>isFormulaEmpty</h4>
-<pre>protected boolean isFormulaEmpty(java.lang.String formula1)</pre>
+<pre>protected static boolean isFormulaEmpty(java.lang.String formula1)</pre>
</li>
</ul>
<a name="prettyPrint()">
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html?rev=1749163&r1=1749162&r2=1749163&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html Sun Jun 19 13:09:33 2016
@@ -343,7 +343,7 @@ implements <a href="../../../../../org/a
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class in org.apache.poi.xssf.usermodel">XSSFFont</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#findFont(short,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></strong>(short boldWeight,
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#findFont(boolean,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></strong>(boolean bold,
short color,
short fontHeight,
java.lang.String name,
@@ -355,96 +355,111 @@ implements <a href="../../../../../org/a
</td>
</tr>
<tr class="altColor">
+<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class in org.apache.poi.xssf.usermodel">XSSFFont</a></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#findFont(short,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></strong>(short boldWeight,
+ short color,
+ short fontHeight,
+ java.lang.String name,
+ boolean italic,
+ boolean strikeout,
+ short typeOffset,
+ byte underline)</code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15. Use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#findFont(boolean,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)"><code>findFont(boolean, short, short, String, boolean, boolean, short, byte)</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getActiveSheetIndex()">getActiveSheetIndex</a></strong>()</code>
<div class="block">Convenience method to get the active sheet.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/openxml4j/opc/PackagePart.html" title="class in org.apache.poi.openxml4j.opc">PackagePart</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getAllEmbedds()">getAllEmbedds</a></strong>()</code>
<div class="block">Get the document's embedded files.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPictureData.html" title="class in org.apache.poi.xssf.usermodel">XSSFPictureData</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getAllPictures()">getAllPictures</a></strong>()</code>
<div class="block">Gets all pictures from the Workbook.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/model/CalculationChain.html" title="class in org.apache.poi.xssf.model">CalculationChain</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCalculationChain()">getCalculationChain</a></strong>()</code>
<div class="block">Return the <a href="../../../../../org/apache/poi/xssf/model/CalculationChain.html" title="class in org.apache.poi.xssf.model"><code>CalculationChain</code></a> object for this workbook</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html" title="class in org.apache.poi.xssf.usermodel">XSSFCellStyle</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCellStyleAt(int)">getCellStyleAt</a></strong>(int idx)</code>
<div class="block">Get the cell style object at the given index</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCreationHelper.html" title="class in org.apache.poi.xssf.usermodel">XSSFCreationHelper</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCreationHelper()">getCreationHelper</a></strong>()</code>
<div class="block">Returns an object that handles instantiating concrete
classes of the various instances for XSSF.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCTWorkbook()">getCTWorkbook</a></strong>()</code>
<div class="block">Return the underlying XML bean</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.Collection<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFMap.html" title="class in org.apache.poi.xssf.usermodel">XSSFMap</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCustomXMLMappings()">getCustomXMLMappings</a></strong>()</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/xssf/model/ExternalLinksTable.html" title="class in org.apache.poi.xssf.model">ExternalLinksTable</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getExternalLinksTable()">getExternalLinksTable</a></strong>()</code>
<div class="block">Returns the list of <a href="../../../../../org/apache/poi/xssf/model/ExternalLinksTable.html" title="class in org.apache.poi.xssf.model"><code>ExternalLinksTable</code></a> object for 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/xssf/usermodel/XSSFWorkbook.html#getFirstVisibleTab()">getFirstVisibleTab</a></strong>()</code>
<div class="block">Gets the first tab that is displayed in the list of tabs in excel.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class in org.apache.poi.xssf.usermodel">XSSFFont</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getFontAt(short)">getFontAt</a></strong>(short idx)</code>
<div class="block">Get the font at the given index number</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></strong>()</code>
<div class="block">Whether Excel will be asked to recalculate all formulas when the workbook is opened.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/model/MapInfo.html" title="class in org.apache.poi.xssf.model">MapInfo</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getMapInfo()">getMapInfo</a></strong>()</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html" title="enum in org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getMissingCellPolicy()">getMissingCellPolicy</a></strong>()</code>
<div class="block">Retrieves the current policy on what to do when
getting missing or blank cells from a row.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class in org.apache.poi.xssf.usermodel">XSSFName</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getName(java.lang.String)">getName</a></strong>(java.lang.String name)</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class in org.apache.poi.xssf.usermodel">XSSFName</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getNameAt(int)">getNameAt</a></strong>(int nameIndex)</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/xssf/usermodel/XSSFWorkbook.html#getNameIndex(java.lang.String)">getNameIndex</a></strong>(java.lang.String name)</code>
<div class="block">Gets the named range index by his name
@@ -452,159 +467,159 @@ implements <a href="../../../../../org/a
this method performs a case-insensitive search.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class in org.apache.poi.xssf.usermodel">XSSFName</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getNames(java.lang.String)">getNames</a></strong>(java.lang.String name)</code>
<div class="block">Returns all defined names with the given name.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getNumberOfFonts()">getNumberOfFonts</a></strong>()</code>
<div class="block">Get the number of fonts in the 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/xssf/usermodel/XSSFWorkbook.html#getNumberOfNames()">getNumberOfNames</a></strong>()</code>
<div class="block">Get the number of named ranges in the this workbook</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getNumberOfSheets()">getNumberOfSheets</a></strong>()</code>
<div class="block">Get the number of worksheets in the 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/xssf/usermodel/XSSFWorkbook.html#getNumCellStyles()">getNumCellStyles</a></strong>()</code>
<div class="block">Get the number of styles the workbook contains</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getPivotTables()">getPivotTables</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/xssf/usermodel/XSSFWorkbook.html#getPrintArea(int)">getPrintArea</a></strong>(int sheetIndex)</code>
<div class="block">Retrieves the reference for the printarea of the specified sheet, the sheet name is appended to the reference even if it was not specified.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/model/SharedStringsTable.html" title="class in org.apache.poi.xssf.model">SharedStringsTable</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSharedStringSource()">getSharedStringSource</a></strong>()</code>
<div class="block">Returns SharedStringsTable - tha cache of string for this workbook</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSheet(java.lang.String)">getSheet</a></strong>(java.lang.String name)</code>
<div class="block">Get sheet with the given name (case insensitive match)</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSheetAt(int)">getSheetAt</a></strong>(int index)</code>
<div class="block">Get the XSSFSheet object at the given index.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSheetIndex(org.apache.poi.ss.usermodel.Sheet)">getSheetIndex</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a> sheet)</code>
<div class="block">Returns the index of the given sheet</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex</a></strong>(java.lang.String name)</code>
<div class="block">Returns the index of the sheet by his name (case insensitive match)</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/xssf/usermodel/XSSFWorkbook.html#getSheetName(int)">getSheetName</a></strong>(int sheetIx)</code>
<div class="block">Get the sheet name</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<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/xssf/usermodel/XSSFWorkbook.html#getSpreadsheetVersion()">getSpreadsheetVersion</a></strong>()</code>
<div class="block">Returns the spreadsheet version (EXCLE2007) of this workbook</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/model/StylesTable.html" title="class in org.apache.poi.xssf.model">StylesTable</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getStylesSource()">getStylesSource</a></strong>()</code>
<div class="block">Return a object representing a collection of shared objects used for styling content,
e.g.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFTable</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getTable(java.lang.String)">getTable</a></strong>(java.lang.String name)</code>
<div class="block">Returns the data table with the given name (case insensitive).</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/model/ThemesTable.html" title="class in org.apache.poi.xssf.model">ThemesTable</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getTheme()">getTheme</a></strong>()</code>
<div class="block">Returns the Theme of current workbook.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbookType.html" title="enum in org.apache.poi.xssf.usermodel">XSSFWorkbookType</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getWorkbookType()">getWorkbookType</a></strong>()</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/xssf/usermodel/XSSFWorkbook.html#isDate1904()">isDate1904</a></strong>()</code>
<div class="block">Gets a boolean value that indicates whether the date systems used in the workbook starts in 1904.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#isHidden()">isHidden</a></strong>()</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/xssf/usermodel/XSSFWorkbook.html#isMacroEnabled()">isMacroEnabled</a></strong>()</code>
<div class="block">Are we a normal workbook (.xlsx), or a
macro enabled workbook (.xlsm)?</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#isRevisionLocked()">isRevisionLocked</a></strong>()</code>
<div class="block">Specifies a boolean value that indicates whether the workbook is locked for revisions.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#isSheetHidden(int)">isSheetHidden</a></strong>(int sheetIx)</code>
<div class="block">Check whether a sheet is hidden.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#isSheetVeryHidden(int)">isSheetVeryHidden</a></strong>(int sheetIx)</code>
<div class="block">Check whether a sheet is very hidden.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#isStructureLocked()">isStructureLocked</a></strong>()</code>
<div class="block">Specifies a boolean value that indicates whether structure of workbook is locked.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#isWindowsLocked()">isWindowsLocked</a></strong>()</code>
<div class="block">Specifies a boolean value that indicates whether the windows that comprise the workbook are locked.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
<div class="block">Alias for <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a> to allow
@@ -614,7 +629,7 @@ implements <a href="../../../../../org/a
to make iterating over a container (Workbook, Sheet, Row) consistent across POI spreadsheets.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#linkExternalWorkbook(java.lang.String,%20org.apache.poi.ss.usermodel.Workbook)">linkExternalWorkbook</a></strong>(java.lang.String name,
<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a> workbook)</code>
@@ -622,44 +637,44 @@ implements <a href="../../../../../org/a
referencing the specified external workbook to be added to this one.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#lockRevision()">lockRevision</a></strong>()</code>
<div class="block">Locks the workbook for revisions.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#lockStructure()">lockStructure</a></strong>()</code>
<div class="block">Locks the structure of 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/xssf/usermodel/XSSFWorkbook.html#lockWindows()">lockWindows</a></strong>()</code>
<div class="block">Locks the windows that comprise the workbook.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>protected static <a href="../../../../../org/apache/poi/openxml4j/opc/OPCPackage.html" title="class in org.apache.poi.openxml4j.opc">OPCPackage</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#newPackage(org.apache.poi.xssf.usermodel.XSSFWorkbookType)">newPackage</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbookType.html" title="enum in org.apache.poi.xssf.usermodel">XSSFWorkbookType</a> workbookType)</code>
<div class="block">Create a new SpreadsheetML package and setup the default minimal content</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/xssf/usermodel/XSSFWorkbook.html#onDeleteFormula(org.apache.poi.xssf.usermodel.XSSFCell)">onDeleteFormula</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class in org.apache.poi.xssf.usermodel">XSSFCell</a> cell)</code>
<div class="block">Fired when a formula is deleted from this workbook,
for example when calling cell.setCellFormula(null)</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/xssf/usermodel/XSSFWorkbook.html#onDocumentRead()">onDocumentRead</a></strong>()</code>
<div class="block">Fired when a package part is read</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#parseSheet(java.util.Map,%20org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet)">parseSheet</a></strong>(java.util.Map<java.lang.String,<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>> shIdMap,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet ctSheet)</code>
@@ -667,25 +682,25 @@ implements <a href="../../../../../org/a
the DOM based parse of large sheets (see examples).</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#removeName(int)">removeName</a></strong>(int nameIndex)</code>
<div class="block">Remove the defined name at the specified index</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#removeName(java.lang.String)">removeName</a></strong>(java.lang.String name)</code>
<div class="block">Remove a defined name by name</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#removePrintArea(int)">removePrintArea</a></strong>(int sheetIndex)</code>
<div class="block">Delete the printarea for the sheet specified</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#removeSheetAt(int)">removeSheetAt</a></strong>(int index)</code>
<div class="block">Removes sheet at the given index.<p/>
@@ -694,40 +709,40 @@ implements <a href="../../../../../org/a
the 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/xssf/usermodel/XSSFWorkbook.html#setActiveSheet(int)">setActiveSheet</a></strong>(int index)</code>
<div class="block">Convenience method to set the active sheet.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setFirstVisibleTab(int)">setFirstVisibleTab</a></strong>(int index)</code>
<div class="block">Sets the first tab that is displayed in the list of tabs in excel.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code>
<div class="block">Whether the application shall perform a full recalculation 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/xssf/usermodel/XSSFWorkbook.html#setHidden(boolean)">setHidden</a></strong>(boolean hiddenFlag)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy)">setMissingCellPolicy</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html" title="enum in org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a> missingCellPolicy)</code>
<div class="block">Sets the policy on what to do when
getting missing or blank cells from a row.</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/xssf/usermodel/XSSFWorkbook.html#setPivotTables(java.util.List)">setPivotTables</a></strong>(java.util.List<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a>> pivotTables)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setPrintArea(int,%20int,%20int,%20int,%20int)">setPrintArea</a></strong>(int sheetIndex,
int startColumn,
@@ -737,125 +752,125 @@ implements <a href="../../../../../org/a
<div class="block">For the Convenience of Java Programmers maintaining pointers.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setPrintArea(int,%20java.lang.String)">setPrintArea</a></strong>(int sheetIndex,
java.lang.String reference)</code>
<div class="block">Sets the printarea for the sheet provided</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setRevisionsPassword(java.lang.String,%20org.apache.poi.poifs.crypt.HashAlgorithm)">setRevisionsPassword</a></strong>(java.lang.String password,
<a href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum in org.apache.poi.poifs.crypt">HashAlgorithm</a> hashAlgo)</code>
<div class="block">Sets the revisions password.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setSelectedTab(int)">setSelectedTab</a></strong>(int index)</code>
<div class="block">We only set one sheet as selected for compatibility with HSSF.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setSheetHidden(int,%20boolean)">setSheetHidden</a></strong>(int sheetIx,
boolean hidden)</code>
<div class="block">Sets the visible state of this sheet.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setSheetHidden(int,%20int)">setSheetHidden</a></strong>(int sheetIx,
int state)</code>
<div class="block">Hide or unhide a sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setSheetName(int,%20java.lang.String)">setSheetName</a></strong>(int sheetIndex,
java.lang.String sheetname)</code>
<div class="block">Set the sheet name.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setSheetOrder(java.lang.String,%20int)">setSheetOrder</a></strong>(java.lang.String sheetname,
int pos)</code>
<div class="block">sets the order of appearance for a given sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setVBAProject(java.io.InputStream)">setVBAProject</a></strong>(java.io.InputStream vbaProjectStream)</code>
<div class="block">Adds a vbaProject.bin file to the 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/xssf/usermodel/XSSFWorkbook.html#setVBAProject(org.apache.poi.xssf.usermodel.XSSFWorkbook)">setVBAProject</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a> macroWorkbook)</code>
<div class="block">Adds a vbaProject.bin file taken from another, given workbook to this one.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setWorkbookPassword(java.lang.String,%20org.apache.poi.poifs.crypt.HashAlgorithm)">setWorkbookPassword</a></strong>(java.lang.String password,
<a href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum in org.apache.poi.poifs.crypt">HashAlgorithm</a> hashAlgo)</code>
<div class="block">Sets the workbook password.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setWorkbookType(org.apache.poi.xssf.usermodel.XSSFWorkbookType)">setWorkbookType</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbookType.html" title="enum in org.apache.poi.xssf.usermodel">XSSFWorkbookType</a> type)</code>
<div class="block">Sets whether the workbook will be an .xlsx or .xlsm (macro-enabled) file.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
<div class="block">Returns an iterator of the sheets in the workbook
in sheet order.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#unLock()">unLock</a></strong>()</code>
<div class="block">Removes the workbook protection settings</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#unLockRevision()">unLockRevision</a></strong>()</code>
<div class="block">Unlocks the workbook for revisions.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#unLockStructure()">unLockStructure</a></strong>()</code>
<div class="block">Unlocks the structure of 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/xssf/usermodel/XSSFWorkbook.html#unLockWindows()">unLockWindows</a></strong>()</code>
<div class="block">Unlocks the windows that comprise the workbook.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#validateRevisionsPassword(java.lang.String)">validateRevisionsPassword</a></strong>(java.lang.String password)</code>
<div class="block">Validate the password against the stored hash, the hashing method will be determined
by the existing password attributes</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#validateWorkbookPassword(java.lang.String)">validateWorkbookPassword</a></strong>(java.lang.String password)</code>
<div class="block">Validate the password against the stored hash, the hashing method will be determined
by the existing password attributes</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#xssfSheetIterator()">xssfSheetIterator</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>
@@ -1392,6 +1407,7 @@ public org.openxmlformats.schemas.s
boolean strikeout,
short typeOffset,
byte underline)</pre>
+<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15. Use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#findFont(boolean,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)"><code>findFont(boolean, short, short, String, boolean, boolean, short, byte)</code></a> instead.</i></div>
<div class="block">Finds a font that matches the one with the supplied attributes</div>
<dl>
<dt><strong>Specified by:</strong></dt>
@@ -1399,6 +1415,27 @@ public org.openxmlformats.schemas.s
<dt><span class="strong">Returns:</span></dt><dd>the font with the matched attributes or <code>null</code></dd></dl>
</li>
</ul>
+<a name="findFont(boolean, short, short, java.lang.String, boolean, boolean, short, byte)">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>findFont</h4>
+<pre>public <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class in org.apache.poi.xssf.usermodel">XSSFFont</a> findFont(boolean bold,
+ short color,
+ short fontHeight,
+ java.lang.String name,
+ boolean italic,
+ boolean strikeout,
+ short typeOffset,
+ byte underline)</pre>
+<div class="block">Finds a font that matches the one with the supplied attributes</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#findFont(boolean,%20short,%20short,%20java.lang.String,%20boolean,%20boolean,%20short,%20byte)">findFont</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></dd>
+<dt><span class="strong">Returns:</span></dt><dd>the font with the matched attributes or <code>null</code></dd></dl>
+</li>
+</ul>
<a name="getActiveSheetIndex()">
<!-- -->
</a>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org