poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1677372 - in /poi/site: publish/ publish/apidocs/ publish/apidocs/org/apache/poi/xssf/model/ publish/apidocs/org/apache/poi/xssf/usermodel/ publish/apidocs/org/apache/poi/xssf/usermodel/class-use/ src/documentation/content/xdocs/
Date Sun, 03 May 2015 08:23:50 GMT
Author: nick
Date: Sun May  3 08:23:49 2015
New Revision: 1677372

URL: http://svn.apache.org/r1677372
Log:
Changelog and javadocs update

Modified:
    poi/site/publish/apidocs/index-all.html
    poi/site/publish/apidocs/org/apache/poi/xssf/model/StylesTable.html
    poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFCellStyle.html
    poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataFormat.html
    poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html
    poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFCellStyle.html
    poi/site/publish/changes.html
    poi/site/publish/changes.rss
    poi/site/src/documentation/content/xdocs/status.xml

Modified: poi/site/publish/apidocs/index-all.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/index-all.html?rev=1677372&r1=1677371&r2=1677372&view=diff
==============================================================================
--- poi/site/publish/apidocs/index-all.html (original)
+++ poi/site/publish/apidocs/index-all.html Sun May  3 08:23:49 2015
@@ -18621,6 +18621,10 @@ return null</div>
 <dd>
 <div class="block">Get the cell style object at the given index</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCellStyleAt(int)">getCellStyleAt(int)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a></dt>
+<dd>
+<div class="block">Get the cell style object at the given index</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/xssf/model/StylesTable.html#getCellStyleXfAt(int)">getCellStyleXfAt(int)</a></span> - Method in class org.apache.poi.xssf.model.<a href="./org/apache/poi/xssf/model/StylesTable.html" title="class in org.apache.poi.xssf.model">StylesTable</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFCell.html#getCellType()">getCellType()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFCell.html" title="class in org.apache.poi.hssf.usermodel">HSSFCell</a></dt>
@@ -24128,6 +24132,10 @@ return null</div>
 <dd>
 <div class="block">get the format string that matches the given format index</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFDataFormat.html#getFormat(int)">getFormat(int)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFDataFormat.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataFormat</a></dt>
+<dd>
+<div class="block">get the format string that matches the given format index</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/chart/ChartTitleFormatRecord.html#getFormatCount()">getFormatCount()</a></span> - Method in class org.apache.poi.hssf.record.chart.<a href="./org/apache/poi/hssf/record/chart/ChartTitleFormatRecord.html" title="class in org.apache.poi.hssf.record.chart">ChartTitleFormatRecord</a></dt>
 <dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/chart/AreaFormatRecord.html#getFormatFlags()">getFormatFlags()</a></span> - Method in class org.apache.poi.hssf.record.chart.<a href="./org/apache/poi/hssf/record/chart/AreaFormatRecord.html" title="class in org.apache.poi.hssf.record.chart">AreaFormatRecord</a></dt>
@@ -35734,6 +35742,8 @@ return null</div>
 </dd>
 <dt><span class="strong"><a href="./org/apache/poi/sl/usermodel/PictureData.html#getUID()">getUID()</a></span> - Method in interface org.apache.poi.sl.usermodel.<a href="./org/apache/poi/sl/usermodel/PictureData.html" title="interface in org.apache.poi.sl.usermodel">PictureData</a></dt>
 <dd>&nbsp;</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getUIndex()">getUIndex()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFCellStyle.html" title="class in org.apache.poi.xssf.usermodel">XSSFCellStyle</a></dt>
+<dd>&nbsp;</dd>
 <dt><span class="strong"><a href="./org/apache/poi/util/LittleEndian.html#getUInt(byte[])">getUInt(byte[])</a></span> - Static method in class org.apache.poi.util.<a href="./org/apache/poi/util/LittleEndian.html" title="class in org.apache.poi.util">LittleEndian</a></dt>
 <dd>
 <div class="block">get an unsigned int value from a byte array</div>
@@ -58435,6 +58445,10 @@ Compound Document Format.</div>
 <dd>
 <div class="block">Set the index of a data format</div>
 </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setDataFormat(int)">setDataFormat(int)</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFCellStyle.html" title="class in org.apache.poi.xssf.usermodel">XSSFCellStyle</a></dt>
+<dd>
+<div class="block">Set the index of a data format</div>
+</dd>
 <dt><span class="strong"><a href="./org/apache/poi/hssf/record/chart/TextRecord.html#setDataLabelPlacement(short)">setDataLabelPlacement(short)</a></span> - Method in class org.apache.poi.hssf.record.chart.<a href="./org/apache/poi/hssf/record/chart/TextRecord.html" title="class in org.apache.poi.hssf.record.chart">TextRecord</a></dt>
 <dd>
 <div class="block">Sets the data label placement field value.</div>

Modified: poi/site/publish/apidocs/org/apache/poi/xssf/model/StylesTable.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/model/StylesTable.html?rev=1677372&r1=1677371&r2=1677372&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/model/StylesTable.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/model/StylesTable.html Sun May  3 08:23:49 2015
@@ -102,8 +102,6 @@
 <pre>public class <span class="strong">StylesTable</span>
 extends <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html" title="class in org.apache.poi">POIXMLDocumentPart</a></pre>
 <div class="block">Table of styles shared across all sheets in a workbook.</div>
-<dl><dt><span class="strong">Author:</span></dt>
-  <dd>ugo</dd></dl>
 </li>
 </ul>
 </div>

Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFCellStyle.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFCellStyle.html?rev=1677372&r1=1677371&r2=1677372&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFCellStyle.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFCellStyle.html Sun May  3 08:23:49 2015
@@ -434,108 +434,118 @@ implements <a href="../../../../../org/a
 </td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><code>protected int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getUIndex()">getUIndex</a></strong>()</code>&nbsp;</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getVerticalAlignment()">getVerticalAlignment</a></strong>()</code>
 <div class="block">Get the type of vertical alignment for the cell</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel">VerticalAlignment</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getVerticalAlignmentEnum()">getVerticalAlignmentEnum</a></strong>()</code>
 <div class="block">Get the type of vertical alignment for the cell</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/XSSFCellStyle.html#getWrapText()">getWrapText</a></strong>()</code>
 <div class="block">Whether the text should be wrapped</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/XSSFCellStyle.html#hashCode()">hashCode</a></strong>()</code>
 <div class="block">Returns a hash code value for the object.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setAlignment(org.apache.poi.ss.usermodel.HorizontalAlignment)">setAlignment</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html" title="enum in org.apache.poi.ss.usermodel">HorizontalAlignment</a>&nbsp;align)</code>
 <div class="block">Set the type of horizontal alignment for the cell</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setAlignment(short)">setAlignment</a></strong>(short&nbsp;align)</code>
 <div class="block">Set the type of horizontal alignment for the cell</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/XSSFCellStyle.html#setBorderBottom(org.apache.poi.ss.usermodel.BorderStyle)">setBorderBottom</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</code>
 <div class="block">Set the type of border to use for the bottom border of the cell</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderBottom(short)">setBorderBottom</a></strong>(short&nbsp;border)</code>
 <div class="block">Set the type of border to use for the bottom border of the cell</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/XSSFCellStyle.html#setBorderColor(org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder.BorderSide,%20org.apache.poi.xssf.usermodel.XSSFColor)">setBorderColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/extensions/XSSFCellBorder.BorderSide.html" title="enum in org.apache.poi.xssf.usermodel.extensions">XSSFCellBorder.BorderSide</a>&nbsp;side,
               <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
 <div class="block">Set the color to use for the selected border</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/XSSFCellStyle.html#setBorderLeft(org.apache.poi.ss.usermodel.BorderStyle)">setBorderLeft</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</code>
 <div class="block">Set the type of border to use for the left border of the cell</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/XSSFCellStyle.html#setBorderLeft(short)">setBorderLeft</a></strong>(short&nbsp;border)</code>
 <div class="block">Set the type of border to use for the left border of the cell</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderRight(org.apache.poi.ss.usermodel.BorderStyle)">setBorderRight</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</code>
 <div class="block">Set the type of border to use for the right border of the cell</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/XSSFCellStyle.html#setBorderRight(short)">setBorderRight</a></strong>(short&nbsp;border)</code>
 <div class="block">Set the type of border to use for the right border of the cell</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderTop(org.apache.poi.ss.usermodel.BorderStyle)">setBorderTop</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</code>
 <div class="block">Set the type of border to use for the top border of the cell</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/XSSFCellStyle.html#setBorderTop(short)">setBorderTop</a></strong>(short&nbsp;border)</code>
 <div class="block">Set the type of border to use for the top border of the cell</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBottomBorderColor(short)">setBottomBorderColor</a></strong>(short&nbsp;color)</code>
 <div class="block">Set the color to use for the bottom border</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/XSSFCellStyle.html#setBottomBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">setBottomBorderColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
 <div class="block">Set the color to use for the bottom border</div>
 </td>
 </tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setDataFormat(int)">setDataFormat</a></strong>(int&nbsp;fmt)</code>
+<div class="block">Set the index of a data format</div>
+</td>
+</tr>
 <tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setDataFormat(short)">setDataFormat</a></strong>(short&nbsp;fmt)</code>
@@ -1241,6 +1251,15 @@ public&nbsp;org.openxmlformats.schemas.s
 <dt><span class="strong">Returns:</span></dt><dd>unique index number of the underlying record this style represents</dd></dl>
 </li>
 </ul>
+<a name="getUIndex()">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getUIndex</h4>
+<pre>protected&nbsp;int&nbsp;getUIndex()</pre>
+</li>
+</ul>
 <a name="getLeftBorderColor()">
 <!--   -->
 </a>
@@ -1633,6 +1652,17 @@ public&nbsp;org.openxmlformats.schemas.s
 <dt><span class="strong">Parameters:</span></dt><dd><code>fmt</code> - the index of a data format</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/DataFormat.html" title="interface in org.apache.poi.ss.usermodel"><code>DataFormat</code></a></dd></dl>
 </li>
 </ul>
+<a name="setDataFormat(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>setDataFormat</h4>
+<pre>public&nbsp;void&nbsp;setDataFormat(int&nbsp;fmt)</pre>
+<div class="block">Set the index of a data format</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>fmt</code> - the index of a data format</dd></dl>
+</li>
+</ul>
 <a name="setFillBackgroundColor(org.apache.poi.xssf.usermodel.XSSFColor)">
 <!--   -->
 </a>

Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataFormat.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataFormat.html?rev=1677372&r1=1677371&r2=1677372&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataFormat.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFDataFormat.html Sun May  3 08:23:49 2015
@@ -141,11 +141,17 @@ 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/XSSFDataFormat.html#getFormat(short)">getFormat</a></strong>(short&nbsp;index)</code>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataFormat.html#getFormat(int)">getFormat</a></strong>(int&nbsp;index)</code>
 <div class="block">get the format string that matches the given format index</div>
 </td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><code>java.lang.String</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataFormat.html#getFormat(short)">getFormat</a></strong>(short&nbsp;index)</code>
+<div class="block">get the format string that matches the given format index</div>
+</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataFormat.html#getFormat(java.lang.String)">getFormat</a></strong>(java.lang.String&nbsp;format)</code>
 <div class="block">Get the format index that matches the given format
@@ -211,7 +217,7 @@ implements <a href="../../../../../org/a
 <a name="getFormat(short)">
 <!--   -->
 </a>
-<ul class="blockListLast">
+<ul class="blockList">
 <li class="blockList">
 <h4>getFormat</h4>
 <pre>public&nbsp;java.lang.String&nbsp;getFormat(short&nbsp;index)</pre>
@@ -223,6 +229,18 @@ implements <a href="../../../../../org/a
 <dt><span class="strong">Returns:</span></dt><dd>string represented at index of format or null if there is not a  format at that index</dd></dl>
 </li>
 </ul>
+<a name="getFormat(int)">
+<!--   -->
+</a>
+<ul class="blockListLast">
+<li class="blockList">
+<h4>getFormat</h4>
+<pre>public&nbsp;java.lang.String&nbsp;getFormat(int&nbsp;index)</pre>
+<div class="block">get the format string that matches the given format index</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>index</code> - of a format</dd>
+<dt><span class="strong">Returns:</span></dt><dd>string represented at index of format or null if there is not a  format at that index</dd></dl>
+</li>
+</ul>
 </li>
 </ul>
 </li>

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=1677372&r1=1677371&r2=1677372&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 May  3 08:23:49 2015
@@ -367,71 +367,77 @@ implements <a href="../../../../../org/a
 </tr>
 <tr class="altColor">
 <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(short)">getCellStyleAt</a></strong>(short&nbsp;idx)</code>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCellStyleAt(int)">getCellStyleAt</a></strong>(int&nbsp;idx)</code>
 <div class="block">Get the cell style object at the given index</div>
 </td>
 </tr>
 <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(short)">getCellStyleAt</a></strong>(short&nbsp;idx)</code>
+<div class="block">Get the cell style object at the given index</div>
+</td>
+</tr>
+<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&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFMap.html" title="class in org.apache.poi.xssf.usermodel">XSSFMap</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCustomXMLMappings()">getCustomXMLMappings</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.util.List&lt;<a href="../../../../../org/apache/poi/xssf/model/ExternalLinksTable.html" title="class in org.apache.poi.xssf.model">ExternalLinksTable</a>&gt;</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&nbsp;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>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html" title="class 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&nbsp;name)</code>&nbsp;</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&nbsp;nameIndex)</code>&nbsp;</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&nbsp;name)</code>
 <div class="block">Gets the named range index by his name
@@ -439,143 +445,143 @@ 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>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="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#getNumberOfNames()">getNumberOfNames</a></strong>()</code>
 <div class="block">Get the number of named ranges 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#getNumberOfSheets()">getNumberOfSheets</a></strong>()</code>
 <div class="block">Get the number of worksheets in the this workbook</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#getNumCellStyles()">getNumCellStyles</a></strong>()</code>
 <div class="block">Get the number of styles the workbook contains</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>java.util.List&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getPivotTables()">getPivotTables</a></strong>()</code>&nbsp;</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/XSSFWorkbook.html#getPrintArea(int)">getPrintArea</a></strong>(int&nbsp;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><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="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#getSheet(java.lang.String)">getSheet</a></strong>(java.lang.String&nbsp;name)</code>
 <div class="block">Get sheet with the given name (case insensitive match)</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#getSheetAt(int)">getSheetAt</a></strong>(int&nbsp;index)</code>
 <div class="block">Get the XSSFSheet 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/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>&nbsp;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/usermodel/XSSFWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex</a></strong>(java.lang.String&nbsp;name)</code>
 <div class="block">Returns the index of the sheet by his name (case insensitive match)</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/XSSFWorkbook.html#getSheetName(int)">getSheetName</a></strong>(int&nbsp;sheetIx)</code>
 <div class="block">Get the sheet name</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>protected 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>&nbsp;</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&nbsp;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&nbsp;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&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
 <div class="block">Allows 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/usermodel/XSSFWorkbook.html#linkExternalWorkbook(java.lang.String,%20org.apache.poi.ss.usermodel.Workbook)">linkExternalWorkbook</a></strong>(java.lang.String&nbsp;name,
                     <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a>&nbsp;workbook)</code>
@@ -583,62 +589,62 @@ 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()">newPackage</a></strong>()</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>&nbsp;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#removeName(int)">removeName</a></strong>(int&nbsp;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&nbsp;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&nbsp;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&nbsp;index)</code>
 <div class="block">Removes sheet at the given index.<p/>
@@ -647,40 +653,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&nbsp;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&nbsp;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&nbsp;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&nbsp;hiddenFlag)</code>&nbsp;</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="class in org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a>&nbsp;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&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&gt;&nbsp;pivotTables)</code>&nbsp;</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&nbsp;sheetIndex,
             int&nbsp;startColumn,
@@ -690,14 +696,14 @@ 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&nbsp;sheetIndex,
             java.lang.String&nbsp;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#setRepeatingRowsAndColumns(int,%20int,%20int,%20int,%20int)">setRepeatingRowsAndColumns</a></strong>(int&nbsp;sheetIndex,
                           int&nbsp;startColumn,
@@ -710,86 +716,86 @@ implements <a href="../../../../../org/a
 </div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setRevisionsPassword(java.lang.String,%20org.apache.poi.poifs.crypt.HashAlgorithm)">setRevisionsPassword</a></strong>(java.lang.String&nbsp;password,
                     <a href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum in org.apache.poi.poifs.crypt">HashAlgorithm</a>&nbsp;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&nbsp;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&nbsp;sheetIx,
               boolean&nbsp;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&nbsp;sheetIx,
               int&nbsp;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&nbsp;sheetIndex,
             java.lang.String&nbsp;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&nbsp;sheetname,
              int&nbsp;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#setWorkbookPassword(java.lang.String,%20org.apache.poi.poifs.crypt.HashAlgorithm)">setWorkbookPassword</a></strong>(java.lang.String&nbsp;password,
                    <a href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum in org.apache.poi.poifs.crypt">HashAlgorithm</a>&nbsp;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#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&nbsp;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&nbsp;password)</code>
 <div class="block">Validate the password against the stored hash, the hashing method will be determined
@@ -1333,6 +1339,18 @@ public&nbsp;org.openxmlformats.schemas.s
 <dt><span class="strong">Returns:</span></dt><dd>XSSFCellStyle object at the index</dd></dl>
 </li>
 </ul>
+<a name="getCellStyleAt(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getCellStyleAt</h4>
+<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html" title="class in org.apache.poi.xssf.usermodel">XSSFCellStyle</a>&nbsp;getCellStyleAt(int&nbsp;idx)</pre>
+<div class="block">Get the cell style object at the given index</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>idx</code> - index within the set of styles</dd>
+<dt><span class="strong">Returns:</span></dt><dd>XSSFCellStyle object at the index</dd></dl>
+</li>
+</ul>
 <a name="getFontAt(short)">
 <!--   -->
 </a>

Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFCellStyle.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFCellStyle.html?rev=1677372&r1=1677371&r2=1677372&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFCellStyle.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFCellStyle.html Sun May  3 08:23:49 2015
@@ -146,12 +146,18 @@
 </tr>
 <tr class="altColor">
 <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"><span class="strong">XSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCellStyleAt(short)">getCellStyleAt</a></strong>(short&nbsp;idx)</code>
+<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCellStyleAt(int)">getCellStyleAt</a></strong>(int&nbsp;idx)</code>
 <div class="block">Get the cell style object at the given index</div>
 </td>
 </tr>
 <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"><span class="strong">XSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCellStyleAt(short)">getCellStyleAt</a></strong>(short&nbsp;idx)</code>
+<div class="block">Get the cell style object at the given index</div>
+</td>
+</tr>
+<tr class="altColor">
+<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"><span class="strong">XSSFRow.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html#getRowStyle()">getRowStyle</a></strong>()</code>
 <div class="block">Returns the whole-row cell style.</div>
 </td>

Modified: poi/site/publish/changes.html
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1677372&r1=1677371&r2=1677372&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Sun May  3 08:23:49 2015
@@ -257,6 +257,9 @@ if (VERSION > 3) {
 <ul>
         
 <li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57880">57880</a> - Handle &gt;32,767 cell styles and formats in XSSF (file format limit is 64,000)</li>
+        
+<li>
 <img class="icon" alt="add" src="images/add.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57593">57593</a> - Allow WorkbookFactory.create methods to open xlsx files protected with the default password</li>
         
 <li>

Modified: poi/site/publish/changes.rss
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1677372&r1=1677371&r2=1677372&view=diff
==============================================================================
--- poi/site/publish/changes.rss (original)
+++ poi/site/publish/changes.rss Sun May  3 08:23:49 2015
@@ -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>POI Changes</title><link>http://poi.apache.org/changes.html</link><description>POI Changes</description><language>en-us</language><item><title> add(bug 57593)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57593) - Allow WorkbookFactory.create methods to open xlsx files protected with the default password</description></item><item><title> add(bug 57593)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57593) - Add overloaded WorkbookFactory.create methods which take the spreadsheet password</description></item><item><title> fix(bug 57666)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57666) - When removing a SXSSF sheet, ensure temp files associated with it are disposed of</description></item><item><title> fix(bug 57826)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Develope
 rs (bug 57826) - If a XSSF shape has a buFont but no bullet character, mirror Excel and treat as un-bulleted</description></item><item><title> fix(bug 57642)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57642) - Fix setSheetName with ISERROR on XSSF</description></item><item><title> add(bug 57747)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57747) - Add ISERR() function</description></item><item><title> fix(bug 57829)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57829) - Avoid XmlValueDisconnectedException when removing a XWPFRun from a XWPFParagraph by removing from IRuns as well</description></item><item><title> fix(bug 57851)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57851) - Skip null properties in PropertyTableBase, which is how PropertyFactory reports unsupported POIFS propert
 ies</description></item><item><title> fix(bug 57820)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57820) - Avoid NPE on HSLF Tables with a top position of -1</description></item><item><title> fix(bug 56579)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56579) - Throw exception if max string length of 32767 chars is exceeded in XSSF and SXSSF.</description></item><item><title> fix(bug 55386)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 55386) - Fix handling of bold formatting in example application 'ToHtml'</description></item><item><title> fix(bug 47304)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 47304) - Use fixed encoding when extracting text in WordDocument</description></item><item><title> fix(bug 56017)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI
  Developers (bug 56017) - Fix shifting comments with shifted rows</description></item><item><title> fix(bug 56295)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56295) - Fix cloning of styles across workbooks and handling of default value of attribute applyFill</description></item><item><title> fix(bug 56380)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56380) - Remove limitation of 1024 comments per Workbook</description></item><item><title> fix(bug 56467)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56467) - Fix cloning of sheets with pictures</description></item><item><title> add</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers - More helpful ExtractorFactory exception if given a Visio VSDX ooxml file</description></item><item><title> fix(bug 56799)</title><link>http://poi.apache.org/changes.h
 tml</link><description> fix by POI Developers (bug 56799) - Include CTTblGrid in the smaller poi-ooxml-schemas jar</description></item><item><title> fix(bug 57165)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57165) - Avoid PartAlreadyExistsException when removing/cloning sheets</description></item><item><title> fix(bug 56893)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56893) - Additional check for supported string-length to avoid creating broken XLS files later one</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - When saving an OPCPackage with no Core Properties (eg from Jasper Reports), ensure they are always added even if not yet used</description></item><item><title> fix(bug github-18)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug github-18) - Handle 
 documents with a picture-only header</description></item><item><title> fix(bug 57622)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57622) - Change from XMLEventFactory.newFactory to XMLEventFactory.newInstance, for IBM JDK Compatibility</description></item></channel></rss>
\ No newline at end of file
+<rss version="0.91"><channel><title>POI Changes</title><link>http://poi.apache.org/changes.html</link><description>POI Changes</description><language>en-us</language><item><title> fix(bug 57880)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57880) - Handle &gt;32,767 cell styles and formats in XSSF (file format limit is 64,000)</description></item><item><title> add(bug 57593)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57593) - Allow WorkbookFactory.create methods to open xlsx files protected with the default password</description></item><item><title> add(bug 57593)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57593) - Add overloaded WorkbookFactory.create methods which take the spreadsheet password</description></item><item><title> fix(bug 57666)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers
  (bug 57666) - When removing a SXSSF sheet, ensure temp files associated with it are disposed of</description></item><item><title> fix(bug 57826)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57826) - If a XSSF shape has a buFont but no bullet character, mirror Excel and treat as un-bulleted</description></item><item><title> fix(bug 57642)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57642) - Fix setSheetName with ISERROR on XSSF</description></item><item><title> add(bug 57747)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57747) - Add ISERR() function</description></item><item><title> fix(bug 57829)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57829) - Avoid XmlValueDisconnectedException when removing a XWPFRun from a XWPFParagraph by removing from IRuns as well</description></item><item
 ><title> fix(bug 57851)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57851) - Skip null properties in PropertyTableBase, which is how PropertyFactory reports unsupported POIFS properties</description></item><item><title> fix(bug 57820)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57820) - Avoid NPE on HSLF Tables with a top position of -1</description></item><item><title> fix(bug 56579)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56579) - Throw exception if max string length of 32767 chars is exceeded in XSSF and SXSSF.</description></item><item><title> fix(bug 55386)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 55386) - Fix handling of bold formatting in example application 'ToHtml'</description></item><item><title> fix(bug 47304)</title><link>http://poi.apache.org/changes.html</link>
 <description> fix by POI Developers (bug 47304) - Use fixed encoding when extracting text in WordDocument</description></item><item><title> fix(bug 56017)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56017) - Fix shifting comments with shifted rows</description></item><item><title> fix(bug 56295)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56295) - Fix cloning of styles across workbooks and handling of default value of attribute applyFill</description></item><item><title> fix(bug 56380)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56380) - Remove limitation of 1024 comments per Workbook</description></item><item><title> fix(bug 56467)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56467) - Fix cloning of sheets with pictures</description></item><item><title> add</title><link>http://poi.a
 pache.org/changes.html</link><description> add by POI Developers - More helpful ExtractorFactory exception if given a Visio VSDX ooxml file</description></item><item><title> fix(bug 56799)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56799) - Include CTTblGrid in the smaller poi-ooxml-schemas jar</description></item><item><title> fix(bug 57165)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57165) - Avoid PartAlreadyExistsException when removing/cloning sheets</description></item><item><title> fix(bug 56893)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56893) - Additional check for supported string-length to avoid creating broken XLS files later one</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - When saving an OPCPackage with no Core Properties (eg from Ja
 sper Reports), ensure they are always added even if not yet used</description></item><item><title> fix(bug github-18)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug github-18) - Handle documents with a picture-only header</description></item><item><title> fix(bug 57622)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57622) - Change from XMLEventFactory.newFactory to XMLEventFactory.newInstance, for IBM JDK Compatibility</description></item></channel></rss>
\ No newline at end of file

Modified: poi/site/src/documentation/content/xdocs/status.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/status.xml?rev=1677372&r1=1677371&r2=1677372&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/status.xml (original)
+++ poi/site/src/documentation/content/xdocs/status.xml Sun May  3 08:23:49 2015
@@ -38,6 +38,7 @@
     </devs>
 
     <release version="3.12-beta2" date="2015-??-??">
+        <action dev="PD" type="fix" fixes-bug="57880">Handle &gt;32,767 cell styles and formats in XSSF (file format limit is 64,000)</action>
         <action dev="PD" type="add" fixes-bug="57593">Allow WorkbookFactory.create methods to open xlsx files protected with the default password</action>
         <action dev="PD" type="add" fixes-bug="57593">Add overloaded WorkbookFactory.create methods which take the spreadsheet password</action>
         <action dev="PD" type="fix" fixes-bug="57666">When removing a SXSSF sheet, ensure temp files associated with it are disposed of</action>



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message