You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2016/08/22 19:05:36 UTC
svn commit: r1757243 - in /poi/site/publish: ./ apidocs/
apidocs/org/apache/poi/ss/usermodel/
apidocs/org/apache/poi/ss/usermodel/class-use/
apidocs/org/apache/poi/util/class-use/ spreadsheet/
Author: nick
Date: Mon Aug 22 19:05:35 2016
New Revision: 1757243
URL: http://svn.apache.org/viewvc?rev=1757243&view=rev
Log:
Republish site
Modified:
poi/site/publish/apidocs/constant-values.html
poi/site/publish/apidocs/deprecated-list.html
poi/site/publish/apidocs/index-all.html
poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Cell.html
poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/CellType.html
poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html
poi/site/publish/apidocs/org/apache/poi/util/class-use/Removal.html
poi/site/publish/changes.html
poi/site/publish/changes.rss
poi/site/publish/spreadsheet/quick-guide.html
Modified: poi/site/publish/apidocs/constant-values.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/constant-values.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/apidocs/constant-values.html (original)
+++ poi/site/publish/apidocs/constant-values.html Mon Aug 22 19:05:35 2016
@@ -23869,6 +23869,60 @@
</li>
<li class="blockList">
<table border="0" cellpadding="3" cellspacing="0" summary="Constant Field Values table, listing constant fields, and values">
+<caption><span>org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></span><span class="tabEnd"> </span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th scope="col">Constant Field</th>
+<th class="colLast" scope="col">Value</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><a name="org.apache.poi.ss.usermodel.Cell.CELL_TYPE_BLANK">
+<!-- -->
+</a><code>public static final int</code></td>
+<td><code><a href="org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BLANK">CELL_TYPE_BLANK</a></code></td>
+<td class="colLast"><code>3</code></td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><a name="org.apache.poi.ss.usermodel.Cell.CELL_TYPE_BOOLEAN">
+<!-- -->
+</a><code>public static final int</code></td>
+<td><code><a href="org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BOOLEAN">CELL_TYPE_BOOLEAN</a></code></td>
+<td class="colLast"><code>4</code></td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><a name="org.apache.poi.ss.usermodel.Cell.CELL_TYPE_ERROR">
+<!-- -->
+</a><code>public static final int</code></td>
+<td><code><a href="org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_ERROR">CELL_TYPE_ERROR</a></code></td>
+<td class="colLast"><code>5</code></td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><a name="org.apache.poi.ss.usermodel.Cell.CELL_TYPE_FORMULA">
+<!-- -->
+</a><code>public static final int</code></td>
+<td><code><a href="org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_FORMULA">CELL_TYPE_FORMULA</a></code></td>
+<td class="colLast"><code>2</code></td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><a name="org.apache.poi.ss.usermodel.Cell.CELL_TYPE_NUMERIC">
+<!-- -->
+</a><code>public static final int</code></td>
+<td><code><a href="org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_NUMERIC">CELL_TYPE_NUMERIC</a></code></td>
+<td class="colLast"><code>0</code></td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><a name="org.apache.poi.ss.usermodel.Cell.CELL_TYPE_STRING">
+<!-- -->
+</a><code>public static final int</code></td>
+<td><code><a href="org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_STRING">CELL_TYPE_STRING</a></code></td>
+<td class="colLast"><code>1</code></td>
+</tr>
+</tbody>
+</table>
+</li>
+<li class="blockList">
+<table border="0" cellpadding="3" cellspacing="0" summary="Constant Field Values table, listing constant fields, and values">
<caption><span>org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/CellCopyPolicy.html" title="class in org.apache.poi.ss.usermodel">CellCopyPolicy</a></span><span class="tabEnd"> </span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
Modified: poi/site/publish/apidocs/deprecated-list.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/deprecated-list.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/apidocs/deprecated-list.html (original)
+++ poi/site/publish/apidocs/deprecated-list.html Mon Aug 22 19:05:35 2016
@@ -978,7 +978,7 @@
<tr class="rowColor">
<td class="colOne"><a href="org/apache/poi/ss/usermodel/Cell.html#getCachedFormulaResultTypeEnum()">org.apache.poi.ss.usermodel.Cell.getCachedFormulaResultTypeEnum()</a>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCachedFormulaResultType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</td>
</tr>
<tr class="altColor">
@@ -1033,7 +1033,7 @@
<tr class="rowColor">
<td class="colOne"><a href="org/apache/poi/ss/usermodel/Cell.html#getCellTypeEnum()">org.apache.poi.ss.usermodel.Cell.getCellTypeEnum()</a>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCellType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</td>
</tr>
<tr class="altColor">
Modified: poi/site/publish/apidocs/index-all.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/index-all.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/apidocs/index-all.html (original)
+++ poi/site/publish/apidocs/index-all.html Mon Aug 22 19:05:35 2016
@@ -20848,7 +20848,7 @@
<dd>
<div class="block"><span class="strong">Deprecated.</span>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCachedFormulaResultType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFCell.html#getCachedFormulaResultTypeEnum()">getCachedFormulaResultTypeEnum()</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFCell.html" title="class in org.apache.poi.xssf.streaming">SXSSFCell</a></dt>
@@ -21341,7 +21341,7 @@
<dd>
<div class="block"><span class="strong">Deprecated.</span>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCellType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFCell.html#getCellTypeEnum()">getCellTypeEnum()</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFCell.html" title="class in org.apache.poi.xssf.streaming">SXSSFCell</a></dt>
Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Cell.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Cell.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Cell.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Cell.html Mon Aug 22 19:05:35 2016
@@ -121,7 +121,7 @@
<th class="colLast" scope="col">Field and Description</th>
</tr>
<tr class="altColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
+<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BLANK">CELL_TYPE_BLANK</a></strong></code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#BLANK"><code>CellType.BLANK</code></a> instead.</i></div>
@@ -129,7 +129,7 @@
</td>
</tr>
<tr class="rowColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
+<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BOOLEAN">CELL_TYPE_BOOLEAN</a></strong></code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#BOOLEAN"><code>CellType.BOOLEAN</code></a> instead.</i></div>
@@ -137,7 +137,7 @@
</td>
</tr>
<tr class="altColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
+<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_ERROR">CELL_TYPE_ERROR</a></strong></code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#ERROR"><code>CellType.ERROR</code></a> instead.</i></div>
@@ -145,7 +145,7 @@
</td>
</tr>
<tr class="rowColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
+<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_FORMULA">CELL_TYPE_FORMULA</a></strong></code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#FORMULA"><code>CellType.FORMULA</code></a> instead.</i></div>
@@ -153,7 +153,7 @@
</td>
</tr>
<tr class="altColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
+<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_NUMERIC">CELL_TYPE_NUMERIC</a></strong></code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#NUMERIC"><code>CellType.NUMERIC</code></a> instead.</i></div>
@@ -161,7 +161,7 @@
</td>
</tr>
<tr class="rowColor">
-<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
+<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_STRING">CELL_TYPE_STRING</a></strong></code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#STRING"><code>CellType.STRING</code></a> instead.</i></div>
@@ -214,7 +214,7 @@
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCachedFormulaResultTypeEnum()">getCachedFormulaResultTypeEnum</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCachedFormulaResultType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</div>
</td>
</tr>
@@ -247,7 +247,7 @@
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellTypeEnum()">getCellTypeEnum</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCellType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</div>
</td>
</tr>
@@ -433,11 +433,13 @@
<ul class="blockList">
<li class="blockList">
<h4>CELL_TYPE_NUMERIC</h4>
-<pre>static final <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> CELL_TYPE_NUMERIC</pre>
+<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="4.0")
+static final int CELL_TYPE_NUMERIC</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#NUMERIC"><code>CellType.NUMERIC</code></a> instead.</i></div>
<div class="block">Numeric Cell type (0)</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(int)"><code>setCellType(int)</code></a>,
-<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a></dd></dl>
+<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a>,
+<a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.Cell.CELL_TYPE_NUMERIC">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="CELL_TYPE_STRING">
@@ -446,11 +448,13 @@
<ul class="blockList">
<li class="blockList">
<h4>CELL_TYPE_STRING</h4>
-<pre>static final <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> CELL_TYPE_STRING</pre>
+<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="4.0")
+static final int CELL_TYPE_STRING</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#STRING"><code>CellType.STRING</code></a> instead.</i></div>
<div class="block">String Cell type (1)</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(int)"><code>setCellType(int)</code></a>,
-<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a></dd></dl>
+<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a>,
+<a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.Cell.CELL_TYPE_STRING">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="CELL_TYPE_FORMULA">
@@ -459,11 +463,13 @@
<ul class="blockList">
<li class="blockList">
<h4>CELL_TYPE_FORMULA</h4>
-<pre>static final <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> CELL_TYPE_FORMULA</pre>
+<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="4.0")
+static final int CELL_TYPE_FORMULA</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#FORMULA"><code>CellType.FORMULA</code></a> instead.</i></div>
<div class="block">Formula Cell type (2)</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(int)"><code>setCellType(int)</code></a>,
-<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a></dd></dl>
+<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a>,
+<a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.Cell.CELL_TYPE_FORMULA">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="CELL_TYPE_BLANK">
@@ -472,11 +478,13 @@
<ul class="blockList">
<li class="blockList">
<h4>CELL_TYPE_BLANK</h4>
-<pre>static final <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> CELL_TYPE_BLANK</pre>
+<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="4.0")
+static final int CELL_TYPE_BLANK</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#BLANK"><code>CellType.BLANK</code></a> instead.</i></div>
<div class="block">Blank Cell type (3)</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(int)"><code>setCellType(int)</code></a>,
-<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a></dd></dl>
+<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a>,
+<a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.Cell.CELL_TYPE_BLANK">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="CELL_TYPE_BOOLEAN">
@@ -485,11 +493,13 @@
<ul class="blockList">
<li class="blockList">
<h4>CELL_TYPE_BOOLEAN</h4>
-<pre>static final <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> CELL_TYPE_BOOLEAN</pre>
+<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="4.0")
+static final int CELL_TYPE_BOOLEAN</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#BOOLEAN"><code>CellType.BOOLEAN</code></a> instead.</i></div>
<div class="block">Boolean Cell type (4)</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(int)"><code>setCellType(int)</code></a>,
-<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a></dd></dl>
+<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a>,
+<a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.Cell.CELL_TYPE_BOOLEAN">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="CELL_TYPE_ERROR">
@@ -498,11 +508,13 @@
<ul class="blockListLast">
<li class="blockList">
<h4>CELL_TYPE_ERROR</h4>
-<pre>static final <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> CELL_TYPE_ERROR</pre>
+<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="4.0")
+static final int CELL_TYPE_ERROR</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#ERROR"><code>CellType.ERROR</code></a> instead.</i></div>
<div class="block">Error Cell type (5)</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(int)"><code>setCellType(int)</code></a>,
-<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a></dd></dl>
+<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()"><code>getCellType()</code></a>,
+<a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.Cell.CELL_TYPE_ERROR">Constant Field Values</a></dd></dl>
</li>
</ul>
</li>
@@ -563,7 +575,8 @@
<ul class="blockList">
<li class="blockList">
<h4>setCellType</h4>
-<pre>void setCellType(int cellType)</pre>
+<pre><a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="4.0")
+void setCellType(int cellType)</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(org.apache.poi.ss.usermodel.CellType)"><code>setCellType(CellType)</code></a> instead.</i></div>
<div class="block">Set the cells type (numeric, formula or string).
<p>If the cell currently contains a value, the value will
@@ -612,7 +625,7 @@
<pre>int getCellType()</pre>
<div class="block">Return the cell type.
- Will return <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel"><code>CellType</code></a> in a future version of POI.
+ Will return <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel"><code>CellType</code></a> in version 4.0 of POI.
For forwards compatibility, do not hard-code cell type literals in your code.</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the cell type</dd></dl>
</li>
@@ -624,9 +637,10 @@
<li class="blockList">
<h4>getCellTypeEnum</h4>
<pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a>(<a href="../../../../../org/apache/poi/util/Internal.html#since()">since</a>="POI 3.15 beta 3")
+<a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">@Removal</a>(<a href="../../../../../org/apache/poi/util/Removal.html#version()">version</a>="4.2")
<a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> getCellTypeEnum()</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCellType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
<div class="block">Return the cell type.</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the cell type</dd><dt><span class="strong">Since:</span></dt>
<dd>POI 3.15 beta 3</dd></dl>
@@ -657,7 +671,7 @@
<pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a>(<a href="../../../../../org/apache/poi/util/Internal.html#since()">since</a>="POI 3.15 beta 3")
<a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> getCachedFormulaResultTypeEnum()</pre>
<div class="block"><span class="strong">Deprecated.</span> <i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCachedFormulaResultType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
<div class="block">Only valid for formula cells</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>one of (<a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#NUMERIC"><code>CellType.NUMERIC</code></a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#STRING"><code>CellType.STRING</code></a>,
<a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#BOOLEAN"><code>CellType.BOOLEAN</code></a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#ERROR"><code>CellType.ERROR</code></a>) depending
Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/CellType.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/CellType.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/CellType.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/CellType.html Mon Aug 22 19:05:35 2016
@@ -246,63 +246,6 @@
<!-- -->
</a>
<h3>Uses of <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a> in <a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></h3>
-<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing fields, and an explanation">
-<caption><span>Fields in <a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> declared as <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></span><span class="tabEnd"> </span></caption>
-<tr>
-<th class="colFirst" scope="col">Modifier and Type</th>
-<th class="colLast" scope="col">Field and Description</th>
-</tr>
-<tbody>
-<tr class="altColor">
-<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
-<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BLANK">CELL_TYPE_BLANK</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html#BLANK"><code>BLANK</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
-<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BOOLEAN">CELL_TYPE_BOOLEAN</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html#BOOLEAN"><code>BOOLEAN</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
-<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_ERROR">CELL_TYPE_ERROR</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html#ERROR"><code>ERROR</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
-<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_FORMULA">CELL_TYPE_FORMULA</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html#FORMULA"><code>FORMULA</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
-<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_NUMERIC">CELL_TYPE_NUMERIC</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html#NUMERIC"><code>NUMERIC</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
-<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_STRING">CELL_TYPE_STRING</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html#STRING"><code>STRING</code></a> instead.</i></div>
-</div>
-</td>
-</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/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> that return <a href="../../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></span><span class="tabEnd"> </span></caption>
<tr>
@@ -331,7 +274,7 @@
<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html#getCachedFormulaResultTypeEnum()">getCachedFormulaResultTypeEnum</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCachedFormulaResultType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</div>
</td>
</tr>
@@ -344,7 +287,7 @@
<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellTypeEnum()">getCellTypeEnum</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCellType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</div>
</td>
</tr>
Modified: poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html Mon Aug 22 19:05:35 2016
@@ -10429,7 +10429,7 @@ Compound Document Format.</div>
<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCachedFormulaResultTypeEnum()">getCachedFormulaResultTypeEnum</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCachedFormulaResultType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</div>
</td>
</tr>
@@ -10438,7 +10438,7 @@ Compound Document Format.</div>
<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellTypeEnum()">getCellTypeEnum</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>
<div class="block"><i>POI 3.15 beta 3
- Will be deleted when we make the CellType enum transition. See bug 59791.</i></div>
+ Will be renamed to <code>getCellType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
</div>
</td>
</tr>
Modified: poi/site/publish/apidocs/org/apache/poi/util/class-use/Removal.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/util/class-use/Removal.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/util/class-use/Removal.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/util/class-use/Removal.html Mon Aug 22 19:05:35 2016
@@ -131,6 +131,63 @@ HSSF concepts.</div>
<!-- -->
</a>
<h3>Uses of <a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">Removal</a> in <a href="../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing fields, and an explanation">
+<caption><span>Fields in <a href="../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> with annotations of type <a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">Removal</a></span><span class="tabEnd"> </span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Field and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>static int</code></td>
+<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BLANK">CELL_TYPE_BLANK</a></strong></code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#BLANK"><code>CellType.BLANK</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>static int</code></td>
+<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BOOLEAN">CELL_TYPE_BOOLEAN</a></strong></code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#BOOLEAN"><code>CellType.BOOLEAN</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>static int</code></td>
+<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_ERROR">CELL_TYPE_ERROR</a></strong></code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#ERROR"><code>CellType.ERROR</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>static int</code></td>
+<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_FORMULA">CELL_TYPE_FORMULA</a></strong></code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#FORMULA"><code>CellType.FORMULA</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>static int</code></td>
+<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_NUMERIC">CELL_TYPE_NUMERIC</a></strong></code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#NUMERIC"><code>CellType.NUMERIC</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>static int</code></td>
+<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_STRING">CELL_TYPE_STRING</a></strong></code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellType.html#STRING"><code>CellType.STRING</code></a> instead.</i></div>
+</div>
+</td>
+</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/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> with annotations of type <a href="../../../../../org/apache/poi/util/Removal.html" title="annotation in org.apache.poi.util">Removal</a></span><span class="tabEnd"> </span></caption>
<tr>
@@ -139,6 +196,23 @@ HSSF concepts.</div>
</tr>
<tbody>
<tr class="altColor">
+<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellType.html" title="enum in org.apache.poi.ss.usermodel">CellType</a></code></td>
+<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellTypeEnum()">getCellTypeEnum</a></strong>()</code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 3
+ Will be renamed to <code>getCellType()</code> when we make the CellType enum transition in POI 4.0. See bug 59791.</i></div>
+</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">Cell.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(int)">setCellType</a></strong>(int cellType)</code>
+<div class="block"><strong>Deprecated.</strong>
+<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(org.apache.poi.ss.usermodel.CellType)"><code>Cell.setCellType(CellType)</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><span class="strong">Sheet.</span><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int,%20int)">setZoom</a></strong>(int numerator,
int denominator)</code>
Modified: poi/site/publish/changes.html
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Mon Aug 22 19:05:35 2016
@@ -260,13 +260,16 @@ if (VERSION > 3) {
-<a name="3.15-beta3"></a>
+<a name="3.15"></a>
<div class="h3">
-<h3>Version 3.15-beta3 (2016-08-17)</h3>
+<h3>Version 3.15 (2016-08-23)</h3>
</div>
<ul>
<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60005">60005</a> - XSLF: NPE in XSLFTextParagraph.getDefaultFontSize()</li>
+
+<li>
<img class="icon" alt="add" src="images/add.jpg"> Add Apache commons-collections4 dependency</li>
<li>
Modified: poi/site/publish/changes.rss
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/changes.rss (original)
+++ poi/site/publish/changes.rss Mon Aug 22 19:05:35 2016
@@ -1,6 +1,7 @@
<?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 60005)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 60005) - XSLF: NPE in XSLFTextParagraph.getDefaultFontSize()</description></item>
<item><title> add</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers - Add Apache commons-collections4 dependency</description></item>
<item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - XSSFFormulaEvaluator.evaluateAll() should mirror HSSF and use any setup referenced workbooks</description></item>
<item><title> fix(bug 59736)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 59736) - SS Common: Incorrect evaluation of SUBTOTAL with composite interval</description></item>
Modified: poi/site/publish/spreadsheet/quick-guide.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/quick-guide.html?rev=1757243&r1=1757242&r2=1757243&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/quick-guide.html (original)
+++ poi/site/publish/spreadsheet/quick-guide.html Mon Aug 22 19:05:35 2016
@@ -527,7 +527,7 @@ if (VERSION > 3) {
row.createCell(2).setCellValue(Calendar.getInstance());
row.createCell(3).setCellValue("a string");
row.createCell(4).setCellValue(true);
- row.createCell(5).setCellType(Cell.CELL_TYPE_ERROR);
+ row.createCell(5).setCellType(CellType.ERROR);
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
@@ -768,6 +768,7 @@ if (VERSION > 3) {
<pre class="code">
// import org.apache.poi.ss.usermodel.*;
+ DataFormatter formatter = new DataFormatter();
Sheet sheet1 = wb.getSheetAt(0);
for (Row row : sheet1) {
for (Cell cell : row) {
@@ -775,23 +776,31 @@ if (VERSION > 3) {
System.out.print(cellRef.formatAsString());
System.out.print(" - ");
- switch (cell.getCellType()) {
- case Cell.CELL_TYPE_STRING:
+ // get the text that appears in the cell by getting the cell value and applying any data formats (Date, 0.00, 1.23e9, $1.23, etc)
+ String text = formatter.formatCellValue(cell);
+ System.out.println(text);
+
+ // Alternatively, get the value and format it yourself
+ switch (cell.getCellTypeEnum()) {
+ case CellType.STRING:
System.out.println(cell.getRichStringCellValue().getString());
break;
- case Cell.CELL_TYPE_NUMERIC:
+ case CellType.NUMERIC:
if (DateUtil.isCellDateFormatted(cell)) {
System.out.println(cell.getDateCellValue());
} else {
System.out.println(cell.getNumericCellValue());
}
break;
- case Cell.CELL_TYPE_BOOLEAN:
+ case CellType.BOOLEAN:
System.out.println(cell.getBooleanCellValue());
break;
- case Cell.CELL_TYPE_FORMULA:
+ case CellType.FORMULA:
System.out.println(cell.getCellFormula());
break;
+ case CellType.BLANK:
+ System.out.println();
+ break;
default:
System.out.println();
}
@@ -1064,7 +1073,7 @@ Examples:
Cell cell = row.getCell(3);
if (cell == null)
cell = row.createCell(3);
- cell.setCellType(Cell.CELL_TYPE_STRING);
+ cell.setCellType(CellType.STRING);
cell.setCellValue("a test");
// Write the output to a file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org