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=1734934&r1=1734933&r2=1734934&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 Mon Mar 14 13:29:36 2016 @@ -446,146 +446,152 @@ implements <a href="../../../../../org/a </td> </tr> <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="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/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="rowColor"> +<tr class="altColor"> <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="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#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="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#isHidden()">isHidden</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/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="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#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="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#isSheetHidden(int)">isSheetHidden</a></strong>(int sheetIx)</code> <div class="block">Check whether a sheet is 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#isSheetVeryHidden(int)">isSheetVeryHidden</a></strong>(int sheetIx)</code> <div class="block">Check whether a sheet is very 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#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="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#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="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#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 @@ -595,7 +601,7 @@ implements <a href="../../../../../org/a to make iterating over a container (Workbook, Sheet, Row) consistent across POI spreadsheets.</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#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> @@ -603,44 +609,44 @@ implements <a href="../../../../../org/a referencing the specified external workbook to be added 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#lockRevision()">lockRevision</a></strong>()</code> <div class="block">Locks 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#lockStructure()">lockStructure</a></strong>()</code> <div class="block">Locks 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#lockWindows()">lockWindows</a></strong>()</code> <div class="block">Locks the windows that comprise the workbook.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <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="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#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="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#onDocumentRead()">onDocumentRead</a></strong>()</code> <div class="block">Fired when a package part is read</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#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> @@ -648,25 +654,25 @@ implements <a href="../../../../../org/a the DOM based parse of large sheets (see examples).</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(int)">removeName</a></strong>(int nameIndex)</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/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="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#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/usermodel/XSSFWorkbook.html#removeSheetAt(int)">removeSheetAt</a></strong>(int index)</code> <div class="block">Removes sheet at the given index.<p/> @@ -675,40 +681,40 @@ implements <a href="../../../../../org/a 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#setActiveSheet(int)">setActiveSheet</a></strong>(int index)</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/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="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#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="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#setHidden(boolean)">setHidden</a></strong>(boolean hiddenFlag)</code> </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#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="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#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="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,%20int,%20int,%20int,%20int)">setPrintArea</a></strong>(int sheetIndex, int startColumn, @@ -718,125 +724,125 @@ 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/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="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#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="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#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="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,%20boolean)">setSheetHidden</a></strong>(int sheetIx, boolean hidden)</code> <div class="block">Sets the visible state of this sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/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="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#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="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#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="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(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="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(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="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#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="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#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="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#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="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#unLock()">unLock</a></strong>()</code> <div class="block">Removes the workbook protection settings</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#unLockRevision()">unLockRevision</a></strong>()</code> <div class="block">Unlocks 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#unLockStructure()">unLockStructure</a></strong>()</code> <div class="block">Unlocks 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#unLockWindows()">unLockWindows</a></strong>()</code> <div class="block">Unlocks the windows that comprise the workbook.</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#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="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#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="altColor"> +<tr class="rowColor"> <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> </div> @@ -1431,6 +1437,22 @@ public org.openxmlformats.schemas.s <dt><span class="strong">Returns:</span></dt><dd>the defined name with the specified name. <code>null</code> if not found.</dd></dl> </li> </ul> +<a name="getNames(java.lang.String)"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>getNames</h4> +<pre>public java.util.List<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class in org.apache.poi.xssf.usermodel">XSSFName</a>> getNames(java.lang.String name)</pre> +<div class="block"><strong>Description copied from interface: <code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#getNames(java.lang.String)">Workbook</a></code></strong></div> +<div class="block">Returns all defined names with the given name.</div> +<dl> +<dt><strong>Specified by:</strong></dt> +<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#getNames(java.lang.String)">getNames</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">Parameters:</span></dt><dd><code>name</code> - the name of the defined name</dd> +<dt><span class="strong">Returns:</span></dt><dd>a list of the defined names with the specified name. An empty list is returned if none is found.</dd></dl> +</li> +</ul> <a name="getNameAt(int)"> <!-- --> </a>
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFName.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFName.html?rev=1734934&r1=1734933&r2=1734934&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFName.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFName.html Mon Mar 14 13:29:36 2016 @@ -111,6 +111,19 @@ </tr> </tbody> </table> +<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation"> +<caption><span>Methods in <a href="../../../../../../org/apache/poi/xssf/usermodel/package-summary.html">org.apache.poi.xssf.usermodel</a> that return types with arguments of type <a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFName.html" title="class in org.apache.poi.xssf.usermodel">XSSFName</a></span><span class="tabEnd"> </span></caption> +<tr> +<th class="colFirst" scope="col">Modifier and Type</th> +<th class="colLast" scope="col">Method and Description</th> +</tr> +<tbody> +<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"><span class="strong">XSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getNames(java.lang.String)">getNames</a></strong>(java.lang.String name)</code> </td> +</tr> +</tbody> +</table> </li> </ul> </li> Modified: poi/site/publish/apidocs/overview-tree.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/overview-tree.html?rev=1734934&r1=1734933&r2=1734934&view=diff ============================================================================== --- poi/site/publish/apidocs/overview-tree.html (original) +++ poi/site/publish/apidocs/overview-tree.html Mon Mar 14 13:29:36 2016 @@ -3553,6 +3553,7 @@ <li type="circle">org.apache.poi.sl.usermodel.<a href="org/apache/poi/sl/usermodel/PictureData.PictureType.html" title="enum in org.apache.poi.sl.usermodel"><span class="strong">PictureData.PictureType</span></a></li> <li type="circle">org.apache.poi.hwpf.usermodel.<a href="org/apache/poi/hwpf/usermodel/PictureType.html" title="enum in org.apache.poi.hwpf.usermodel"><span class="strong">PictureType</span></a></li> <li type="circle">org.apache.poi.sl.usermodel.<a href="org/apache/poi/sl/usermodel/Placeholder.html" title="enum in org.apache.poi.sl.usermodel"><span class="strong">Placeholder</span></a></li> +<li type="circle">org.apache.poi.sl.usermodel.<a href="org/apache/poi/sl/usermodel/PresetColor.html" title="enum in org.apache.poi.sl.usermodel"><span class="strong">PresetColor</span></a></li> <li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/PrintCellComments.html" title="enum in org.apache.poi.ss.usermodel"><span class="strong">PrintCellComments</span></a></li> <li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/PrintOrientation.html" title="enum in org.apache.poi.ss.usermodel"><span class="strong">PrintOrientation</span></a></li> <li type="circle">org.apache.poi.hslf.record.<a href="org/apache/poi/hslf/record/RecordTypes.html" title="enum in org.apache.poi.hslf.record"><span class="strong">RecordTypes</span></a></li> Modified: poi/site/publish/changes.html URL: http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1734934&r1=1734933&r2=1734934&view=diff ============================================================================== --- poi/site/publish/changes.html (original) +++ poi/site/publish/changes.html Mon Mar 14 13:29:36 2016 @@ -265,6 +265,18 @@ if (VERSION > 3) { <ul> <li> +<img class="icon" alt="add" src="images/add.jpg"> HSLF: Add support for system colors</li> + +<li> +<img class="icon" alt="fix" src="images/fix.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=56930">56930</a> - Add Workbook.getNames() to allow to query for names that appear multiple times</li> + +<li> +<img class="icon" alt="fix" src="images/fix.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55791">55791</a> - Avoid using an existing file-name when creating a new slide, it could still be left over from previous partial removal</li> + +<li> +<img class="icon" alt="fix" src="images/fix.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55668">55668</a> - Try to avoid NullPointerException by seting the cell to BLANK instead, when changing cell-type and a formula leads to null-string</li> + +<li> <img class="icon" alt="fix" src="images/fix.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59135">59135</a> - Password gets truncated when using passwords longer than 15 characters for the function protectSheet()</li> <li> Modified: poi/site/publish/changes.rss URL: http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1734934&r1=1734933&r2=1734934&view=diff ============================================================================== --- poi/site/publish/changes.rss (original) +++ poi/site/publish/changes.rss Mon Mar 14 13:29:36 2016 @@ -1,3 +1,3 @@ <?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-0.91.dtd"> -<rss version="0.91"><channel><title>Apache POI Changes</title><link>http://poi.apache.org/changes.html</link><description>Apache POI Changes</description><language>en-us</language><item><title> fix(bug 59135)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 59135) - Password gets truncated when using passwords longer than 15 characters for the function protectSheet()</description></item><item><title> add(bug 56549)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 56549) - Correctly calculate char index ranges for HWPF in the TextPieceTable</description></item><item><title> add(bug 57495)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57495) - Fix problem with tables in documents at pos 0</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - Fix a number of edge-cases whe re file-handles would be leaked</description></item><item><title> fix(bug 59170)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) - *Workbook.setRepeatingRowsAndColumns()</description></item><item><title> fix(bug 59170)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) - org.apache.poi.hssf/ss.util.Region</description></item><item><title> add(bug 57031)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57031) - Out of Memory when extracting text from attached files</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - More helpful exception when POIFSFileSystem is given a raw XML file</description></item></channel></rss> \ No newline at end of file +<rss version="0.91"><channel><title>Apache POI Changes</title><link>http://poi.apache.org/changes.html</link><description>Apache POI Changes</description><language>en-us</language><item><title> add</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers - HSLF: Add support for system colors</description></item><item><title> fix(bug 56930)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56930) - Add Workbook.getNames() to allow to query for names that appear multiple times</description></item><item><title> fix(bug 55791)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 55791) - Avoid using an existing file-name when creating a new slide, it could still be left over from previous partial removal</description></item><item><title> fix(bug 55668)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 55668) - Try to avoid N ullPointerException by seting the cell to BLANK instead, when changing cell-type and a formula leads to null-string</description></item><item><title> fix(bug 59135)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 59135) - Password gets truncated when using passwords longer than 15 characters for the function protectSheet()</description></item><item><title> add(bug 56549)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 56549) - Correctly calculate char index ranges for HWPF in the TextPieceTable</description></item><item><title> add(bug 57495)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57495) - Fix problem with tables in documents at pos 0</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - Fix a number of edge-cases where file-handles would be leaked</description ></item><item><title> fix(bug >59170)</title><link>http://poi.apache.org/changes.html</link><description> >fix by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) - >*Workbook.setRepeatingRowsAndColumns()</description></item><item><title> >fix(bug >59170)</title><link>http://poi.apache.org/changes.html</link><description> >fix by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) - >org.apache.poi.hssf/ss.util.Region</description></item><item><title> add(bug >57031)</title><link>http://poi.apache.org/changes.html</link><description> >add by POI Developers (bug 57031) - Out of Memory when extracting text from >attached files</description></item><item><title> >fix</title><link>http://poi.apache.org/changes.html</link><description> fix >by POI Developers - More helpful exception when POIFSFileSystem is given a >raw XML file</description></item></channel></rss> \ No newline at end of file --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
