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 2017/06/30 12:12:44 UTC

svn commit: r1800381 [6/10] - in /poi/site/publish/apidocs: ./ org/apache/poi/common/usermodel/ org/apache/poi/hslf/usermodel/ org/apache/poi/hssf/model/ org/apache/poi/hssf/usermodel/ org/apache/poi/hssf/usermodel/class-use/ org/apache/poi/hssf/util/ ...

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CellStyle.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CellStyle.html?rev=1800381&r1=1800380&r2=1800381&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CellStyle.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CellStyle.html Fri Jun 30 12:12:42 2017
@@ -64,13 +64,13 @@
 <ul class="subNavList">
 <li>Summary:&nbsp;</li>
 <li>Nested&nbsp;|&nbsp;</li>
-<li><a href="#field_summary">Field</a>&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
 <li>Constr&nbsp;|&nbsp;</li>
 <li><a href="#method_summary">Method</a></li>
 </ul>
 <ul class="subNavList">
 <li>Detail:&nbsp;</li>
-<li><a href="#field_detail">Field</a>&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
 <li>Constr&nbsp;|&nbsp;</li>
 <li><a href="#method_detail">Method</a></li>
 </ul>
@@ -101,373 +101,6 @@
 <div class="summary">
 <ul class="blockList">
 <li class="blockList">
-<!-- =========== FIELD SUMMARY =========== -->
-<ul class="blockList">
-<li class="blockList"><a name="field_summary">
-<!--   -->
-</a>
-<h3>Field Summary</h3>
-<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation">
-<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
-<tr>
-<th class="colFirst" scope="col">Modifier and Type</th>
-<th class="colLast" scope="col">Field and Description</th>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER">ALIGN_CENTER</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#CENTER"><code>HorizontalAlignment.CENTER</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION">ALIGN_CENTER_SELECTION</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#CENTER_SELECTION"><code>HorizontalAlignment.CENTER_SELECTION</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL">ALIGN_FILL</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#FILL"><code>HorizontalAlignment.FILL</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL">ALIGN_GENERAL</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#GENERAL"><code>HorizontalAlignment.GENERAL</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY">ALIGN_JUSTIFY</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#JUSTIFY"><code>HorizontalAlignment.JUSTIFY</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT">ALIGN_LEFT</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#LEFT"><code>HorizontalAlignment.LEFT</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT">ALIGN_RIGHT</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#RIGHT"><code>HorizontalAlignment.RIGHT</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALT_BARS">ALT_BARS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#ALT_BARS"><code>FillPatternType.ALT_BARS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BIG_SPOTS">BIG_SPOTS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#BIG_SPOTS"><code>FillPatternType.BIG_SPOTS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT">BORDER_DASH_DOT</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DASH_DOT"><code>BorderStyle.DASH_DOT</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT">BORDER_DASH_DOT_DOT</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DASH_DOT_DOT"><code>BorderStyle.DASH_DOT_DOT</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED">BORDER_DASHED</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DASHED"><code>BorderStyle.DASHED</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED">BORDER_DOTTED</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DOTTED"><code>BorderStyle.DOTTED</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE">BORDER_DOUBLE</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DOUBLE"><code>BorderStyle.DOUBLE</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR">BORDER_HAIR</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#HAIR"><code>BorderStyle.HAIR</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM">BORDER_MEDIUM</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#MEDIUM"><code>BorderStyle.MEDIUM</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT">BORDER_MEDIUM_DASH_DOT</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#MEDIUM_DASH_DOT"><code>BorderStyle.MEDIUM_DASH_DOT</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT">BORDER_MEDIUM_DASH_DOT_DOT</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#MEDIUM_DASH_DOT_DOT"><code>BorderStyle.MEDIUM_DASH_DOT_DOT</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED">BORDER_MEDIUM_DASHED</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#MEDIUM_DASHED"><code>BorderStyle.MEDIUM_DASHED</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE">BORDER_NONE</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#NONE"><code>BorderStyle.NONE</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT">BORDER_SLANTED_DASH_DOT</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#SLANTED_DASH_DOT"><code>BorderStyle.SLANTED_DASH_DOT</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK">BORDER_THICK</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#THICK"><code>BorderStyle.THICK</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN">BORDER_THIN</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#THIN"><code>BorderStyle.THIN</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BRICKS">BRICKS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#BRICKS"><code>FillPatternType.BRICKS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#DIAMONDS">DIAMONDS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#DIAMONDS"><code>FillPatternType.DIAMONDS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#FINE_DOTS">FINE_DOTS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#FINE_DOTS"><code>FillPatternType.FINE_DOTS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#LEAST_DOTS">LEAST_DOTS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#LEAST_DOTS"><code>FillPatternType.LEAST_DOTS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#LESS_DOTS">LESS_DOTS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#LESS_DOTS"><code>FillPatternType.LESS_DOTS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL">NO_FILL</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#NO_FILL"><code>FillPatternType.NO_FILL</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND">SOLID_FOREGROUND</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#SOLID_FOREGROUND"><code>FillPatternType.SOLID_FOREGROUND</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SPARSE_DOTS">SPARSE_DOTS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#SPARSE_DOTS"><code>FillPatternType.SPARSE_DOTS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SQUARES">SQUARES</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#SQUARES"><code>FillPatternType.SQUARES</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_BACKWARD_DIAG">THICK_BACKWARD_DIAG</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THICK_BACKWARD_DIAG"><code>FillPatternType.THICK_BACKWARD_DIAG</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_FORWARD_DIAG">THICK_FORWARD_DIAG</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THICK_FORWARD_DIAG"><code>FillPatternType.THICK_FORWARD_DIAG</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_HORZ_BANDS">THICK_HORZ_BANDS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THICK_HORZ_BANDS"><code>FillPatternType.THICK_HORZ_BANDS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_VERT_BANDS">THICK_VERT_BANDS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THICK_VERT_BANDS"><code>FillPatternType.THICK_VERT_BANDS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_BACKWARD_DIAG">THIN_BACKWARD_DIAG</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THIN_BACKWARD_DIAG"><code>FillPatternType.THIN_BACKWARD_DIAG</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_FORWARD_DIAG">THIN_FORWARD_DIAG</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THIN_FORWARD_DIAG"><code>FillPatternType.THIN_FORWARD_DIAG</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_HORZ_BANDS">THIN_HORZ_BANDS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THIN_HORZ_BANDS"><code>FillPatternType.THIN_HORZ_BANDS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_VERT_BANDS">THIN_VERT_BANDS</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THIN_VERT_BANDS"><code>FillPatternType.THIN_VERT_BANDS</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM">VERTICAL_BOTTOM</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#BOTTOM"><code>VerticalAlignment.BOTTOM</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER">VERTICAL_CENTER</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#CENTER"><code>VerticalAlignment.CENTER</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY">VERTICAL_JUSTIFY</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#JUSTIFY"><code>VerticalAlignment.JUSTIFY</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>static short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP">VERTICAL_TOP</a></strong></code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#TOP"><code>VerticalAlignment.TOP</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-</table>
-</li>
-</ul>
 <!-- ========== METHOD SUMMARY =========== -->
 <ul class="blockList">
 <li class="blockList"><a name="method_summary">
@@ -671,828 +304,192 @@
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRightBorderColor()">getRightBorderColor</a></strong>()</code>
 <div class="block">get the color to use for the left border</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRotation()">getRotation</a></strong>()</code>
-<div class="block">get the degree of rotation for the text in the cell.</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>boolean</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getShrinkToFit()">getShrinkToFit</a></strong>()</code>
-<div class="block">Should the Cell be auto-sized by Excel to shrink
-  it to fit if this text is too long?</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getTopBorderColor()">getTopBorderColor</a></strong>()</code>
-<div class="block">get the color to use for the top border</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>short</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getVerticalAlignment()">getVerticalAlignment</a></strong>()</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getVerticalAlignmentEnum()"><code>getVerticalAlignmentEnum()</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<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/ss/usermodel/CellStyle.html#getVerticalAlignmentEnum()">getVerticalAlignmentEnum</a></strong>()</code>
-<div class="block">get the type of vertical alignment for the cell</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>boolean</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getWrapText()">getWrapText</a></strong>()</code>
-<div class="block">get whether the text should be wrapped</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setAlignment(short)">setAlignment</a></strong>(short&nbsp;align)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setAlignment(org.apache.poi.ss.usermodel.HorizontalAlignment)"><code>setAlignment(HorizontalAlignment)</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderBottom(short)">setBorderBottom</a></strong>(short&nbsp;border)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderBottom(org.apache.poi.ss.usermodel.BorderStyle)"><code>setBorderBottom(BorderStyle)</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderLeft(short)">setBorderLeft</a></strong>(short&nbsp;border)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderLeft(org.apache.poi.ss.usermodel.BorderStyle)"><code>setBorderLeft(BorderStyle)</code></a> instead</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderRight(short)">setBorderRight</a></strong>(short&nbsp;border)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderRight(org.apache.poi.ss.usermodel.BorderStyle)"><code>setBorderRight(BorderStyle)</code></a> instead</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderTop(short)">setBorderTop</a></strong>(short&nbsp;border)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderTop(org.apache.poi.ss.usermodel.BorderStyle)"><code>setBorderTop(BorderStyle)</code></a> instead</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setDataFormat(short)">setDataFormat</a></strong>(short&nbsp;fmt)</code>
-<div class="block">set the data format (must be a valid format).</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillBackgroundColor(short)">setFillBackgroundColor</a></strong>(short&nbsp;bg)</code>
-<div class="block">set the background fill color.</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillForegroundColor(short)">setFillForegroundColor</a></strong>(short&nbsp;bg)</code>
-<div class="block">set the foreground fill color
- <i>Note: Ensure Foreground color is set prior to background color.</i></div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillPattern(org.apache.poi.ss.usermodel.FillPatternType)">setFillPattern</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html" title="enum in org.apache.poi.ss.usermodel">FillPatternType</a>&nbsp;fp)</code>
-<div class="block">setting to one fills the cell with the foreground color...</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillPattern(short)">setFillPattern</a></strong>(short&nbsp;fp)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillPattern(org.apache.poi.ss.usermodel.FillPatternType)"><code>setFillPattern(FillPatternType)</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFont(org.apache.poi.ss.usermodel.Font)">setFont</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a>&nbsp;font)</code>
-<div class="block">set the font for this style</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setHidden(boolean)">setHidden</a></strong>(boolean&nbsp;hidden)</code>
-<div class="block">set the cell's using this style to be hidden</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setIndention(short)">setIndention</a></strong>(short&nbsp;indent)</code>
-<div class="block">set the number of spaces to indent the text in the cell</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLeftBorderColor(short)">setLeftBorderColor</a></strong>(short&nbsp;color)</code>
-<div class="block">set the color to use for the left border</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLocked(boolean)">setLocked</a></strong>(boolean&nbsp;locked)</code>
-<div class="block">set the cell's using this style to be locked</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setQuotePrefixed(boolean)">setQuotePrefixed</a></strong>(boolean&nbsp;quotePrefix)</code>
-<div class="block">Turn on or off "Quote Prefix" or "123 Prefix" for the style,
-  which is used to tell Excel that the thing which looks like
-  a number or a formula shouldn't be treated as on.</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRightBorderColor(short)">setRightBorderColor</a></strong>(short&nbsp;color)</code>
-<div class="block">set the color to use for the right border</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRotation(short)">setRotation</a></strong>(short&nbsp;rotation)</code>
-<div class="block">set the degree of rotation for the text in the cell.</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setShrinkToFit(boolean)">setShrinkToFit</a></strong>(boolean&nbsp;shrinkToFit)</code>
-<div class="block">Controls if the Cell should be auto-sized
-  to shrink to fit if the text is too long</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setTopBorderColor(short)">setTopBorderColor</a></strong>(short&nbsp;color)</code>
-<div class="block">set the color to use for the top border</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setVerticalAlignment(short)">setVerticalAlignment</a></strong>(short&nbsp;align)</code>
-<div class="block"><strong>Deprecated.</strong>&nbsp;
-<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setVerticalAlignment(org.apache.poi.ss.usermodel.VerticalAlignment)"><code>setVerticalAlignment(VerticalAlignment)</code></a> instead.</i></div>
-</div>
-</td>
-</tr>
-<tr class="rowColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setVerticalAlignment(org.apache.poi.ss.usermodel.VerticalAlignment)">setVerticalAlignment</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel">VerticalAlignment</a>&nbsp;align)</code>
-<div class="block">set the type of vertical alignment for the cell</div>
-</td>
-</tr>
-<tr class="altColor">
-<td class="colFirst"><code>void</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setWrapText(boolean)">setWrapText</a></strong>(boolean&nbsp;wrapped)</code>
-<div class="block">Set whether the text should be wrapped.</div>
-</td>
-</tr>
-</table>
-</li>
-</ul>
-</li>
-</ul>
-</div>
-<div class="details">
-<ul class="blockList">
-<li class="blockList">
-<!-- ============ FIELD DETAIL =========== -->
-<ul class="blockList">
-<li class="blockList"><a name="field_detail">
-<!--   -->
-</a>
-<h3>Field Detail</h3>
-<a name="ALIGN_GENERAL">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>ALIGN_GENERAL</h4>
-<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>="3.17")
-static final&nbsp;short ALIGN_GENERAL</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#GENERAL"><code>HorizontalAlignment.GENERAL</code></a> instead.</i></div>
-<div class="block">general (normal) horizontal alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_GENERAL">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="ALIGN_LEFT">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>ALIGN_LEFT</h4>
-<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>="3.17")
-static final&nbsp;short ALIGN_LEFT</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#LEFT"><code>HorizontalAlignment.LEFT</code></a> instead.</i></div>
-<div class="block">left-justified horizontal alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_LEFT">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="ALIGN_CENTER">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>ALIGN_CENTER</h4>
-<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>="3.17")
-static final&nbsp;short ALIGN_CENTER</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#CENTER"><code>HorizontalAlignment.CENTER</code></a> instead.</i></div>
-<div class="block">center horizontal alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_CENTER">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="ALIGN_RIGHT">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>ALIGN_RIGHT</h4>
-<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>="3.17")
-static final&nbsp;short ALIGN_RIGHT</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#RIGHT"><code>HorizontalAlignment.RIGHT</code></a> instead.</i></div>
-<div class="block">right-justified horizontal alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_RIGHT">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="ALIGN_FILL">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>ALIGN_FILL</h4>
-<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>="3.17")
-static final&nbsp;short ALIGN_FILL</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#FILL"><code>HorizontalAlignment.FILL</code></a> instead.</i></div>
-<div class="block">fill? horizontal alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_FILL">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="ALIGN_JUSTIFY">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>ALIGN_JUSTIFY</h4>
-<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>="3.17")
-static final&nbsp;short ALIGN_JUSTIFY</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#JUSTIFY"><code>HorizontalAlignment.JUSTIFY</code></a> instead.</i></div>
-<div class="block">justified horizontal alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_JUSTIFY">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="ALIGN_CENTER_SELECTION">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>ALIGN_CENTER_SELECTION</h4>
-<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>="3.17")
-static final&nbsp;short ALIGN_CENTER_SELECTION</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html#CENTER_SELECTION"><code>HorizontalAlignment.CENTER_SELECTION</code></a> instead.</i></div>
-<div class="block">center-selection? horizontal alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_CENTER_SELECTION">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="VERTICAL_TOP">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>VERTICAL_TOP</h4>
-<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>="3.17")
-static final&nbsp;short VERTICAL_TOP</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#TOP"><code>VerticalAlignment.TOP</code></a> instead.</i></div>
-<div class="block">top-aligned vertical alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.VERTICAL_TOP">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="VERTICAL_CENTER">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>VERTICAL_CENTER</h4>
-<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>="3.17")
-static final&nbsp;short VERTICAL_CENTER</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#CENTER"><code>VerticalAlignment.CENTER</code></a> instead.</i></div>
-<div class="block">center-aligned vertical alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.VERTICAL_CENTER">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="VERTICAL_BOTTOM">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>VERTICAL_BOTTOM</h4>
-<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>="3.17")
-static final&nbsp;short VERTICAL_BOTTOM</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#BOTTOM"><code>VerticalAlignment.BOTTOM</code></a> instead.</i></div>
-<div class="block">bottom-aligned vertical alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.VERTICAL_BOTTOM">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="VERTICAL_JUSTIFY">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>VERTICAL_JUSTIFY</h4>
-<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>="3.17")
-static final&nbsp;short VERTICAL_JUSTIFY</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#JUSTIFY"><code>VerticalAlignment.JUSTIFY</code></a> instead.</i></div>
-<div class="block">vertically justified vertical alignment</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.VERTICAL_JUSTIFY">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_NONE">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_NONE</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_NONE</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#NONE"><code>BorderStyle.NONE</code></a> instead.</i></div>
-<div class="block">No border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_NONE">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_THIN">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_THIN</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_THIN</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#THIN"><code>BorderStyle.THIN</code></a> instead.</i></div>
-<div class="block">Thin border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_THIN">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_MEDIUM">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_MEDIUM</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_MEDIUM</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#MEDIUM"><code>BorderStyle.MEDIUM</code></a> instead.</i></div>
-<div class="block">Medium border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_MEDIUM">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_DASHED">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_DASHED</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_DASHED</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DASHED"><code>BorderStyle.DASHED</code></a> instead.</i></div>
-<div class="block">dash border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DASHED">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_DOTTED">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_DOTTED</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_DOTTED</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DOTTED"><code>BorderStyle.DOTTED</code></a> instead.</i></div>
-<div class="block">dot border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DOTTED">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_THICK">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_THICK</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_THICK</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#THICK"><code>BorderStyle.THICK</code></a> instead.</i></div>
-<div class="block">Thick border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_THICK">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_DOUBLE">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_DOUBLE</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_DOUBLE</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DOUBLE"><code>BorderStyle.DOUBLE</code></a> instead.</i></div>
-<div class="block">double-line border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DOUBLE">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_HAIR">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_HAIR</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_HAIR</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#HAIR"><code>BorderStyle.HAIR</code></a> instead.</i></div>
-<div class="block">hair-line border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_HAIR">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_MEDIUM_DASHED">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_MEDIUM_DASHED</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_MEDIUM_DASHED</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#MEDIUM_DASHED"><code>BorderStyle.MEDIUM_DASHED</code></a> instead.</i></div>
-<div class="block">Medium dashed border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_MEDIUM_DASHED">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_DASH_DOT">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_DASH_DOT</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_DASH_DOT</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DASH_DOT"><code>BorderStyle.DASH_DOT</code></a> instead.</i></div>
-<div class="block">dash-dot border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DASH_DOT">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_MEDIUM_DASH_DOT">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_MEDIUM_DASH_DOT</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_MEDIUM_DASH_DOT</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#MEDIUM_DASH_DOT"><code>BorderStyle.MEDIUM_DASH_DOT</code></a> instead.</i></div>
-<div class="block">medium dash-dot border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_MEDIUM_DASH_DOT">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_DASH_DOT_DOT">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_DASH_DOT_DOT</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_DASH_DOT_DOT</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#DASH_DOT_DOT"><code>BorderStyle.DASH_DOT_DOT</code></a> instead.</i></div>
-<div class="block">dash-dot-dot border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DASH_DOT_DOT">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_MEDIUM_DASH_DOT_DOT">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_MEDIUM_DASH_DOT_DOT</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_MEDIUM_DASH_DOT_DOT</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#MEDIUM_DASH_DOT_DOT"><code>BorderStyle.MEDIUM_DASH_DOT_DOT</code></a> instead.</i></div>
-<div class="block">medium dash-dot-dot border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_MEDIUM_DASH_DOT_DOT">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BORDER_SLANTED_DASH_DOT">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BORDER_SLANTED_DASH_DOT</h4>
-<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>="3.17")
-static final&nbsp;short BORDER_SLANTED_DASH_DOT</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 2. Use <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#SLANTED_DASH_DOT"><code>BorderStyle.SLANTED_DASH_DOT</code></a> instead.</i></div>
-<div class="block">slanted dash-dot border</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_SLANTED_DASH_DOT">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="NO_FILL">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>NO_FILL</h4>
-<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>="3.17")
-static final&nbsp;short NO_FILL</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#NO_FILL"><code>FillPatternType.NO_FILL</code></a> instead.</i></div>
-<div class="block">Fill Pattern: No background</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.NO_FILL">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="SOLID_FOREGROUND">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>SOLID_FOREGROUND</h4>
-<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>="3.17")
-static final&nbsp;short SOLID_FOREGROUND</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#SOLID_FOREGROUND"><code>FillPatternType.SOLID_FOREGROUND</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Solidly filled</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.SOLID_FOREGROUND">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="FINE_DOTS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>FINE_DOTS</h4>
-<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>="3.17")
-static final&nbsp;short FINE_DOTS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#FINE_DOTS"><code>FillPatternType.FINE_DOTS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Small fine dots</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.FINE_DOTS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="ALT_BARS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>ALT_BARS</h4>
-<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>="3.17")
-static final&nbsp;short ALT_BARS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#ALT_BARS"><code>FillPatternType.ALT_BARS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Wide dots</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALT_BARS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="SPARSE_DOTS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>SPARSE_DOTS</h4>
-<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>="3.17")
-static final&nbsp;short SPARSE_DOTS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#SPARSE_DOTS"><code>FillPatternType.SPARSE_DOTS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Sparse dots</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.SPARSE_DOTS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="THICK_HORZ_BANDS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>THICK_HORZ_BANDS</h4>
-<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>="3.17")
-static final&nbsp;short THICK_HORZ_BANDS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THICK_HORZ_BANDS"><code>FillPatternType.THICK_HORZ_BANDS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Thick horizontal bands</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THICK_HORZ_BANDS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="THICK_VERT_BANDS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>THICK_VERT_BANDS</h4>
-<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>="3.17")
-static final&nbsp;short THICK_VERT_BANDS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THICK_VERT_BANDS"><code>FillPatternType.THICK_VERT_BANDS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Thick vertical bands</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THICK_VERT_BANDS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="THICK_BACKWARD_DIAG">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>THICK_BACKWARD_DIAG</h4>
-<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>="3.17")
-static final&nbsp;short THICK_BACKWARD_DIAG</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THICK_BACKWARD_DIAG"><code>FillPatternType.THICK_BACKWARD_DIAG</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Thick backward facing diagonals</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THICK_BACKWARD_DIAG">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="THICK_FORWARD_DIAG">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>THICK_FORWARD_DIAG</h4>
-<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>="3.17")
-static final&nbsp;short THICK_FORWARD_DIAG</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THICK_FORWARD_DIAG"><code>FillPatternType.THICK_FORWARD_DIAG</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Thick forward facing diagonals</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THICK_FORWARD_DIAG">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BIG_SPOTS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BIG_SPOTS</h4>
-<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>="3.17")
-static final&nbsp;short BIG_SPOTS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#BIG_SPOTS"><code>FillPatternType.BIG_SPOTS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Large spots</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BIG_SPOTS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="BRICKS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>BRICKS</h4>
-<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>="3.17")
-static final&nbsp;short BRICKS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#BRICKS"><code>FillPatternType.BRICKS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Brick-like layout</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BRICKS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="THIN_HORZ_BANDS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>THIN_HORZ_BANDS</h4>
-<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>="3.17")
-static final&nbsp;short THIN_HORZ_BANDS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THIN_HORZ_BANDS"><code>FillPatternType.THIN_HORZ_BANDS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Thin horizontal bands</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THIN_HORZ_BANDS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="THIN_VERT_BANDS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>THIN_VERT_BANDS</h4>
-<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>="3.17")
-static final&nbsp;short THIN_VERT_BANDS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THIN_VERT_BANDS"><code>FillPatternType.THIN_VERT_BANDS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Thin vertical bands</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THIN_VERT_BANDS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="THIN_BACKWARD_DIAG">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>THIN_BACKWARD_DIAG</h4>
-<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>="3.17")
-static final&nbsp;short THIN_BACKWARD_DIAG</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THIN_BACKWARD_DIAG"><code>FillPatternType.THIN_BACKWARD_DIAG</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Thin backward diagonal</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THIN_BACKWARD_DIAG">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="THIN_FORWARD_DIAG">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>THIN_FORWARD_DIAG</h4>
-<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>="3.17")
-static final&nbsp;short THIN_FORWARD_DIAG</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#THIN_FORWARD_DIAG"><code>FillPatternType.THIN_FORWARD_DIAG</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Thin forward diagonal</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THIN_FORWARD_DIAG">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="SQUARES">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>SQUARES</h4>
-<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>="3.17")
-static final&nbsp;short SQUARES</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#SQUARES"><code>FillPatternType.SQUARES</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Squares</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.SQUARES">Constant Field Values</a></dd></dl>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>short</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRotation()">getRotation</a></strong>()</code>
+<div class="block">get the degree of rotation for the text in the cell.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>boolean</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getShrinkToFit()">getShrinkToFit</a></strong>()</code>
+<div class="block">Should the Cell be auto-sized by Excel to shrink
+  it to fit if this text is too long?</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>short</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getTopBorderColor()">getTopBorderColor</a></strong>()</code>
+<div class="block">get the color to use for the top border</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>short</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getVerticalAlignment()">getVerticalAlignment</a></strong>()</code>
+<div class="block"><strong>Deprecated.</strong>&nbsp;
+<div class="block"><i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getVerticalAlignmentEnum()"><code>getVerticalAlignmentEnum()</code></a> instead.</i></div>
+</div>
+</td>
+</tr>
+<tr class="altColor">
+<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/ss/usermodel/CellStyle.html#getVerticalAlignmentEnum()">getVerticalAlignmentEnum</a></strong>()</code>
+<div class="block">get the type of vertical alignment for the cell</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>boolean</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getWrapText()">getWrapText</a></strong>()</code>
+<div class="block">get whether the text should be wrapped</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.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="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setDataFormat(short)">setDataFormat</a></strong>(short&nbsp;fmt)</code>
+<div class="block">set the data format (must be a valid format).</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillBackgroundColor(short)">setFillBackgroundColor</a></strong>(short&nbsp;bg)</code>
+<div class="block">set the background fill color.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillForegroundColor(short)">setFillForegroundColor</a></strong>(short&nbsp;bg)</code>
+<div class="block">set the foreground fill color
+ <i>Note: Ensure Foreground color is set prior to background color.</i></div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillPattern(org.apache.poi.ss.usermodel.FillPatternType)">setFillPattern</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html" title="enum in org.apache.poi.ss.usermodel">FillPatternType</a>&nbsp;fp)</code>
+<div class="block">setting to one fills the cell with the foreground color...</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFont(org.apache.poi.ss.usermodel.Font)">setFont</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a>&nbsp;font)</code>
+<div class="block">set the font for this style</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setHidden(boolean)">setHidden</a></strong>(boolean&nbsp;hidden)</code>
+<div class="block">set the cell's using this style to be hidden</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setIndention(short)">setIndention</a></strong>(short&nbsp;indent)</code>
+<div class="block">set the number of spaces to indent the text in the cell</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLeftBorderColor(short)">setLeftBorderColor</a></strong>(short&nbsp;color)</code>
+<div class="block">set the color to use for the left border</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLocked(boolean)">setLocked</a></strong>(boolean&nbsp;locked)</code>
+<div class="block">set the cell's using this style to be locked</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setQuotePrefixed(boolean)">setQuotePrefixed</a></strong>(boolean&nbsp;quotePrefix)</code>
+<div class="block">Turn on or off "Quote Prefix" or "123 Prefix" for the style,
+  which is used to tell Excel that the thing which looks like
+  a number or a formula shouldn't be treated as on.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRightBorderColor(short)">setRightBorderColor</a></strong>(short&nbsp;color)</code>
+<div class="block">set the color to use for the right border</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRotation(short)">setRotation</a></strong>(short&nbsp;rotation)</code>
+<div class="block">set the degree of rotation for the text in the cell.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setShrinkToFit(boolean)">setShrinkToFit</a></strong>(boolean&nbsp;shrinkToFit)</code>
+<div class="block">Controls if the Cell should be auto-sized
+  to shrink to fit if the text is too long</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setTopBorderColor(short)">setTopBorderColor</a></strong>(short&nbsp;color)</code>
+<div class="block">set the color to use for the top border</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setVerticalAlignment(org.apache.poi.ss.usermodel.VerticalAlignment)">setVerticalAlignment</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel">VerticalAlignment</a>&nbsp;align)</code>
+<div class="block">set the type of vertical alignment for the cell</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setWrapText(boolean)">setWrapText</a></strong>(boolean&nbsp;wrapped)</code>
+<div class="block">Set whether the text should be wrapped.</div>
+</td>
+</tr>
+</table>
 </li>
 </ul>
-<a name="DIAMONDS">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>DIAMONDS</h4>
-<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>="3.17")
-static final&nbsp;short DIAMONDS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#DIAMONDS"><code>FillPatternType.DIAMONDS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Diamonds</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.DIAMONDS">Constant Field Values</a></dd></dl>
 </li>
 </ul>
-<a name="LESS_DOTS">
-<!--   -->
-</a>
+</div>
+<div class="details">
 <ul class="blockList">
 <li class="blockList">
-<h4>LESS_DOTS</h4>
-<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>="3.17")
-static final&nbsp;short LESS_DOTS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#LESS_DOTS"><code>FillPatternType.LESS_DOTS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Less Dots</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.LESS_DOTS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-<a name="LEAST_DOTS">
-<!--   -->
-</a>
-<ul class="blockListLast">
-<li class="blockList">
-<h4>LEAST_DOTS</h4>
-<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>="3.17")
-static final&nbsp;short LEAST_DOTS</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#LEAST_DOTS"><code>FillPatternType.LEAST_DOTS</code></a> instead.</i></div>
-<div class="block">Fill Pattern: Least Dots</div>
-<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.LEAST_DOTS">Constant Field Values</a></dd></dl>
-</li>
-</ul>
-</li>
-</ul>
 <!-- ============ METHOD DETAIL ========== -->
 <ul class="blockList">
 <li class="blockList"><a name="method_detail">
@@ -1636,24 +633,6 @@ static final&nbsp;short LEAST_DOTS</pre>
   like prefixing the cell value with a ' in Excel</div>
 </li>
 </ul>
-<a name="setAlignment(short)">
-<!--   -->
-</a>
-<ul class="blockList">
-<li class="blockList">
-<h4>setAlignment</h4>
-<pre>void&nbsp;setAlignment(short&nbsp;align)</pre>
-<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>POI 3.15 beta 3. Use <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setAlignment(org.apache.poi.ss.usermodel.HorizontalAlignment)"><code>setAlignment(HorizontalAlignment)</code></a> instead.</i></div>
-<div class="block">set the type of horizontal alignment for the cell</div>
-<dl><dt><span class="strong">Parameters:</span></dt><dd><code>align</code> - - the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL"><code>ALIGN_GENERAL</code></a>, 
-<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT"><code>ALIGN_LEFT</code></a>, 
-<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER"><code>ALIGN_CENTER</code></a>, 
-<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT"><code>ALIGN_RIGHT</code></a>, 
-<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL"><code>ALIGN_FILL</code></a>, 
-<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY"><code>ALIGN_JUSTIFY</code></a>, 

[... 266 lines stripped ...]


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