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=1763400&r1=1763399&r2=1763400&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 Wed Oct 5 10:39:34 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">PropertyTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/PropertyTemplate.html#drawBorderColors(org.apache.poi.ss.util.CellRangeAddress,%20short,%20org.apache.poi.ss.usermodel.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/usermodel/BorderExtent.html" title="enum in org.apache.poi.ss.usermodel">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">PropertyTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/PropertyTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.usermodel.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> borderType, + <a href="../../../../../../org/apache/poi/ss/usermodel/BorderExtent.html" title="enum in org.apache.poi.ss.usermodel">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">PropertyTemplate.</span><code><strong><a href="../../../../../../org/apache/poi/ss/util/PropertyTemplate.html#drawBorders(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.BorderStyle,%20short,%20org.apache.poi.ss.usermodel.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> borderType, + short color, + <a href="../../../../../../org/apache/poi/ss/usermodel/BorderExtent.html" title="enum in org.apache.poi.ss.usermodel">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(org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBorderBottom</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> 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)">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, @@ -926,7 +951,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,%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, @@ -937,7 +962,7 @@ HSSF concepts.</div> </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(org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBorderLeft</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> border, <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> region, @@ -946,7 +971,7 @@ HSSF concepts.</div> cells on the left</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, @@ -956,7 +981,7 @@ HSSF concepts.</div> </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, @@ -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#setBorderRight(org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBorderRight</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> 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 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)">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, @@ -986,7 +1011,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,%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, @@ -997,7 +1022,7 @@ HSSF concepts.</div> </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(org.apache.poi.ss.usermodel.BorderStyle,%20org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.Sheet)">setBorderTop</a></strong>(<a href="../../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a> border, <a href="../../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> region, @@ -1006,7 +1031,7 @@ HSSF concepts.</div> cells on the top</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, @@ -1016,7 +1041,7 @@ HSSF concepts.</div> </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, @@ -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#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, @@ -1036,7 +1061,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, @@ -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#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, @@ -1056,7 +1081,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, @@ -1067,7 +1092,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, @@ -1076,7 +1101,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, @@ -1087,7 +1112,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, @@ -1096,7 +1121,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/PropertyTemplate.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/PropertyTemplate.html?rev=1763400&view=auto ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/PropertyTemplate.html (added) +++ poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/PropertyTemplate.html Wed Oct 5 10:39:34 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.PropertyTemplate (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.PropertyTemplate (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/PropertyTemplate.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/PropertyTemplate.html" target="_top">Frames</a></li> +<li><a href="PropertyTemplate.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.PropertyTemplate" class="title">Uses of Class<br>org.apache.poi.ss.util.PropertyTemplate</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/PropertyTemplate.html" title="class in org.apache.poi.ss.util">PropertyTemplate</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/PropertyTemplate.html" title="class in org.apache.poi.ss.util">PropertyTemplate</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/PropertyTemplate.html" title="class in org.apache.poi.ss.util">PropertyTemplate</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/PropertyTemplate.html#PropertyTemplate(org.apache.poi.ss.util.PropertyTemplate)">PropertyTemplate</a></strong>(<a href="../../../../../../org/apache/poi/ss/util/PropertyTemplate.html" title="class in org.apache.poi.ss.util">PropertyTemplate</a> template)</code> +<div class="block">Create a PropertyTemplate object from another PropertyTemplate</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/PropertyTemplate.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/PropertyTemplate.html" target="_top">Frames</a></li> +<li><a href="PropertyTemplate.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=1763400&r1=1763399&r2=1763400&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 Wed Oct 5 10:39:34 2016 @@ -24,6 +24,7 @@ <li><a href="NumberComparer.html" title="class in org.apache.poi.ss.util" target="classFrame">NumberComparer</a></li> <li><a href="NumberToTextConverter.html" title="class in org.apache.poi.ss.util" target="classFrame">NumberToTextConverter</a></li> <li><a href="PaneInformation.html" title="class in org.apache.poi.ss.util" target="classFrame">PaneInformation</a></li> +<li><a href="PropertyTemplate.html" title="class in org.apache.poi.ss.util" target="classFrame">PropertyTemplate</a></li> <li><a href="RegionUtil.html" title="class in org.apache.poi.ss.util" target="classFrame">RegionUtil</a></li> <li><a href="SheetBuilder.html" title="class in org.apache.poi.ss.util" target="classFrame">SheetBuilder</a></li> <li><a href="SheetReferences.html" title="class in org.apache.poi.ss.util" target="classFrame">SheetReferences</a></li> 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=1763400&r1=1763399&r2=1763400&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 Wed Oct 5 10:39:34 2016 @@ -165,38 +165,46 @@ </td> </tr> <tr class="altColor"> +<td class="colFirst"><a href="../../../../../org/apache/poi/ss/util/PropertyTemplate.html" title="class in org.apache.poi.ss.util">PropertyTemplate</a></td> +<td class="colLast"> +<div class="block"> + A <a href="../../../../../org/apache/poi/ss/util/PropertyTemplate.html" title="class in org.apache.poi.ss.util"><code>PropertyTemplate</code></a> is a template that can be applied to any sheet in + a project.</div> +</td> +</tr> +<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> 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=1763400&r1=1763399&r2=1763400&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 Wed Oct 5 10:39:34 2016 @@ -89,6 +89,7 @@ <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/NumberComparer.html" title="class in org.apache.poi.ss.util"><span class="strong">NumberComparer</span></a></li> <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/NumberToTextConverter.html" title="class in org.apache.poi.ss.util"><span class="strong">NumberToTextConverter</span></a></li> <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/PaneInformation.html" title="class in org.apache.poi.ss.util"><span class="strong">PaneInformation</span></a></li> +<li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/PropertyTemplate.html" title="class in org.apache.poi.ss.util"><span class="strong">PropertyTemplate</span></a></li> <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/RegionUtil.html" title="class in org.apache.poi.ss.util"><span class="strong">RegionUtil</span></a></li> <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/SheetBuilder.html" title="class in org.apache.poi.ss.util"><span class="strong">SheetBuilder</span></a></li> <li type="circle">org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/SheetReferences.html" title="class in org.apache.poi.ss.util"><span class="strong">SheetReferences</span></a></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=1763400&r1=1763399&r2=1763400&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 Wed Oct 5 10:39:34 2016 @@ -538,12 +538,19 @@ HSSF concepts.</div> </td> </tr> <tr class="altColor"> +<td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/PropertyTemplate.html#org.apache.poi.ss.util">PropertyTemplate</a> +<div class="block"> + A <a href="../../../../../org/apache/poi/ss/util/PropertyTemplate.html" title="class in org.apache.poi.ss.util"><code>PropertyTemplate</code></a> is a template that can be applied to any sheet in + a project.</div> +</td> +</tr> +<tr class="rowColor"> <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 from 2D array of Objects.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colOne"><a href="../../../../../org/apache/poi/ss/util/class-use/SSCellRange.html#org.apache.poi.ss.util">SSCellRange</a> <div class="block">For POI internal use only</div> </td> Modified: poi/site/publish/apidocs/overview-tree.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/overview-tree.html?rev=1763400&r1=1763399&r2=1763400&view=diff ============================================================================== --- poi/site/publish/apidocs/overview-tree.html (original) +++ poi/site/publish/apidocs/overview-tree.html Wed Oct 5 10:39:34 2016 @@ -1812,6 +1812,7 @@ <li type="circle">org.apache.poi.poifs.property.<a href="org/apache/poi/poifs/property/PropertyTable.html" title="class in org.apache.poi.poifs.property"><span class="strong">PropertyTable</span></a> (implements org.apache.poi.poifs.storage.<a href="org/apache/poi/poifs/storage/BlockWritable.html" title="interface in org.apache.poi.poifs.storage">BlockWritable</a>)</li> </ul> </li> +<li type="circle">org.apache.poi.ss.util.<a href="org/apache/poi/ss/util/PropertyTemplate.html" title="class in org.apache.poi.ss.util"><span class="strong">PropertyTemplate</span></a></li> <li type="circle">org.apache.poi.hsmf.datatypes.<a href="org/apache/poi/hsmf/datatypes/PropertyValue.html" title="class in org.apache.poi.hsmf.datatypes"><span class="strong">PropertyValue</span></a> <ul> <li type="circle">org.apache.poi.hsmf.datatypes.<a href="org/apache/poi/hsmf/datatypes/ChunkBasedPropertyValue.html" title="class in org.apache.poi.hsmf.datatypes"><span class="strong">ChunkBasedPropertyValue</span></a></li> @@ -3478,6 +3479,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.usermodel.<a href="org/apache/poi/ss/usermodel/BorderExtent.html" title="enum in org.apache.poi.ss.usermodel"><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=1763400&r1=1763399&r2=1763400&view=diff ============================================================================== --- poi/site/publish/spreadsheet/quick-guide.html (original) +++ poi/site/publish/spreadsheet/quick-guide.html Wed Oct 5 10:39:34 2016 @@ -371,6 +371,10 @@ if (VERSION > 3) { </li> <li> +<a href="#DrawingBorders">Drawing Borders</a> +</li> + +<li> <a href="#PivotTable">Create a Pivot Table</a> </li> @@ -1758,7 +1762,7 @@ Examples: <a name="Outlining"></a> - <a name="Outlining-N103EC"></a> + <a name="Outlining-N103F1"></a> <div class="h2"> <h2>Outlining</h2> </div> @@ -1805,7 +1809,7 @@ Examples: <a name="Images"></a> - <a name="Images-N10409"></a> + <a name="Images-N1040E"></a> <div class="h3"> <h3>Images</h3> </div> @@ -3026,6 +3030,99 @@ the data to populate another drop down l exist, it is added. This method will not remove CellStyle properties. </p> + +<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> + +<p> + Enums: + </p> + +<dl> + +<dt>BorderStyle</dt> + +<dd> + Defines the look of the border, is it thick or thin, solid or dashed, single or double. + This enum replaces the CellStyle.BORDER_XXXXX constants which have been deprecated. The PropertyTemplate will not + support the older style BORDER_XXXXX constants. A special value of BorderStyle.NONE will remove the border from + a Cell once it is applied. + </dd> + +<dt>BorderExtent</dt> + +<dd> + Describes the portion of the region that the BorderStyle will apply to. For example, TOP, BOTTOM, INSIDE, or OUTSIDE. + A special value of BorderExtent.NONE will remove the border from the PropertyTemplate. When the template is applied, + no change will be made to a cell border where no border properties exist in the PropertyTemplate. + </dd> + +</dl> + +<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), + BorderStyle.MEDIUM, PropertyTemplate.Extent.ALL); + // #2) these cells will have medium outside borders and thin inside borders + pt.drawBorders(new CellRangeAddress(5, 7, 1, 3), + BorderStyle.MEDIUM, PropertyTemplate.Extent.OUTSIDE); + pt.drawBorders(new CellRangeAddress(5, 7, 1, 3), BorderStyle.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), + BorderStyle.MEDIUM, IndexedColors.RED.getIndex(), + PropertyTemplate.Extent.OUTSIDE); + pt.drawBorders(new CellRangeAddress(9, 11, 1, 3), + BorderStyle.MEDIUM, IndexedColors.BLUE.getIndex(), + PropertyTemplate.Extent.INSIDE_VERTICAL); + pt.drawBorders(new CellRangeAddress(9, 11, 1, 3), + BorderStyle.MEDIUM, IndexedColors.GREEN.getIndex(), + PropertyTemplate.Extent.INSIDE_HORIZONTAL); + pt.drawBorders(new CellRangeAddress(10, 10, 2, 2), + BorderStyle.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 BorderStyle.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 + BorderStyle.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="PivotTable"></a> <a name="Creating+a+Pivot+Table"></a> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
