poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject 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/
Date Mon, 01 Aug 2016 11:56:42 GMT
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


Mime
View raw message