You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2016/08/01 00:06:39 UTC
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/
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: </li>
+<li>Nested | </li>
+<li>Field | </li>
+<li><a href="#constructor_summary">Constr</a> | </li>
+<li><a href="#method_summary">Method</a></li>
+</ul>
+<ul class="subNavList">
+<li>Detail: </li>
+<li>Field | </li>
+<li><a href="#constructor_detail">Constr</a> | </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"> </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> 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"> </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> 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> range,
+ short color,
+ <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> range,
+ <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> borderStyle,
+ <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> range,
+ <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> borderStyle,
+ short color,
+ <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> 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 row,
+ int 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> 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 row,
+ int 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> cell,
+ java.lang.String 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 row,
+ int col,
+ java.lang.String 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 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 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 CellStyleTemplate(<a href="../../../../../org/apache/poi/ss/util/CellStyleTemplate.html" title="class in org.apache.poi.ss.util">CellStyleTemplate</a> 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 void drawBorders(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range,
+ <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> borderStyle,
+ <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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 void drawBorders(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range,
+ <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> borderStyle,
+ short color,
+ <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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 void applyBorders(<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a> 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 void drawBorderColors(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range,
+ short color,
+ <a href="../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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 int getNumBorders(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a> 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 int getNumBorders(int row,
+ int 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 int getNumBorderColors(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a> 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 int getNumBorderColors(int row,
+ int 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 short getTemplateProperty(<a href="../../../../../org/apache/poi/ss/util/CellAddress.html" title="class in org.apache.poi.ss.util">CellAddress</a> cell,
+ java.lang.String 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 short getTemplateProperty(int row,
+ int col,
+ java.lang.String 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: </li>
+<li>Nested | </li>
+<li>Field | </li>
+<li><a href="#constructor_summary">Constr</a> | </li>
+<li><a href="#method_summary">Method</a></li>
+</ul>
+<ul class="subNavList">
+<li>Detail: </li>
+<li>Field | </li>
+<li><a href="#constructor_detail">Constr</a> | </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 void 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"> </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"> </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"> </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 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"> </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> range,
+ short color,
+ <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> range,
+ <a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> borderStyle,
+ <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> range,
+ <a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> borderStyle,
+ short color,
+ <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> 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> 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> cell,
+ java.lang.String 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"> </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> 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> range,
+ short color,
+ <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> range,
+ <a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> borderStyle,
+ <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> range,
+ <a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> borderStyle,
+ short color,
+ <a href="../../../../../../org/apache/poi/ss/util/BorderExtent.html" title="enum in org.apache.poi.ss.util">BorderExtent</a> 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> crA,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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> crA,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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>[] 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 border,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 border,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 border,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 border,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 border,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 border,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 border,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 border,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 color,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 color,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 color,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 color,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 color,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 color,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 color,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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 color,
<a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> 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"> </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"> </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"> </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> 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"> </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"> </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><K extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>></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"> </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<E> (implements java.lang.Comparable<T>, 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> </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