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 11:56:42 UTC
svn commit: r1754737 [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/
Modified: poi/site/publish/apidocs/overview-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/overview-tree.html?rev=1754737&r1=1754736&r2=1754737&view=diff
==============================================================================
--- poi/site/publish/apidocs/overview-tree.html (original)
+++ poi/site/publish/apidocs/overview-tree.html Mon Aug 1 11:56:41 2016
@@ -384,7 +384,6 @@
<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>
@@ -3471,7 +3470,6 @@
<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=1754737&r1=1754736&r2=1754737&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/quick-guide.html (original)
+++ poi/site/publish/spreadsheet/quick-guide.html Mon Aug 1 11:56:41 2016
@@ -375,10 +375,6 @@ if (VERSION > 3) {
</li>
<li>
-<a href="#DrawingBorders">Drawing Borders</a>
-</li>
-
-<li>
<a href="#RichText">Cells with multiple styles</a>
</li>
@@ -1753,7 +1749,7 @@ Examples:
<a name="Outlining"></a>
- <a name="Outlining-N103F1"></a>
+ <a name="Outlining-N103EC"></a>
<div class="h2">
<h2>Outlining</h2>
</div>
@@ -1800,7 +1796,7 @@ Examples:
<a name="Images"></a>
- <a name="Images-N1040E"></a>
+ <a name="Images-N10409"></a>
<div class="h3">
<h3>Images</h3>
</div>
@@ -3051,74 +3047,6 @@ 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