poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1754692 [2/2] - in /poi/site/publish: apidocs/ apidocs/org/apache/poi/ss/usermodel/ apidocs/org/apache/poi/ss/usermodel/class-use/ apidocs/org/apache/poi/ss/util/ apidocs/org/apache/poi/ss/util/class-use/ spreadsheet/
Date Mon, 01 Aug 2016 00:06:39 GMT
Added: poi/site/publish/apidocs/org/apache/poi/ss/util/CellStyleTemplate.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/CellStyleTemplate.html?rev=1754692&view=auto
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/CellStyleTemplate.html (added)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/CellStyleTemplate.html Mon Aug  1 00:06:39 2016
@@ -0,0 +1,491 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<!-- NewPage -->
+<html lang="en">
+<head>
+<title>CellStyleTemplate (POI API Documentation)</title>
+<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
+</head>
+<body>
+<script type="text/javascript"><!--
+    if (location.href.indexOf('is-external=true') == -1) {
+        parent.document.title="CellStyleTemplate (POI API Documentation)";
+    }
+//-->
+</script>
+<noscript>
+<div>JavaScript is disabled on your browser.</div>
+</noscript>
+<!-- ========= START OF TOP NAVBAR ======= -->
+<div class="topNav"><a name="navbar_top">
+<!--   -->
+</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../overview-summary.html">Overview</a></li>
+<li><a href="package-summary.html">Package</a></li>
+<li class="navBarCell1Rev">Class</li>
+<li><a href="class-use/CellStyleTemplate.html">Use</a></li>
+<li><a href="package-tree.html">Tree</a></li>
+<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li><a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/util/CellUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../index.html?org/apache/poi/ss/util/CellStyleTemplate.html" target="_top">Frames</a></li>
+<li><a href="CellStyleTemplate.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_top">
+<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_top");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<div>
+<ul class="subNavList">
+<li>Summary:&nbsp;</li>
+<li>Nested&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li><a href="#constructor_summary">Constr</a>&nbsp;|&nbsp;</li>
+<li><a href="#method_summary">Method</a></li>
+</ul>
+<ul class="subNavList">
+<li>Detail:&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li><a href="#constructor_detail">Constr</a>&nbsp;|&nbsp;</li>
+<li><a href="#method_detail">Method</a></li>
+</ul>
+</div>
+<a name="skip-navbar_top">
+<!--   -->
+</a></div>
+<!-- ========= END OF TOP NAVBAR ========= -->
+<!-- ======== START OF CLASS DATA ======== -->
+<div class="header">
+<div class="subTitle">org.apache.poi.ss.util</div>
+<h2 title="Class CellStyleTemplate" class="title">Class CellStyleTemplate</h2>
+</div>
+<div class="contentContainer">
+<ul class="inheritance">
+<li>java.lang.Object</li>
+<li>
+<ul class="inheritance">
+<li>org.apache.poi.ss.util.CellStyleTemplate</li>
+</ul>
+</li>
+</ul>
+<div class="description">
+<ul class="blockList">
+<li class="blockList">
+<hr>
+<br>
+<pre>public final class <span class="strong">CellStyleTemplate</span>
+extends java.lang.Object</pre>
+<div class="block"><p>
+ A <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util"><code>CellStyleTemplate</code></a> is a template that can be applied to any sheet in
+ a project. It contains all the border type and color attributes needed to
+ draw all the borders for a single sheet. That template can be applied to any
+ sheet in any workbook.
+ 
+ This class requires the full spreadsheet to be in memory so
+ <code>SWorkbook</code> Spreadsheets are not supported. The same
+ <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util"><code>CellStyleTemplate</code></a> can, however, be applied to both
+ <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel"><code>HSSFWorkbook</code></a>, and Workbook objects
+ if necessary. Portions of the border that fall outside the max range of the
+ <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel"><code>HSSFWorkbook</code></a> sheet are ignored.
+ </p>
+ 
+ <p>
+ This would replace <a href="../../../../../org/apache/poi/ss/util/RegionUtil.html" title="class in org.apache.poi.ss.util"><code>RegionUtil</code></a>.
+ </p></div>
+</li>
+</ul>
+</div>
+<div class="summary">
+<ul class="blockList">
+<li class="blockList">
+<!-- ======== CONSTRUCTOR SUMMARY ======== -->
+<ul class="blockList">
+<li class="blockList"><a name="constructor_summary">
+<!--   -->
+</a>
+<h3>Constructor Summary</h3>
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation">
+<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Constructor and Description</th>
+</tr>
+<tr class="altColor">
+<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#CellStyleTemplate()">CellStyleTemplate</a></strong>()</code>
+<div class="block">Create a new Cell Style Template</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#CellStyleTemplate(org.apache.poi.ss.util.CellStyleTemplate)">CellStyleTemplate</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">CellStyleTemplate</a>&nbsp;other)</code>
+<div class="block">Create a new Cell Style Template</div>
+</td>
+</tr>
+</table>
+</li>
+</ul>
+<!-- ========== METHOD SUMMARY =========== -->
+<ul class="blockList">
+<li class="blockList"><a name="method_summary">
+<!--   -->
+</a>
+<h3>Method Summary</h3>
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
+<caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#applyBorders(org.apache.poi.ss.usermodel.Sheet)">applyBorders</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sheet)</code>
+<div class="block">Applies the drawn borders to a Sheet.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorderColors(org.apache.poi.ss.util.CellRangeAddress,%20short,%20org.apache.poi.ss.util.BorderExtent)">drawBorderColors</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+                short&nbsp;color,
+                <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Sets the color for a group of cell borders for a cell range.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.util.BorderExtent)">drawBorders</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+           <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;borderStyle,
+           <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Draws a group of cell borders for a cell range.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20short,%20org.apache.poi.ss.util.BorderExtent)">drawBorders</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+           <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;borderStyle,
+           short&nbsp;color,
+           <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Draws a group of cell borders for a cell range.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getNumBorderColors(org.apache.poi.ss.util.CellAddress)">getNumBorderColors</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell)</code>
+<div class="block">Retrieves the number of border colors assigned to a cell</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getNumBorderColors(int,%20int)">getNumBorderColors</a></strong>(int&nbsp;row,
+                  int&nbsp;col)</code>
+<div class="block">Retrieves the number of border colors assigned to a cell</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getNumBorders(org.apache.poi.ss.util.CellAddress)">getNumBorders</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell)</code>
+<div class="block">Retrieves the number of borders assigned to a cell</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getNumBorders(int,%20int)">getNumBorders</a></strong>(int&nbsp;row,
+             int&nbsp;col)</code>
+<div class="block">Retrieves the number of borders assigned to a cell</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>short</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getTemplateProperty(org.apache.poi.ss.util.CellAddress,%20java.lang.String)">getTemplateProperty</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell,
+                   java.lang.String&nbsp;property)</code>
+<div class="block">Retrieves the border style for a given cell</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>short</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getTemplateProperty(int,%20int,%20java.lang.String)">getTemplateProperty</a></strong>(int&nbsp;row,
+                   int&nbsp;col,
+                   java.lang.String&nbsp;property)</code>
+<div class="block">Retrieves the border style for a given cell</div>
+</td>
+</tr>
+</table>
+<ul class="blockList">
+<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
+<!--   -->
+</a>
+<h3>Methods inherited from class&nbsp;java.lang.Object</h3>
+<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li>
+</ul>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<div class="details">
+<ul class="blockList">
+<li class="blockList">
+<!-- ========= CONSTRUCTOR DETAIL ======== -->
+<ul class="blockList">
+<li class="blockList"><a name="constructor_detail">
+<!--   -->
+</a>
+<h3>Constructor Detail</h3>
+<a name="CellStyleTemplate()">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>CellStyleTemplate</h4>
+<pre>public&nbsp;CellStyleTemplate()</pre>
+<div class="block">Create a new Cell Style Template</div>
+</li>
+</ul>
+<a name="CellStyleTemplate(org.apache.poi.ss.util.CellStyleTemplate)">
+<!--   -->
+</a>
+<ul class="blockListLast">
+<li class="blockList">
+<h4>CellStyleTemplate</h4>
+<pre>public&nbsp;CellStyleTemplate(<a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">CellStyleTemplate</a>&nbsp;other)</pre>
+<div class="block">Create a new Cell Style Template</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>other</code> - CellStyleTemplate to copy</dd></dl>
+</li>
+</ul>
+</li>
+</ul>
+<!-- ============ METHOD DETAIL ========== -->
+<ul class="blockList">
+<li class="blockList"><a name="method_detail">
+<!--   -->
+</a>
+<h3>Method Detail</h3>
+<a name="drawBorders(org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.usermodel.BorderStyle, org.apache.poi.ss.util.BorderExtent)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>drawBorders</h4>
+<pre>public&nbsp;void&nbsp;drawBorders(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+               <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;borderStyle,
+               <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</pre>
+<div class="block">Draws a group of cell borders for a cell range. The borders are not
+ applied to the cells at this time, just the template is drawn. To apply
+ the drawn borders to a sheet, use <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#applyBorders(org.apache.poi.ss.usermodel.Sheet)"><code>applyBorders(org.apache.poi.ss.usermodel.Sheet)</code></a>.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>range</code> - - <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> range of cells on which borders are
+            drawn.</dd><dd><code>borderStyle</code> - - Type of border to draw. <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel"><code>BorderStyle</code></a>.</dd><dd><code>extent</code> - - <code>CellStyleTemplate.BorderExtent</code> of the borders to be
+            applied.</dd></dl>
+</li>
+</ul>
+<a name="drawBorders(org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.usermodel.BorderStyle, short, org.apache.poi.ss.util.BorderExtent)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>drawBorders</h4>
+<pre>public&nbsp;void&nbsp;drawBorders(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+               <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;borderStyle,
+               short&nbsp;color,
+               <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</pre>
+<div class="block">Draws a group of cell borders for a cell range. The borders are not
+ applied to the cells at this time, just the template is drawn. To apply
+ the drawn borders to a sheet, use <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#applyBorders(org.apache.poi.ss.usermodel.Sheet)"><code>applyBorders(org.apache.poi.ss.usermodel.Sheet)</code></a>.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>range</code> - - <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> range of cells on which borders are
+            drawn.</dd><dd><code>borderStyle</code> - - Type of border to draw. <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel"><code>BorderStyle</code></a>.</dd><dd><code>color</code> - - Color index from <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a> used to draw the
+            borders. Ignored if extent is <code>BorderExtent.NONE</code>.</dd><dd><code>extent</code> - - <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util"><code>BorderExtent</code></a> of the borders to be applied.</dd></dl>
+</li>
+</ul>
+<a name="applyBorders(org.apache.poi.ss.usermodel.Sheet)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>applyBorders</h4>
+<pre>public&nbsp;void&nbsp;applyBorders(<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sheet)</pre>
+<div class="block">Applies the drawn borders to a Sheet. The borders that are applied are
+ the ones that have been drawn by the <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.util.BorderExtent)"><code>drawBorders(org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.usermodel.BorderStyle, org.apache.poi.ss.util.BorderExtent)</code></a> and
+ <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorderColors(org.apache.poi.ss.util.CellRangeAddress,%20short,%20org.apache.poi.ss.util.BorderExtent)"><code>drawBorderColors(org.apache.poi.ss.util.CellRangeAddress, short, org.apache.poi.ss.util.BorderExtent)</code></a> methods.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>sheet</code> - - <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel"><code>Sheet</code></a> on which to apply borders</dd></dl>
+</li>
+</ul>
+<a name="drawBorderColors(org.apache.poi.ss.util.CellRangeAddress, short, org.apache.poi.ss.util.BorderExtent)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>drawBorderColors</h4>
+<pre>public&nbsp;void&nbsp;drawBorderColors(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+                    short&nbsp;color,
+                    <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</pre>
+<div class="block">Sets the color for a group of cell borders for a cell range. The borders
+ are not applied to the cells at this time, just the template is drawn. If
+ the borders do not exist, a BORDER_THIN border is used. To apply the
+ drawn borders to a sheet, use <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#applyBorders(org.apache.poi.ss.usermodel.Sheet)"><code>applyBorders(org.apache.poi.ss.usermodel.Sheet)</code></a>.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>range</code> - - <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> range of cells on which colors are
+            set.</dd><dd><code>color</code> - - Color index from <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a> used to draw the
+            borders.</dd><dd><code>extent</code> - - <code>CellStyleTemplate.BorderExtent</code> of the borders for which
+            colors are set.</dd></dl>
+</li>
+</ul>
+<a name="getNumBorders(org.apache.poi.ss.util.CellAddress)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getNumBorders</h4>
+<pre>public&nbsp;int&nbsp;getNumBorders(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell)</pre>
+<div class="block">Retrieves the number of borders assigned to a cell</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>cell</code> - </dd></dl>
+</li>
+</ul>
+<a name="getNumBorders(int, int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getNumBorders</h4>
+<pre>public&nbsp;int&nbsp;getNumBorders(int&nbsp;row,
+                int&nbsp;col)</pre>
+<div class="block">Retrieves the number of borders assigned to a cell</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - </dd><dd><code>col</code> - </dd></dl>
+</li>
+</ul>
+<a name="getNumBorderColors(org.apache.poi.ss.util.CellAddress)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getNumBorderColors</h4>
+<pre>public&nbsp;int&nbsp;getNumBorderColors(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell)</pre>
+<div class="block">Retrieves the number of border colors assigned to a cell</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>cell</code> - </dd></dl>
+</li>
+</ul>
+<a name="getNumBorderColors(int, int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getNumBorderColors</h4>
+<pre>public&nbsp;int&nbsp;getNumBorderColors(int&nbsp;row,
+                     int&nbsp;col)</pre>
+<div class="block">Retrieves the number of border colors assigned to a cell</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - </dd><dd><code>col</code> - </dd></dl>
+</li>
+</ul>
+<a name="getTemplateProperty(org.apache.poi.ss.util.CellAddress, java.lang.String)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getTemplateProperty</h4>
+<pre>public&nbsp;short&nbsp;getTemplateProperty(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell,
+                        java.lang.String&nbsp;property)</pre>
+<div class="block">Retrieves the border style for a given cell</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>cell</code> - </dd><dd><code>property</code> - </dd></dl>
+</li>
+</ul>
+<a name="getTemplateProperty(int, int, java.lang.String)">
+<!--   -->
+</a>
+<ul class="blockListLast">
+<li class="blockList">
+<h4>getTemplateProperty</h4>
+<pre>public&nbsp;short&nbsp;getTemplateProperty(int&nbsp;row,
+                        int&nbsp;col,
+                        java.lang.String&nbsp;property)</pre>
+<div class="block">Retrieves the border style for a given cell</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - </dd><dd><code>col</code> - </dd><dd><code>property</code> - </dd></dl>
+</li>
+</ul>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+</div>
+<!-- ========= END OF CLASS DATA ========= -->
+<!-- ======= START OF BOTTOM NAVBAR ====== -->
+<div class="bottomNav"><a name="navbar_bottom">
+<!--   -->
+</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../overview-summary.html">Overview</a></li>
+<li><a href="package-summary.html">Package</a></li>
+<li class="navBarCell1Rev">Class</li>
+<li><a href="class-use/CellStyleTemplate.html">Use</a></li>
+<li><a href="package-tree.html">Tree</a></li>
+<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li><a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/util/CellUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../index.html?org/apache/poi/ss/util/CellStyleTemplate.html" target="_top">Frames</a></li>
+<li><a href="CellStyleTemplate.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_bottom">
+<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_bottom");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<div>
+<ul class="subNavList">
+<li>Summary:&nbsp;</li>
+<li>Nested&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li><a href="#constructor_summary">Constr</a>&nbsp;|&nbsp;</li>
+<li><a href="#method_summary">Method</a></li>
+</ul>
+<ul class="subNavList">
+<li>Detail:&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li><a href="#constructor_detail">Constr</a>&nbsp;|&nbsp;</li>
+<li><a href="#method_detail">Method</a></li>
+</ul>
+</div>
+<a name="skip-navbar_bottom">
+<!--   -->
+</a></div>
+<!-- ======== END OF BOTTOM NAVBAR ======= -->
+<p class="legalCopy"><small>
+                <i>Copyright 2016 The Apache Software Foundation or
+        its licensors, as applicable.</i>
+            </small></p>
+</body>
+</html>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/CellUtil.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/CellUtil.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/CellUtil.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/CellUtil.html Mon Aug  1 00:06:39 2016
@@ -34,7 +34,7 @@
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
 <li><a href="../../../../../org/apache/poi/ss/util/DateFormatConverter.html" title="class in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
@@ -823,7 +823,7 @@ public static&nbsp;void&nbsp;setCellStyl
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util"><span class="strong">Prev Class</span></a></li>
 <li><a href="../../../../../org/apache/poi/ss/util/DateFormatConverter.html" title="class in org.apache.poi.ss.util"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">

Added: poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/BorderExtent.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/BorderExtent.html?rev=1754692&view=auto
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/BorderExtent.html (added)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/BorderExtent.html Mon Aug  1 00:06:39 2016
@@ -0,0 +1,200 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<!-- NewPage -->
+<html lang="en">
+<head>
+<title>Uses of Class org.apache.poi.ss.util.BorderExtent (POI API Documentation)</title>
+<link rel="stylesheet" type="text/css" href="../../../../../../stylesheet.css" title="Style">
+</head>
+<body>
+<script type="text/javascript"><!--
+    if (location.href.indexOf('is-external=true') == -1) {
+        parent.document.title="Uses of Class org.apache.poi.ss.util.BorderExtent (POI API Documentation)";
+    }
+//-->
+</script>
+<noscript>
+<div>JavaScript is disabled on your browser.</div>
+</noscript>
+<!-- ========= START OF TOP NAVBAR ======= -->
+<div class="topNav"><a name="navbar_top">
+<!--   -->
+</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../../overview-summary.html">Overview</a></li>
+<li><a href="../package-summary.html">Package</a></li>
+<li><a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">Class</a></li>
+<li class="navBarCell1Rev">Use</li>
+<li><a href="../package-tree.html">Tree</a></li>
+<li><a href="../../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li>Prev</li>
+<li>Next</li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../../index.html?org/apache/poi/ss/util/class-use/BorderExtent.html" target="_top">Frames</a></li>
+<li><a href="BorderExtent.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_top">
+<li><a href="../../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_top");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<a name="skip-navbar_top">
+<!--   -->
+</a></div>
+<!-- ========= END OF TOP NAVBAR ========= -->
+<div class="header">
+<h2 title="Uses of Class org.apache.poi.ss.util.BorderExtent" class="title">Uses of Class<br>org.apache.poi.ss.util.BorderExtent</h2>
+</div>
+<div class="classUseContainer">
+<ul class="blockList">
+<li class="blockList">
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing packages, and an explanation">
+<caption><span>Packages that use <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Package</th>
+<th class="colLast" scope="col">Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><a href="#org.apache.poi.ss.util">org.apache.poi.ss.util</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
+</tbody>
+</table>
+</li>
+<li class="blockList">
+<ul class="blockList">
+<li class="blockList"><a name="org.apache.poi.ss.util">
+<!--   -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> in <a href="../../../../../../org/apache/poi/ss/util/package-summary.html">org.apache.poi.ss.util</a></h3>
+<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/util/package-summary.html">org.apache.poi.ss.util</a> that return <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a></code></td>
+<td class="colLast"><span class="strong">BorderExtent.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html#valueOf(java.lang.String)">valueOf</a></strong>(java.lang.String&nbsp;name)</code>
+<div class="block">Returns the enum constant of this type with the specified name.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>[]</code></td>
+<td class="colLast"><span class="strong">BorderExtent.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html#values()">values</a></strong>()</code>
+<div class="block">Returns an array containing the constants of this enum type, in
+the order they are declared.</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/util/package-summary.html">org.apache.poi.ss.util</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorderColors(org.apache.poi.ss.util.CellRangeAddress,%20short,%20org.apache.poi.ss.util.BorderExtent)">drawBorderColors</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+                short&nbsp;color,
+                <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Sets the color for a group of cell borders for a cell range.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.util.BorderExtent)">drawBorders</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+           <a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;borderStyle,
+           <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Draws a group of cell borders for a cell range.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20short,%20org.apache.poi.ss.util.BorderExtent)">drawBorders</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+           <a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;borderStyle,
+           short&nbsp;color,
+           <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Draws a group of cell borders for a cell range.</div>
+</td>
+</tr>
+</tbody>
+</table>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<!-- ======= START OF BOTTOM NAVBAR ====== -->
+<div class="bottomNav"><a name="navbar_bottom">
+<!--   -->
+</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../../overview-summary.html">Overview</a></li>
+<li><a href="../package-summary.html">Package</a></li>
+<li><a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">Class</a></li>
+<li class="navBarCell1Rev">Use</li>
+<li><a href="../package-tree.html">Tree</a></li>
+<li><a href="../../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li>Prev</li>
+<li>Next</li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../../index.html?org/apache/poi/ss/util/class-use/BorderExtent.html" target="_top">Frames</a></li>
+<li><a href="BorderExtent.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_bottom">
+<li><a href="../../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_bottom");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<a name="skip-navbar_bottom">
+<!--   -->
+</a></div>
+<!-- ======== END OF BOTTOM NAVBAR ======= -->
+<p class="legalCopy"><small>
+                <i>Copyright 2016 The Apache Software Foundation or
+        its licensors, as applicable.</i>
+            </small></p>
+</body>
+</html>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellAddress.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellAddress.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellAddress.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellAddress.html Mon Aug  1 00:06:39 2016
@@ -292,6 +292,38 @@
 <div class="block">Compare this CellAddress using the "natural" row-major, column-minor ordering.</div>
 </td>
 </tr>
+<tr class="rowColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getNumBorderColors(org.apache.poi.ss.util.CellAddress)">getNumBorderColors</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell)</code>
+<div class="block">Retrieves the number of border colors assigned to a cell</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getNumBorders(org.apache.poi.ss.util.CellAddress)">getNumBorders</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell)</code>
+<div class="block">Retrieves the number of borders assigned to a cell</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>short</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#getTemplateProperty(org.apache.poi.ss.util.CellAddress,%20java.lang.String)">getTemplateProperty</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;cell,
+                   java.lang.String&nbsp;property)</code>
+<div class="block">Retrieves the border style for a given cell</div>
+</td>
+</tr>
+</tbody>
+</table>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing constructors, and an explanation">
+<caption><span>Constructors in <a href="../../../../../../org/apache/poi/ss/util/package-summary.html">org.apache.poi.ss.util</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Constructor and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellAddress.html#CellAddress(org.apache.poi.ss.util.CellAddress)">CellAddress</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a>&nbsp;address)</code>
+<div class="block">Create a new CellAddress object.</div>
+</td>
+</tr>
 </tbody>
 </table>
 </li>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellRangeAddress.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellRangeAddress.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellRangeAddress.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellRangeAddress.html Mon Aug  1 00:06:39 2016
@@ -884,20 +884,45 @@ HSSF concepts.</div>
 </td>
 </tr>
 <tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorderColors(org.apache.poi.ss.util.CellRangeAddress,%20short,%20org.apache.poi.ss.util.BorderExtent)">drawBorderColors</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+                short&nbsp;color,
+                <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Sets the color for a group of cell borders for a cell range.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.util.BorderExtent)">drawBorders</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+           <a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;borderStyle,
+           <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Draws a group of cell borders for a cell range.</div>
+</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>void</code></td>
+<td class="colLast"><span class="strong">CellStyleTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20short,%20org.apache.poi.ss.util.BorderExtent)">drawBorders</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range,
+           <a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;borderStyle,
+           short&nbsp;color,
+           <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a>&nbsp;extent)</code>
+<div class="block">Draws a group of cell borders for a cell range.</div>
+</td>
+</tr>
+<tr class="rowColor">
 <td class="colFirst"><code>static boolean</code></td>
 <td class="colLast"><span class="strong">CellRangeUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellRangeUtil.html#hasExactSharedBorder(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">hasExactSharedBorder</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;crA,
                     <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;crB)</code>
 <div class="block">Check if the two cell ranges have a shared border.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static int</code></td>
 <td class="colLast"><span class="strong">CellRangeUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellRangeUtil.html#intersect(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.util.CellRangeAddress)">intersect</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;crA,
          <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;crB)</code>
 <div class="block">Get the type of intersection between two cell ranges</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>[]</code></td>
 <td class="colLast"><span class="strong">CellRangeUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellRangeUtil.html#mergeCellRanges(org.apache.poi.ss.util.CellRangeAddress[])">mergeCellRanges</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>[]&nbsp;cellRanges)</code>
 <div class="block">Do all possible cell merges between cells of the list so that:<br/>
@@ -907,7 +932,7 @@ HSSF concepts.</div>
  </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBorderBottom(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBorderBottom</a></strong>(int&nbsp;border,
                <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -916,7 +941,7 @@ HSSF concepts.</div>
  cells on the bottom</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBorderBottom(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.Workbook)">setBorderBottom</a></strong>(int&nbsp;border,
                <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -927,7 +952,7 @@ HSSF concepts.</div>
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBorderLeft(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBorderLeft</a></strong>(int&nbsp;border,
              <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -936,7 +961,7 @@ HSSF concepts.</div>
  cells on the left</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBorderLeft(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.Workbook)">setBorderLeft</a></strong>(int&nbsp;border,
              <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -947,7 +972,7 @@ HSSF concepts.</div>
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBorderRight(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBorderRight</a></strong>(int&nbsp;border,
               <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -956,7 +981,7 @@ HSSF concepts.</div>
  cells on the right</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBorderRight(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.Workbook)">setBorderRight</a></strong>(int&nbsp;border,
               <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -967,7 +992,7 @@ HSSF concepts.</div>
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBorderTop(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBorderTop</a></strong>(int&nbsp;border,
             <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -976,7 +1001,7 @@ HSSF concepts.</div>
  cells on the top</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBorderTop(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.Workbook)">setBorderTop</a></strong>(int&nbsp;border,
             <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -987,7 +1012,7 @@ HSSF concepts.</div>
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBottomBorderColor(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBottomBorderColor</a></strong>(int&nbsp;color,
                     <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -996,7 +1021,7 @@ HSSF concepts.</div>
  cells on the bottom</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setBottomBorderColor(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.Workbook)">setBottomBorderColor</a></strong>(int&nbsp;color,
                     <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -1007,7 +1032,7 @@ HSSF concepts.</div>
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setLeftBorderColor(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setLeftBorderColor</a></strong>(int&nbsp;color,
                   <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -1016,7 +1041,7 @@ HSSF concepts.</div>
  cells on the left</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setLeftBorderColor(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.Workbook)">setLeftBorderColor</a></strong>(int&nbsp;color,
                   <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -1027,7 +1052,7 @@ HSSF concepts.</div>
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setRightBorderColor(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setRightBorderColor</a></strong>(int&nbsp;color,
                    <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -1036,7 +1061,7 @@ HSSF concepts.</div>
  cells on the right</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setRightBorderColor(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.Workbook)">setRightBorderColor</a></strong>(int&nbsp;color,
                    <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -1047,7 +1072,7 @@ HSSF concepts.</div>
 </div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setTopBorderColor(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setTopBorderColor</a></strong>(int&nbsp;color,
                  <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,
@@ -1056,7 +1081,7 @@ HSSF concepts.</div>
  cells on the top</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static void</code></td>
 <td class="colLast"><span class="strong">RegionUtil.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/RegionUtil.html#setTopBorderColor(int,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet,%20org.apache.poi.ss.usermodel.Workbook)">setTopBorderColor</a></strong>(int&nbsp;color,
                  <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region,

Added: poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellStyleTemplate.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellStyleTemplate.html?rev=1754692&view=auto
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellStyleTemplate.html (added)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellStyleTemplate.html Mon Aug  1 00:06:39 2016
@@ -0,0 +1,157 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<!-- NewPage -->
+<html lang="en">
+<head>
+<title>Uses of Class org.apache.poi.ss.util.CellStyleTemplate (POI API Documentation)</title>
+<link rel="stylesheet" type="text/css" href="../../../../../../stylesheet.css" title="Style">
+</head>
+<body>
+<script type="text/javascript"><!--
+    if (location.href.indexOf('is-external=true') == -1) {
+        parent.document.title="Uses of Class org.apache.poi.ss.util.CellStyleTemplate (POI API Documentation)";
+    }
+//-->
+</script>
+<noscript>
+<div>JavaScript is disabled on your browser.</div>
+</noscript>
+<!-- ========= START OF TOP NAVBAR ======= -->
+<div class="topNav"><a name="navbar_top">
+<!--   -->
+</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../../overview-summary.html">Overview</a></li>
+<li><a href="../package-summary.html">Package</a></li>
+<li><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">Class</a></li>
+<li class="navBarCell1Rev">Use</li>
+<li><a href="../package-tree.html">Tree</a></li>
+<li><a href="../../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li>Prev</li>
+<li>Next</li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../../index.html?org/apache/poi/ss/util/class-use/CellStyleTemplate.html" target="_top">Frames</a></li>
+<li><a href="CellStyleTemplate.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_top">
+<li><a href="../../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_top");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<a name="skip-navbar_top">
+<!--   -->
+</a></div>
+<!-- ========= END OF TOP NAVBAR ========= -->
+<div class="header">
+<h2 title="Uses of Class org.apache.poi.ss.util.CellStyleTemplate" class="title">Uses of Class<br>org.apache.poi.ss.util.CellStyleTemplate</h2>
+</div>
+<div class="classUseContainer">
+<ul class="blockList">
+<li class="blockList">
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing packages, and an explanation">
+<caption><span>Packages that use <a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">CellStyleTemplate</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Package</th>
+<th class="colLast" scope="col">Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><a href="#org.apache.poi.ss.util">org.apache.poi.ss.util</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
+</tbody>
+</table>
+</li>
+<li class="blockList">
+<ul class="blockList">
+<li class="blockList"><a name="org.apache.poi.ss.util">
+<!--   -->
+</a>
+<h3>Uses of <a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">CellStyleTemplate</a> in <a href="../../../../../../org/apache/poi/ss/util/package-summary.html">org.apache.poi.ss.util</a></h3>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing constructors, and an explanation">
+<caption><span>Constructors in <a href="../../../../../../org/apache/poi/ss/util/package-summary.html">org.apache.poi.ss.util</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">CellStyleTemplate</a></span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Constructor and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html#CellStyleTemplate(org.apache.poi.ss.util.CellStyleTemplate)">CellStyleTemplate</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">CellStyleTemplate</a>&nbsp;other)</code>
+<div class="block">Create a new Cell Style Template</div>
+</td>
+</tr>
+</tbody>
+</table>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<!-- ======= START OF BOTTOM NAVBAR ====== -->
+<div class="bottomNav"><a name="navbar_bottom">
+<!--   -->
+</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../../overview-summary.html">Overview</a></li>
+<li><a href="../package-summary.html">Package</a></li>
+<li><a href="../../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">Class</a></li>
+<li class="navBarCell1Rev">Use</li>
+<li><a href="../package-tree.html">Tree</a></li>
+<li><a href="../../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li>Prev</li>
+<li>Next</li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../../index.html?org/apache/poi/ss/util/class-use/CellStyleTemplate.html" target="_top">Frames</a></li>
+<li><a href="CellStyleTemplate.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_bottom">
+<li><a href="../../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_bottom");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<a name="skip-navbar_bottom">
+<!--   -->
+</a></div>
+<!-- ======== END OF BOTTOM NAVBAR ======= -->
+<p class="legalCopy"><small>
+                <i>Copyright 2016 The Apache Software Foundation or
+        its licensors, as applicable.</i>
+            </small></p>
+</body>
+</html>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/package-frame.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/package-frame.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/package-frame.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/package-frame.html Mon Aug  1 00:06:39 2016
@@ -17,6 +17,7 @@
 <li><a href="CellRangeAddressList.html" title="class in org.apache.poi.ss.util" target="classFrame">CellRangeAddressList</a></li>
 <li><a href="CellRangeUtil.html" title="class in org.apache.poi.ss.util" target="classFrame">CellRangeUtil</a></li>
 <li><a href="CellReference.html" title="class in org.apache.poi.ss.util" target="classFrame">CellReference</a></li>
+<li><a href="CellStyleTemplate.html" title="class in org.apache.poi.ss.util" target="classFrame">CellStyleTemplate</a></li>
 <li><a href="CellUtil.html" title="class in org.apache.poi.ss.util" target="classFrame">CellUtil</a></li>
 <li><a href="DateFormatConverter.html" title="class in org.apache.poi.ss.util" target="classFrame">DateFormatConverter</a></li>
 <li><a href="DateFormatConverter.DateFormatTokenizer.html" title="class in org.apache.poi.ss.util" target="classFrame">DateFormatConverter.DateFormatTokenizer</a></li>
@@ -33,6 +34,7 @@
 </ul>
 <h2 title="Enums">Enums</h2>
 <ul title="Enums">
+<li><a href="BorderExtent.html" title="enum in org.apache.poi.ss.util" target="classFrame">BorderExtent</a></li>
 <li><a href="CellReference.NameType.html" title="enum in org.apache.poi.ss.util" target="classFrame">CellReference.NameType</a></li>
 </ul>
 </div>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/package-summary.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/package-summary.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/package-summary.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/package-summary.html Mon Aug  1 00:06:39 2016
@@ -125,78 +125,86 @@
 </td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">CellStyleTemplate</a></td>
+<td class="colLast">
+<div class="block">
+ A <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util"><code>CellStyleTemplate</code></a> is a template that can be applied to any sheet in
+ a project.</div>
+</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/CellUtil.html" title="class in org.apache.poi.ss.util">CellUtil</a></td>
 <td class="colLast">
 <div class="block">Various utility functions that make working with a cells and rows easier.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/DateFormatConverter.html" title="class in org.apache.poi.ss.util">DateFormatConverter</a></td>
 <td class="colLast">
 <div class="block">Convert java DateFormat patterns into Excel custom number formats.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/DateFormatConverter.DateFormatTokenizer.html" title="class in org.apache.poi.ss.util">DateFormatConverter.DateFormatTokenizer</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/ImageUtils.html" title="class in org.apache.poi.ss.util">ImageUtils</a></td>
 <td class="colLast">&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/NumberComparer.html" title="class in org.apache.poi.ss.util">NumberComparer</a></td>
 <td class="colLast">
 <div class="block">Excel compares numbers using different rules to those of java, so
   <code>Double.compare(double, double)</code> won't do.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/NumberToTextConverter.html" title="class in org.apache.poi.ss.util">NumberToTextConverter</a></td>
 <td class="colLast">
 <div class="block">Excel converts numbers to text with different rules to those of java, so
   <code>Double.toString(value)</tt> won't do.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/PaneInformation.html" title="class in org.apache.poi.ss.util">PaneInformation</a></td>
 <td class="colLast">
 <div class="block">Holds information regarding a split plane or freeze plane for a sheet.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/RegionUtil.html" title="class in org.apache.poi.ss.util">RegionUtil</a></td>
 <td class="colLast">
 <div class="block">Various utility functions that make working with a region of cells easier.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/SheetBuilder.html" title="class in org.apache.poi.ss.util">SheetBuilder</a></td>
 <td class="colLast">
 <div class="block">Class <code>SheetBuilder</code> provides an easy way of building workbook sheets
  from 2D array of Objects.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/SheetReferences.html" title="class in org.apache.poi.ss.util">SheetReferences</a></td>
 <td class="colLast">
 <div class="block">Holds a collection of Sheet names and their associated
  reference numbers.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/SheetUtil.html" title="class in org.apache.poi.ss.util">SheetUtil</a></td>
 <td class="colLast">
 <div class="block">Helper methods for when working with Usermodel sheets</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/SSCellRange.html" title="class in org.apache.poi.ss.util">SSCellRange</a>&lt;K extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>&gt;</td>
 <td class="colLast">
 <div class="block">For POI internal use only</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/WorkbookUtil.html" title="class in org.apache.poi.ss.util">WorkbookUtil</a></td>
 <td class="colLast">
 <div class="block">Helper methods for when working with Usermodel Workbooks</div>
@@ -214,6 +222,10 @@
 </tr>
 <tbody>
 <tr class="altColor">
+<td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a></td>
+<td class="colLast">&nbsp;</td>
+</tr>
+<tr class="rowColor">
 <td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util">CellReference.NameType</a></td>
 <td class="colLast">
 <div class="block">Used to classify identifiers found in formulas as cell references or not.</div>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/package-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/package-tree.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/package-tree.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/package-tree.html Mon Aug  1 00:06:39 2016
@@ -82,6 +82,7 @@
 <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellRangeAddressList.html" title="class in org.apache.poi.ss.util"><span class="strong">CellRangeAddressList</span></a></li>
 <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellRangeUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">CellRangeUtil</span></a></li>
 <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util"><span class="strong">CellReference</span></a></li>
+<li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util"><span class="strong">CellStyleTemplate</span></a></li>
 <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">CellUtil</span></a></li>
 <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/DateFormatConverter.html" title="class in org.apache.poi.ss.util"><span class="strong">DateFormatConverter</span></a></li>
 <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/DateFormatConverter.DateFormatTokenizer.html" title="class in org.apache.poi.ss.util"><span class="strong">DateFormatConverter.DateFormatTokenizer</span></a></li>
@@ -104,6 +105,7 @@
 <ul>
 <li type="circle">java.lang.Enum&lt;E&gt; (implements java.lang.Comparable&lt;T&gt;, java.io.Serializable)
 <ul>
+<li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util"><span class="strong">BorderExtent</span></a></li>
 <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util"><span class="strong">CellReference.NameType</span></a></li>
 </ul>
 </li>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/package-use.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/package-use.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/util/package-use.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/util/package-use.html Mon Aug  1 00:06:39 2016
@@ -499,23 +499,26 @@ HSSF concepts.</div>
 </tr>
 <tbody>
 <tr class="altColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/BorderExtent.html#org.apache.poi.ss.util">BorderExtent</a>&nbsp;</td>
+</tr>
+<tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/CellAddress.html#org.apache.poi.ss.util">CellAddress</a>
 <div class="block">This class is a container for POI usermodel row=0 column=0 cell references.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/CellRangeAddress.html#org.apache.poi.ss.util">CellRangeAddress</a>
 <div class="block">See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'<p/></div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/CellRangeAddressBase.html#org.apache.poi.ss.util">CellRangeAddressBase</a>
 <div class="block">See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'<p/>
 
  Common superclass of 8-bit and 16-bit versions</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/CellRangeAddressList.html#org.apache.poi.ss.util">CellRangeAddressList</a>
 <div class="block">Implementation of the cell range address lists,like is described
  in OpenOffice.org's Excel Documentation: excelfileformat.pdf sec 2.5.14 -
@@ -525,18 +528,25 @@ HSSF concepts.</div>
  several records (not formulas).</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/CellReference.html#org.apache.poi.ss.util">CellReference</a>
 <div class="block">Common conversion functions between Excel style A1, C27 style
   cell references, and POI usermodel style row=0, column=0
   style references.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/CellReference.NameType.html#org.apache.poi.ss.util">CellReference.NameType</a>
 <div class="block">Used to classify identifiers found in formulas as cell references or not.</div>
 </td>
 </tr>
+<tr class="rowColor">
+<td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/CellStyleTemplate.html#org.apache.poi.ss.util">CellStyleTemplate</a>
+<div class="block">
+ A <a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util"><code>CellStyleTemplate</code></a> is a template that can be applied to any sheet in
+ a project.</div>
+</td>
+</tr>
 <tr class="altColor">
 <td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/SheetBuilder.html#org.apache.poi.ss.util">SheetBuilder</a>
 <div class="block">Class <code>SheetBuilder</code> provides an easy way of building workbook sheets

Modified: poi/site/publish/apidocs/overview-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/overview-tree.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/apidocs/overview-tree.html (original)
+++ poi/site/publish/apidocs/overview-tree.html Mon Aug  1 00:06:39 2016
@@ -384,6 +384,7 @@
 <li type="circle">org.apache.poi.hssf.util.<a href="org/apache/poi/hssf/util/CellReference.html" title="class in org.apache.poi.hssf.util"><span class="strong">CellReference</span></a></li>
 </ul>
 </li>
+<li type="circle">org.apache.poi.ss.util.<a href="org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util"><span class="strong">CellStyleTemplate</span></a></li>
 <li type="circle">org.apache.poi.ss.util.<a href="org/apache/poi/ss/util/CellUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">CellUtil</span></a></li>
 <li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/CellValue.html" title="class in org.apache.poi.ss.usermodel"><span class="strong">CellValue</span></a></li>
 <li type="circle">org.apache.poi.ss.util.cellwalk.<a href="org/apache/poi/ss/util/cellwalk/CellWalk.html" title="class in org.apache.poi.ss.util.cellwalk"><span class="strong">CellWalk</span></a></li>
@@ -3470,6 +3471,7 @@
 <li type="circle">org.apache.poi.ss.usermodel.charts.<a href="org/apache/poi/ss/usermodel/charts/AxisTickMark.html" title="enum in org.apache.poi.ss.usermodel.charts"><span class="strong">AxisTickMark</span></a></li>
 <li type="circle">org.apache.poi.xwpf.usermodel.<a href="org/apache/poi/xwpf/usermodel/BodyElementType.html" title="enum in org.apache.poi.xwpf.usermodel"><span class="strong">BodyElementType</span></a></li>
 <li type="circle">org.apache.poi.xwpf.usermodel.<a href="org/apache/poi/xwpf/usermodel/BodyType.html" title="enum in org.apache.poi.xwpf.usermodel"><span class="strong">BodyType</span></a></li>
+<li type="circle">org.apache.poi.ss.util.<a href="org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util"><span class="strong">BorderExtent</span></a></li>
 <li type="circle">org.apache.poi.xwpf.usermodel.<a href="org/apache/poi/xwpf/usermodel/Borders.html" title="enum in org.apache.poi.xwpf.usermodel"><span class="strong">Borders</span></a></li>
 <li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel"><span class="strong">BorderStyle</span></a></li>
 <li type="circle">org.apache.poi.xwpf.usermodel.<a href="org/apache/poi/xwpf/usermodel/BreakClear.html" title="enum in org.apache.poi.xwpf.usermodel"><span class="strong">BreakClear</span></a></li>

Modified: poi/site/publish/spreadsheet/quick-guide.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/quick-guide.html?rev=1754692&r1=1754691&r2=1754692&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/quick-guide.html (original)
+++ poi/site/publish/spreadsheet/quick-guide.html Mon Aug  1 00:06:39 2016
@@ -375,6 +375,10 @@ if (VERSION > 3) {
 </li>
                     
 <li>
+<a href="#DrawingBorders">Drawing Borders</a>
+</li>
+                    
+<li>
 <a href="#RichText">Cells with multiple styles</a>
 </li>
                 
@@ -1749,7 +1753,7 @@ Examples:
                 
                 
 <a name="Outlining"></a>
-                <a name="Outlining-N103EC"></a>
+                <a name="Outlining-N103F1"></a>
 <div class="h2">
 <h2>Outlining</h2>
 </div>
@@ -1796,7 +1800,7 @@ Examples:
         
         
 <a name="Images"></a>
-        <a name="Images-N10409"></a>
+        <a name="Images-N1040E"></a>
 <div class="h3">
 <h3>Images</h3>
 </div>
@@ -3047,6 +3051,74 @@ the data to populate another drop down l
   pivotTable.addReportFilter(3);
         </pre>
       
+  
+<a name="DrawingBorders"></a>
+    <a name="Drawing+Borders"></a>
+<div class="h3">
+<h3>Drawing Borders</h3>
+</div>
+      
+      
+<p>
+      In Excel, you can apply a set of borders on an entire workbook region at the press of a button. The PropertyTemplate
+      object simulates this with methods and constants defined to allow drawing top, bottom, left, right, horizontal,
+      vertical, inside, outside, or all borders around a range of cells. Additional methods allow for applying colors
+      to the borders. 
+      </p>
+      
+<p>
+      It works like this: you create a PropertyTemplate object which is a container for the borders you wish to apply to a
+      sheet. Then you add borders and colors to the PropertyTemplate, and finally apply it to whichever sheets you need
+      that set of borders on. You can create multiple PropertyTemplate objects and apply them to a single sheet, or you can 
+      apply the same PropertyTemplate object to multiple sheets. It is just like a preprinted form.
+      </p>
+      
+<pre class="code">
+  // draw borders (three 3x3 grids)
+  PropertyTemplate pt = new PropertyTemplate();
+  // #1) these borders will all be medium in default color
+  pt.drawBorders(new CellRangeAddress(1, 3, 1, 3),
+          CellStyle.BORDER_MEDIUM, PropertyTemplate.Extent.ALL);
+  // #2) these cells will have medium outside borders and thin inside borders
+  pt.drawBorders(new CellRangeAddress(5, 7, 1, 3),
+          CellStyle.BORDER_MEDIUM, PropertyTemplate.Extent.OUTSIDE);
+  pt.drawBorders(new CellRangeAddress(5, 7, 1, 3), CellStyle.BORDER_THIN,
+          PropertyTemplate.Extent.INSIDE);
+  // #3) these cells will all be medium weight with different colors for the
+  //     outside, inside horizontal, and inside vertical borders. The center
+  //     cell will have no borders.
+  pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),
+          CellStyle.BORDER_MEDIUM, IndexedColors.RED.getIndex(),
+          PropertyTemplate.Extent.OUTSIDE);
+  pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),
+          CellStyle.BORDER_MEDIUM, IndexedColors.BLUE.getIndex(),
+          PropertyTemplate.Extent.INSIDE_VERTICAL);
+  pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),
+          CellStyle.BORDER_MEDIUM, IndexedColors.GREEN.getIndex(),
+          PropertyTemplate.Extent.INSIDE_HORIZONTAL);
+  pt.drawBorders(new CellRangeAddress(10, 10, 2, 2),
+          CellStyle.BORDER_NONE, 
+          PropertyTemplate.Extent.ALL);
+
+  // apply borders to sheet
+  Workbook wb = new XSSFWorkbook();
+  Sheet sh = wb.createSheet("Sheet1");
+  pt.applyBorders(sh);
+      </pre>
+      
+<p>
+      NOTE: The last pt.drawBorders() call removes the borders from the range by using CellStyle.BORDER_NONE. Like
+      setCellStyleProperties, the applyBorders method merges the properties of a cell style, so existing borders
+      are changed only if they are replaced by something else, or removed only if they are replaced by 
+      CellStyle.BORDER_NONE. To remove a color from a border, use IndexedColor.AUTOMATIC.getIndex().
+      </p>
+      
+<p>Additionally, to remove a border or color from the PropertyTemplate object, use Extent.NONE.</p>
+      
+<p>
+      This does not work with diagonal borders yet.
+      </p>
+    
       
 <a name="RichText"></a>
       <a name="Cells+with+multiple+styles+%28Rich+Text+Strings%29"></a>



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


Mime
View raw message